Informatica IDMC Developer

Job Overview

Job Description

411_2675895

Join to apply for the Informatica IDMC Developer role at Dicetek LLC

Summary: Experienced Informatica IDMC Developer with 6+ years in data integration and real-time data solutions. Skilled in designing end-to-end data pipelines using IDMC for effective migration and transformation across cloud platforms. The ideal candidate will have in-depth knowledge of Informatica Intelligent Data Management Cloud (IDMC) , specifically Cloud Data Integration (CDI) and Cloud Data Integration – Real-Time (CDIR)/Cloud Mass Ingestion (CMI) . A strong foundation in Data Warehousing concepts and proficiency in Snowflake and SQL is essential. Strong team player with agile experience, delivering timely, high-impact data solutions.

Technical Skills

  • Tools: Informatica Cloud Data Integration, Real-Time Integration (CDIR)
  • Data Warehousing: Snowflake, DataLake
  • Programming: SQL, PL/SQL, Python
  • Data Management: Storage management, quality monitoring, governance
  • Modeling: Dimensional modeling, star/snowflake schema
  • Other Tools: Git, JIRA, Confluence

Core Competencies

  • Builds and optimizes ETL/ELT pipelines with IDMC and Snowflake for batch and real-time transformations.
  • Design, develop, and implement ETL/ELT processes using Informatica IDMC tools (CDI, CDIR/CMI).
  • Extract data from various sources, including relational databases, APIs, and flat files.
  • Collaborate with stakeholders to gather requirements and translate them into robust ETL workflows.
  • Integrate and transform data to populate Snowflake data warehouses and other storage systems.
  • Leverage Oracle Fusion data extraction techniques for seamless integration.
  • Maintain and optimize ETL performance, including error handling and data quality assurance.
  • Document technical specifications, workflows, and processes for future reference.
  • Collaborate with cross-functional teams to ensure alignment with business objectives.
  • Proficient in troubleshooting and optimizing data pipelines for performance and reliability.

Professional Experience

  • Informatica Developer: Developed ELT processes using IDMC to integrate data into Snowflake. Implemented storage management for Azure Blob and Snowflake, enhancing data security. Established automated data quality monitoring for accuracy and completeness.
  • Real-Time/Near-Realtime Data Integration Specialist: Led Snowflake projects with real-time data pipelines and IDMC integration. Built data quality frameworks and automated cleansing routines. Managed real-time and batch data flows, ensuring data consistency for analytics.

Employment Details

  • Seniority level: Senior
  • Employment type: Contract
  • Job function: IT Services and IT Consulting

#J-18808-Ljbffr

2025-11-11 12:38:29