Data Warehousing/ETL Consultant

Location:Cincinnati, OHSalary:$60.00 USD Hourly - $70.00 USD HourlyDescription:Our client is currently seeking a Data Warehousing/ETL Consultant Key ResponsibilitiesRewrite and refactor existing ETL/data movement logic to support new upstream data sources while preserving existing warehouse structuresDesign, develop, and optimize complex SQL queries for data extraction, transformation, validation, and performance tuningBuild, modify, and maintain integrations using Informatica Intelligent Cloud Services (IICS) - Data Integration moduleDevelop and enhance SSIS packages and SQL Server Agent jobs using Microsoft Visual StudioAnalyze source-to-target mappings and ensure data accuracy, completeness, and performanceCollaborate closely with internal data engineers, analysts, and architects in a team-based environmentTroubleshoot and resolve ETL failures, data quality issues, and performance bottlenecksParticipate in code reviews and follow established development and deployment standardsRequired QualificationsExtensive hands-on experience developing, executing, and optimizing complex SQL queriesStrong, recent experience with Informatica Intelligent Cloud Services (IICS) - specifically the Data Integration moduleExperience with Informatica PowerCenter alone will not be sufficientProven experience creating and modifying SSIS packages and jobs in Microsoft Visual StudioSolid understanding of data warehousing concepts, ETL patterns, and relational database designAbility to work independently while also collaborating effectively within a teamStrong problem-solving skills and attention to detailBy providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.Contact:This job and many more are available through The Judge Group. Please apply with us today!

Created: 2026-05-09