Data Warehousing/ETL Consultant

Key Responsibilities

• Rewrite and refactor existing ETL/data movement logic to support new upstream data sources while preserving existing warehouse structures
• Design, develop, and optimize complex SQL queries for data extraction, transformation, validation, and performance tuning
• Build, modify, and maintain integrations using Informatica Intelligent Cloud Services (IICS) — Data Integration module
• Develop and enhance SSIS packages and SQL Server Agent jobs using Microsoft Visual Studio
• Analyze source‑to‑target mappings and ensure data accuracy, completeness, and performance
• Collaborate closely with internal data engineers, analysts, and architects in a team‑based environment
• Troubleshoot and resolve ETL failures, data quality issues, and performance bottlenecks
• Participate in code reviews and follow established development and deployment standards

Required Qualifications

• Extensive hands‑on experience developing, executing, and optimizing complex SQL queries
• Strong, recent experience with Informatica Intelligent Cloud Services (IICS) — specifically the Data Integration module
• Experience with Informatica PowerCenter alone will not be sufficient
• Proven experience creating and modifying SSIS packages and jobs in Microsoft Visual Studio
• Solid understanding of data warehousing concepts, ETL patterns, and relational database design
• Ability to work independently while also collaborating effectively within a team
• Strong problem‑solving skills and attention to detail

By 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.