01 Nov
|
Classic Solutions
|
Gurugram
01 Nov
Classic Solutions
Gurugram
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.
- Strong knowledge of ETL development and data integration.
- Expertise in PL/SQL, including queries, stored procedures, triggers, and packages.
- Solid 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 (Gurugram)
🏢 Classic Solutions
📍 Gurugram