Data Warehousing ETL Consultant

Cincinnati, OH - USA

Monthly Salary: Not Disclosed

Posted on: 9 hours ago

Vacancies: 1 Vacancy

Job Summary

Data Warehousing / ETL Consultant

Location: Cincinnati OH (Onsite Day 1)

Duration: 6 Months (Immediate Start)

Interview: Video

Manager Notes (Important)

Need consultants with identical skill sets

The role focuses on rewriting ETL pipelines for new data sources

Only local candidates within a 1-hour drive distance

Old LinkedIn with location

Overview

We are seeking two senior-level Data Warehousing / ETL Consultants to support a critical data modernization initiative.

The consultants will work closely with the internal data team to rewrite and refactor existing ETL/data movement processes enabling integration of new upstream data sources into existing data warehouse structures.

Required Skills

Strong hands-on experience with advanced SQL development and optimization
Recent and deep experience with Informatica Intelligent Cloud Services (IICS Data Integration module)
Note: Informatica PowerCenter alone is NOT sufficient
Proven experience with SSIS (SQL Server Integration Services) using Microsoft Visual Studio
Solid understanding of data warehousing concepts ETL design patterns and relational databases
Strong troubleshooting problem-solving and analytical skills
Ability to work both independently and collaboratively

Qualifications

Experience in enterprise data environments (on-prem or hybrid)
Prior experience modernizing or rewriting legacy ETL pipelines
Familiarity with SQL Server-based data warehouse systems

Data Warehousing / ETL Consultant Location: Cincinnati OH (Onsite Day 1) Duration: 6 Months (Immediate Start) Interview: Video Manager Notes (Important) Need consultants with identical skill sets The role focuses on rewriting ETL pipelines for new data sources Only local candidates within a 1...