Informatica Developer

Key Skills: Shell Scripting, UNIX, PowerCenter, SQL Server, ETL, Informatica, CICD

Roles and Responsibilities:

• Design, develop, and maintain ETL/ELT mappings, workflows, taskflows, and data pipelines using Informatica IDMC and PowerCenter.
• Develop efficient and optimized SQL queries for data extraction, transformation, and validation.
• Work with databases such as Oracle, SQL Server, Teradata, or similar relational databases.
• Develop and maintain data integration solutions supporting business and data warehousing requirements.
• Implement SCD, incremental loads, and other data warehousing methodologies.
• Participate in data migration projects, including data extraction, transformation, validation, and loading.
• Develop and maintain Unix/Shell scripts for ETL processing and operational activities.
• Work with Autosys or similar scheduling tools to schedule and monitor ETL jobs.
• Support and maintain CI/CD pipelines for deployment and release management.
• Troubleshoot ETL failures, performance issues, data quality problems, and production incidents.
• Perform unit testing, integration testing, data validation, and defect resolution.

Skills Required:

• Strong experience in Informatica IDMC and PowerCenter.
• Hands-on experience in ETL/ELT mappings, taskflows, workflows, and data pipelines.
• Strong SQL skills with Oracle, SQL Server, Teradata, or similar databases.
• Good understanding of Data Warehousing, Star Schema, SCD, and incremental loads.
• Experience with data migration projects.
• Knowledge of Unix/Shell scripting and Autosys or similar scheduling tools.
• Basic experience with CI/CD pipelines.
• Strong problem-solving and communication skills.
• Ability to work independently and mentor junior developers.
• Banking/Financial Services domain experience is a plus.

Education: Bachelor's Degree in related field