REMOTE || Senior Informatica IDMC Data Engineer || W2 Only
Posted Today by HYR Global Source Inc
Negotiable
Undetermined
Remote
Remote or Hybrid
Summary: The Senior Informatica IDMC Data Engineer role is focused on supporting enterprise data warehouse and ETL modernization initiatives through the design and maintenance of ETL pipelines. The position requires a hands-on engineer with extensive experience in Informatica IDMC and advanced SQL skills, capable of working independently in a dynamic environment. The role is fully remote and is expected to last for 24 months with a possibility of extension. Candidates must have a Bachelor's degree in a related field and a minimum of 10 years of relevant experience.
Key Responsibilities:
- Design, build, and maintain ETL pipelines using Informatica IDMC (CDI).
- Debug and analyze complex datasets using advanced SQL.
- Support data warehouse development and raw data layer creation.
- Identify data issues, inconsistencies, and rule gaps.
- Collaborate with stakeholders to extract and define business rules.
- Work independently to gather requirements and drive deliverables.
Key Skills:
- Strong experience with Informatica IDMC (CDI is mandatory).
- Advanced SQL (debugging, performance tuning, data validation).
- Solid experience in ETL pipeline development in enterprise environments.
- Ability to work independently with minimal guidance.
- Strong communication and analytical skills.
- Experience working with unclear or evolving requirements.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
- Minimum 10 years of experience required...
- Informatica IDMC (CDI)
- SQL
- ETL pipeline development
We are looking for a Senior Data Engineer with strong expertise in Informatica IDMC (CDI) and advanced SQL skills to support enterprise data warehouse and ETL modernization initiatives. This role requires a hands-on engineer who can work independently, debug complex data pipelines, and operate effectively in environments with evolving business rules and limited documentation.
Key Responsibilities
-
Design, build, and maintain ETL pipelines using Informatica IDMC (CDI).
-
Debug and analyze complex datasets using advanced SQL.
-
Support data warehouse development and raw data layer creation.
-
Identify data issues, inconsistencies, and rule gaps.
-
Collaborate with stakeholders to extract and define business rules.
-
Work independently to gather requirements and drive deliverables.
-
Strong experience with Informatica IDMC (CDI is mandatory).
-
Advanced SQL (debugging, performance tuning, data validation).
-
Solid experience in ETL pipeline development in enterprise environments.
-
Ability to work independently with minimal guidance.
-
Strong communication and analytical skills.
-
Experience working with unclear or evolving requirements.
-
IDMC CAI (API/JSON integrations).
-
Python (basic understanding or ability to read code).
-
Experience with APIs, JSON, or data integration frameworks.
-
Exposure to orchestration tools (e.g., JAMS).
-
Familiarity with AI coding tools (e.g., Copilot, Claude).
-
.NET / C# exposure.
T |