ETL Developer with IDMC

Zensar is Hiring !!

Immediate Joiners and Serving Notice period candidates only)

Location :Noida

Job Description:

• Required Skills:

• Hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC/IICS).
• Experience in designing, developing, and maintaining ETL/ELT pipelines using IDMC services such as Data Integration, Mass Ingestion, Cloud Data Integration, Cloud Application Integration, and Data Quality.
• Exposure to cloud platforms like AWS, Azure, or GCP.
• Strong SQL skills with experience in writing complex queries and performance tuning.
• Solid understanding of data warehousing concepts and dimensional modeling.
• Strong hold on end-to-end data flow understanding.
• Implement data validation, reconciliation, and error-handling mechanisms.
• Experience with job scheduling tools and UNIX/Linux shell scripting.
• Familiarity with version control systems (Git/SVN) and Agile methodologies.
• Excellent problem-solving and analytical skills

• Preferred Skills:

• Experience in cloud data migration and modernization projects using Informatica IDMC.
• Integration experience with BI tools like Power BI.
• Knowledge of big data technologies (Hadoop, PySpark).
• Experience with Python or Java for scripting and automation.
• Understanding of metadata management, data lineage, and data governance concepts.
• Exposure to Informatica Data Quality (IDQ), Master Data Management (MDM), and Cloud Data Governance & Catalog (CDGC) within the IDMC ecosystem.