Description

Lead the design, development, and implementation of ETL processes and data integration workflows using Informatica PowerCenter.

This role is on-site.

Responsibilities

• Design and implement ETL processes using Informatica PowerCenter.
• Optimize and tune existing Informatica processes to improve performance and scalability.
• Mentor junior developers to ensure adherence to coding standards and best practices.
• Troubleshoot data integration issues and perform root cause analysis for job failures.
• Manage and schedule ETL jobs using Control M to ensure successful data loads and migrations.

Required Skills

• 7+ years of experience in Informatica PowerCenter development and ETL processes.
• Strong knowledge of SQL and relational databases including SQL Server, Oracle, MySQL, or DB2.
• Experience with SSIS ETL packages and ETL development.
• Proficiency in SQL Server testing.
• Experience with Control M for job scheduling.
• Deep understanding of data warehousing concepts and dimensional modeling.
• Strong analytical, problem-solving, and debugging skills.

Preferred Skills

• Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Proficiency in performance tuning of complex ETL jobs.

Key Skills

Education

Any Graduate