Informatica Powercentre

Key Responsibilities:

• Design, develop, and implement ETL processes using Informatica Power Center to extract, transform, and load data from various sources.
• Analyze business requirements and translate them into technical solutions.
• Optimize existing ETL jobs for performance, scalability, and reliability.
• Perform unit testing, integration testing, and support UAT phases.
• Ensure data accuracy, integrity, and consistency across all data sources and destinations.
• Create and maintain technical documentation and data flow diagrams.
• Collaborate with data architects, DBAs, business analysts, and QA teams.
• Troubleshoot production issues and provide timely resolutions.

Key Skills Required:

• Proficiency in Informatica Power Center (v9.x or higher)
• Strong understanding of ETL best practices, data profiling, and performance tuning
• Experience working with relational databases (Oracle, SQL Server, Teradata, etc.)
• Solid SQL and PL/SQL skills for data validation and transformation logic
• Familiarity with data warehousing concepts (star/snowflake schema, SCDs, fact/dimension tables)
• Experience with workflow scheduling tools like Control-M, Autosys, or TWS is a plus
• Knowledge of Informatica Administration and version control is an advantage