IDMC Technical Lead

Smart IT Frame

Cincinnati, OH, United States

3 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Microsoft Azure Cloud Computing Data Governance Data Infrastructure Data Integration Data Transformation Data Sharing Data Warehousing Dimensional Modeling Data Intelligence Meta-Data Management

+7 more

Performance Tuning Query Optimization Google Cloud Snowflake Database Optimization Data Lakes Data Pipelines

Requirements

Strong handson experience of minimum 10 years with Informatica with 5 year expererince in Intelligent Data Management Cloud IDMC including CDI CAI CDQ Data Governance and Metadata Management

Expertise in designing developing and implementing enterprisescale ETLELT solutions using IDMCIICS

Strong experience with Snowflake including architecture data modeling SnowSQL virtual warehouses streams tasks dynamic tables data sharing and performance optimization

Experience integrating data across cloud and onpremise platforms using IDMC and Snowflake

Strong proficiency in SQL development query optimization data transformations and database performance tuning

Experience designing scalable batch and realtime data pipelines

Deep understanding of Data Warehousing Dimensional Modeling Data Lake and Modern Data Platform architectures

Strong knowledge of Azure AWS or Google Cloud Platform cloud platforms

Ability to perform architecture reviews solution reviews and enforce development standards and best practices

Experience leading technical teams mentoring Data Engineers and driving delivery across onshoreoffshore teams

Strong understanding of data quality governance metadata and security principles