Z

ETL Developer(Informatica & IDMC)

Zensar Technologies · Uttar Pradesh, India

3–10 yrs experiencePosted 1w ago

Job description

- **Location:** Gurugram/Noida - **JD:** - 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