→ IDMC IICS Technical Lead /Developer Cincinnati, OHIO - Onsite View & apply

Zyntek; Cincinnati, Northern (OH, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Zyntek is seeking a senior Data Engineer to lead enterprise-grade data solutions. You will drive IDM/IDMC implementations, Snowflake-powered data models, and scalable ETL/ELT pipelines across onshore and offshore teams. Strong leadership, architecture review skills, and cloud experience are essential.

You will mentor engineers, collaborate with stakeholders, and ensure delivery on tight timelines while maintaining high standards for data quality and security.

Qualifications

• 10+ years hands-on experience with Informatica IDM/ICS including ETL/ELT development.
• 5+ years with Intelligent Data Management Cloud (IDMC), CDI, CAI, CDQ, and metadata management.
• Enterprise-scale data integration using IDM/CI/CS and Snowflake with data modeling.
• Strong data warehousing, data lake, and modern data platform concepts.
• Experience leading technical teams and coordinating onshore/offshore delivery.

Responsibilities

• Lead architecture reviews, solution reviews, and enforce standards.
• Mentor Data Engineers and drive delivery across teams.
• Design and implement scalable data pipelines (batch and real-time).
• Collaborate with stakeholders, architects, and leadership to shape solutions.

Skills

Informatica IDM

Informatica CDI

Informatica CAI

Informatica CDQ

Data Governance

Metadata Management

ETL/ELT design

Snowflake data modeling

Snowflake architecture

SQL development

Data Warehousing

IDMC

Real-time data pipelines

Cloud platforms (Azure/AWS/GCP)

Tools

Snowflake

Snowflake Cortex

Snowpark

AIML integrations

IDMC

Informatica MDM

Informatica Data Catalog

Git

CI/CD

Python

Shell Scripting

Job description

Technical Skills Primary:Strong handsone experience of minimum 10 years with Informatica with 5 year experience in Intelligent Data Management Cloud IDMC including CDI CAI CDQ Data Governance and Metadata ManagementExpertise in designing developing and implementing enterprise scale ETLELT solutions using IDMCIICSStrong experience with Snowflake including architecture data modeling SnowSQL virtual warehouses streams tasks dynamic tables data sharing and performance optimizationExperience integrating data across cloud and on premise platforms using IDMC and SnowflakeStrong proficiency in SQL development query optimization data transformations and database performance tuningExperience designing scalable batch and real-time data pipelinesDeep understanding of Data Warehousing Dimensional Modeling Data Lake and Modern Data Platform architecturesStrong knowledge of Azure AWS or GCP cloud platformsAbility to perform architecture reviews solution reviews and enforce development standards and best practicesExperience leading technical teams mentoring Data Engineers and driving delivery across onshore offshore teamsStrong understanding of data quality governance metadata and security principlesTechnical Skills (Secondary Nice to have NOT Mandatory):Experience with Python Shell Scripting Git CICD and release management practicesExperience with Snowflake Cortex Snowpark and AIML integrationsExposure to Informatica MDM Data Catalog and Data MarketplaceExposure to Data Quality Data Observability and Master Data Management solutionsInsurance or Financial Services domain experienceSoft SkillsStrong leadership and team management capabilitiesExcellent verbal and written communication skillsAbility to collaborate effectively with business stakeholders' architects and leadership teamsStrong analytical troubleshooting and problem-solving skillsAbility to manage multiple priorities and deliver under tight timelinesHigh level of ownership accountability and customer focusStrong presentation documentation and stakeholder management skillsAbility to influence technical decisions and drive engineering excellenceStrong mentoring and coaching capabilitiesEscalation management and conflict resolution skillsExperience managing global onshore offshore delivery teamsQualifying Questions:1) Does the candidate have at least 10 years of handsone experience with Informatica IDMCIICS including ETLELT development and implementation using CDI CAI CDQ Data Governance or Metadata Management2) Does the candidate have strong handsone experience with Snowflake including data modeling performance tuning virtual warehouses streams tasks dynamic tables and enterprise scale data integration.3) Does the candidate have experience leading Data Engineering teams performing solution architecture reviews and managing onshore/offshore delivery teams.Need to productive by 03rd Aug 2026 without visa issues.