Informatica Powercentre

Job Description 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