Data Engineer – Data Integration / Informatica Developer

About this job

Experience: 6 – 10 Years

Required Skills

Informatica PowerCenter, ETL Development, Informatica Mappings, Workflows, PL/SQL, SQL, Stored Procedures, Triggers, Packages, Informatica IDQ, Data Analysis, Performance Tuning, Troubleshooting

Job Summary

We are looking for an experienced Informatica Developer with strong hands-on expertise in ETL development, Informatica mappings and workflows, and PL/SQL programming. The candidate should be proficient in designing, developing, and enhancing ETL processes, optimizing database queries, and performing data analysis using SQL and Informatica IDQ.

Key Responsibilities

• Design, develop, maintain, and enhance ETL workflows using Informatica.
• Develop and maintain Informatica mappings and workflows to support data integration requirements.
• Write efficient and optimized PL/SQL queries, stored procedures, triggers, and packages.
• Perform data analysis and validate source data using SQL queries and Informatica IDQ.
• Troubleshoot ETL failures and resolve data processing issues.
• Perform performance tuning and optimize ETL workflows and database queries.
• Ensure data accuracy, consistency, and quality across data integration processes.
• Collaborate with technical teams and business stakeholders to understand data requirements.

Mandatory Skills

• 6+ years of experience in Informatica development.
• Hands-on experience with Informatica mappings and workflows.
• Strong knowledge of ETL development and data integration.
• Expertise in PL/SQL, including queries, stored procedures, triggers, and packages.
• Strong SQL skills for data analysis and validation.
• Experience with Informatica IDQ.
• Knowledge of ETL troubleshooting and performance tuning.

Preferred Skills

• Strong analytical and problem-solving skills.
• Experience in data quality analysis and validation.
• Ability to troubleshoot complex data integration issues.

Pay: ₹1,100,000.00 - ₹1,300,000.00 per year

Work Location: In person