Haystack
← Back to Jobs
Technology
CO

IDMC/Informatica Technical Lead

Compunnel Inc.Cincinnati, OH🇺🇸United StatesPosted 1 Sept 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Cincinnati, OH, United States
Posted
1 week ago
SQLShellAWSETLSnowflakeAzureGitGoogle CloudPythonStakeholder Management

Job Description

Key Responsibilities
Design, develop, and implement enterprise-scale ETL/ELT solutions using IDMC/IICS. Leverage strong hands-on expertise across Informatica IDMC capabilities, including CDI, CAI, CDQ, Data Governance, and Metadata Management. Design and implement scalable batch and real-time data pipelines. Integrate data across cloud and on-premises platforms using IDMC and Snowflake. Design and optimize Snowflake solutions, including architecture, data modeling, SnowSQL, virtual warehouses, streams, tasks, dynamic tables, and data sharing.

Perform Snowflake performance optimization and database performance tuning. Develop and optimize SQL queries and data transformations. Apply strong understanding of Data Warehousing, Dimensional Modeling, Data Lake, and modern data platform architectures. Work with Azure, AWS, or Google Cloud Platform cloud platforms to support enterprise data solutions. Conduct architecture reviews and solution reviews to ensure alignment with technical standards. Establish and enforce development standards, best practices, and engineering guidelines.

Lead technical teams and mentor Data Engineers across project initiatives. Drive successful delivery across onshore and offshore teams. Apply data quality, governance, metadata management, security, and compliance principles across data solutions. Troubleshoot complex data integration, pipeline, performance, and platform issues. Collaborate with business stakeholders, architects, engineering teams, and leadership to define and deliver scalable data solutions. Provide technical guidance and influence engineering decisions to drive delivery excellence.

Required Qualifications
10+ years of experience
Bachelors Degree

Skills
Informatica Intelligent Data Management Cloud (IDMC)
Cloud Data Integration (CDI)
Cloud Application Integration (CAI)
Cloud Data Quality (CDQ)
Data Governance
Metadata Management
ETL/ELT Solutions Design and Implementation
Informatica Intelligent Cloud Services (IICS)
Snowflake
SQL Development
Batch and Real-time Data Pipelines Design
Data Warehousing
Cloud Platforms (Azure, AWS, Google Cloud Platform)
Data Security Principles
Python Scripting
Shell Scripting
Git
CI/CD
Snowflake Cortex
Snowpark
AI/ML Integrations
Informatica MDM
Informatica Data Catalog
Informatica Data Marketplace
Data Observability Solutions
Technical Leadership
Cross-functional Collaboration
Mentoring and Coaching
Delivery Management
Architecture Review
Development Standards Enforcement
Analytical Problem Solving
Written and Verbal Communication
Stakeholder Management
Escalation Management

Schedule
Start date: 2026-09-10

Similar jobs