Data Warehouse Developer

Added Mar 03, 2026 – Data Warehouse Developer (45928) – Madison, WI – Full-time. Apply

For additional information on how we handle your data, see

If you receive a suspicious offer or communication claiming to be from us, do not share any personal or financial information. You can notify us using our contact page at Contact Levi, Ray & Shoup, Inc.

• All legitimate correspondence from our recruiting team will only come from an email address ending in  We do not use generic domains like , , or
• We never conduct interviews solely via text-based chat on Microsoft Teams, Telegram, or Whats App. All virtual interviews involve a scheduled video or phone call with a member of our team.
• LRS will never ask a candidate for payment, fees, or to purchase equipment (e.g., laptops, software) as a condition of employment.
• All genuine job opportunities are listed directly on our official careers portal at Careers.

Codeworks, an LRS company, is seeking a Data Warehouse Developer for a Contract opportunity. This role offers the chance to apply your data integration and warehousing expertise in support of meaningful work for one of our client partners.

The Data Warehouse Developer III will design, develop, test, and implement ETL solutions using Informatica Intelligent Data Management Cloud (IDMC). This role supports scalable, secure data pipelines, metadata management, data quality, and continuous optimization within a data warehouse environment. The individual will work closely with business stakeholders and IT teams to translate requirements into well‑architected data integration solutions following enterprise best practices.

This role typically requires 4+ years of experience, including 3+ years of hands‑on IDMC work.

• Develop and maintain ETL solutions using Informatica IDMC, including Taskflows, Mappings, parameterization, and reusable transformations.
• Build secure, optimized data pipelines and ensure data accuracy, integrity, and consistency across environments.
• Perform performance tuning for ETL workflows, SQL queries, and database operations.
• Work with business and technical teams to understand requirements and translate them into detailed ETL mapping and design specifications.
• Ensure alignment with enterprise data warehousing standards, security requirements, and privacy regulations.
• Participate in meetings, provide updates, and support solution planning and refinement.

• Develop test plans, test cases, test procedures, and document results.
• Identify defects and partner with teams to troubleshoot and resolve issues.
• Support SDLC activities including system testing, integration testing, and validation.

• Maintain clear and accurate documentation for processes, mappings, and workflows.
• Assist with troubleshooting ETL failures and performance bottlenecks.
• Support metadata management, data repository updates, and continuous improvement efforts.

• Experience designing, developing, and optimizing data warehousing solutions using Informatica IDMC.
• Moderate to advanced knowledge of data warehousing concepts and data integration methodologies.
• Strong SQL skills and experience with Oracle, DB2, or SQL Server.
• Experience with Control‑M or similar job‑scheduling/automation tools.
• Experience working with relational and dimensional data models.
• Experience with slowly changing dimensions and common data warehousing patterns.
• Ability to diagnose and resolve ETL and query performance issues.
• Strong communication skills, including facilitating discussions with technical and business users.
• Knowledge of SDLC processes and project methodologies (planning, analysis, design, testing, implementation, support).
• Ability to collaborate effectively in large, cross‑functional organizations.
• Strong organizational, analytical, and time‑management skills.
• Ability to work independently while providing timely updates to leadership.
• Proficiency with MS Office, Visio, Outlook, and Jira.

The base range for this contract position is $35.00 - $45.00 per hour, depending on…