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.