IDMC IICS Technical Lead
LTM · Cincinnati, OH · 3 days ago
On-siteEngineeringFull-time
About the role
The role of Technical Lead for IDMC IICS focuses on leading the design, development, and implementation of enterprise-scale ETL/ELT solutions using Informatica IDMCIICS. This includes expertise in data governance, metadata management, and modern data platform architectures.
Responsibilities
- Lead the design, development, and implementation of ETL/ELT solutions using Informatica IDMCIICS.
- Design and implement data governance and metadata management strategies.
- Develop and optimize data pipelines for both batch and real-time processing.
- Collaborate with business stakeholders and architects to ensure alignment with business needs and technology standards.
- Manage and mentor a team of Data Engineers, ensuring high-quality project delivery.
- Perform architecture reviews and solution reviews to enforce development standards and best practices.
- Ensure compliance with data quality, governance, and security principles.
Requirements
- Minimum 10 years of hands-on experience with Informatica IDMCIICS, including ETL/ELT development and implementation using CDI, CAI, CDQ, Data Governance, or Metadata Management.
- Strong experience with Snowflake, including data modeling, performance tuning, virtual warehouses, streams, tasks, dynamic tables, and enterprisescale data integration.
- Experience leading Data Engineering teams, performing solution architecture reviews, and managing onshore/offshore delivery teams.
Qualifications
- Comprehensive understanding of Data Warehousing, Dimensional Modeling, Data Lake, and Modern Data Platform architectures.
- Knowledge of Azure, AWS, or GCP cloud platforms.
- Experience with Python, shell scripting, Git, CI/CD, and release management practices.
- Exposure to Informatica MDM, Data Catalog, and Data Marketplace.
- Experience with Snowflake Cortex, Snowpark, and AIML integrations.
- Understanding of data quality, governance, metadata, and security principles.
Skills
- Strong proficiency in SQL development, query optimization, and database performance tuning.
- Leadership and team management capabilities.
- Excellent verbal and written communication skills.
- Ability to collaborate effectively with business stakeholders, architects, and leadership teams.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to manage multiple priorities and deliver under tight timelines.
- High level of ownership, accountability, and customer focus.
- Strong presentation, documentation, and stakeholder management skills.
- Influence technical decisions and drive engineering excellence.
- Escalation management and conflict resolution skills.
- Experience managing global onshore/offshore delivery teams.
Benefits
- Comprehensive Medical Plan
- Short Term and Long-Term Disability Coverage
- 401(k) Plan with Company match
- Life Insurance
- Vacation Time, Sick Leave, Paid Holidays
- Paid Paternity and Maternity Leave
Pay
Actual compensation will be determined based on individual skills, experience, performance, and internal equity.
Schedule
Need to be productive by August 03, 2026, without visa issues.