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

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:
1. Design, develop, maintain, and enhance ETL workflows using Informatica.
2. Develop and maintain Informatica mappings and workflows to support data integration requirements.
3. Write efficient and optimized PL/SQL queries, stored procedures, triggers, and packages.
4. Perform data analysis and validate source data using SQL queries and Informatica IDQ.
5. Troubleshoot ETL failures and resolve data processing issues.
6.



Perform performance tuning and optimize ETL workflows and database queries.
7. Ensure data accuracy, consistency, and quality across data integration processes.
8. 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.
- Robust 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

📌 Data Engineer – Data Integration / Informatica Developer (Gurugram)
🏢 Classic Solutions
📍 Gurugram