ETL Developer - Informatica PowerCenter

Title : Informatica ETL Developer. Location : Remote. Duration : 6months contract role. Notice period 30 days max Experience : 8 Yrs. Of experience relevant to developing and managing ETL on Informatica Power Center. - Design, develop, and implement complex mappings, sessions, and workflows using ETL processes using Informatica PowerCenter. - Identify the problems and Optimize ETL processes for maximum efficiency and performance through performance tuning. - Perform data analysis and data profiling to ensure data quality and integrity. - Must be able to use Informatica Data Quality tools. - Develop and maintain reusable data mappings, workflows, and sessions. - Proficiency in SQL and experience with relational databases (Oracle, SQL Server) with Strong SQL skills for data extraction, transformation, and loading. - Should have experience with data warehousing concepts and techniques. - Must have Knowledge of data modeling and data architecture principles. - Knowledge of big data technologies (Hadoop, Spark, Cloudera). - Troubleshoot and resolve data issues and ETL process failures. - Implement error handling and recovery strategies in ETL processes. - Collaborate with business analysts, data architects, and other stakeholders to understand business requirements and translate them into technical solutions. - Must be able to create detailed requirement documentations like FSD, SDD, TDD, Test Cases, Data Mappings for the requirements to develop and maintain proper versioning. - Ensure compliance with data governance and security policies, data masking, encryption. - Participate in code reviews and provide constructive feedback to peers. - Adhere to coding standards and best practices. - Stay updated with the latest developments in Informatica and data integration technologies. - Ability to work on Service tickets and provide resolution of production issues within defined SLA. - Ability to manage more than one application as primary and secondary owner. - Ability to analyze the problems and provide Root Cause Analysis for the incidents and implement the same. (ref:hirist.tech)

Location: in, IN

Posted Date: 10/27/2024