Data Warehouse Engineer

About Codeworks: Codeworks, an LRS Company, has over 25 years of experience serving Fortune 500-1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive. Location: Hybrid (Onsite T/W/Th as required) in Madison, WI Experience Level: Mid‑Senior (4+ years) Focus: Informatica IDMC, Data Warehousing, ETL Development, SQL Who We’re Looking For: We are seeking a highly skilled ETL/Data Integration Developer with strong hands-on experience in Informatica Intelligent Data Management Cloud (IDMC) to design, develop, test, and implement enterprise data integration solutions. This role is heavily focused on building scalable, secure, high‑performing data pipelines, optimizing data workflows, and supporting a modern cloud-based data warehousing environment. The ideal candidate brings real-time experience with data warehousing processes, advanced SQL capabilities, and a solid understanding of relational database technologies. This role requires strong analytical skills, independent judgment, and the ability to collaborate effectively with business and IT stakeholders. Responsibilities: Design, develop, and implement ETL solutions using Informatica IDMC, including mappings, task flows, reusable transformations, and parameter files. Translate functional requirements into well-architected data integration solutions aligned with data warehouse best practices. Develop detailed ETL mapping specifications, ensuring data quality, integrity, and lineage. Perform performance tuning of ETL processes, SQL queries, and database interactions. Manage and maintain metadata, enforce data security standards, and ensure compliance with enterprise policies. Support migration efforts, including PowerCenter‑to‑IDMC transitions and workflow modernization. Collaborate with cross-functional teams on requirements gathering, design sessions, testing, and implementation. Participate in quality assurance activities, including test planning, test case development, and defect identification. Provide ongoing support, issue resolution, documentation, and enhancements to ETL workflows and data integration processes. Ensure deliverables align with SDLC phases, organizational standards, and project timelines. Qualifications: 4 years relevant experience in data warehousing and ETL development. 3 years hands‑on experience with Informatica IDMC (DI, Taskflows, mappings, reusable transformations). Moderate experience with data warehousing process design, performance optimization, and ETL tuning. Strong knowledge of relational database technologies (Oracle, DB2, SQL Server). Advanced SQL skills, including complex query writing and analysis. Experience with: • Data modeling (relational & dimensional) • Slowly changing dimensions (SCDs) • Diagnosing and remediating ETL and database performance issues Strong verbal and written communication skills, including facilitation with technical and business stakeholders. Experience working within SDLC methodologies: planning, analysis, design, coding, testing, implementation, and support. Ability to work independently and collaboratively, manage multiple tasks, and meet deadlines with minimal supervision. Proficiency with MS Office, Visio, Outlook, and Jira. Codeworks discloses that the anticipated hourly pay range for this position is between $35 and $45. This range is subject to change based on job-related factors, including client requirements where applicable. All full time Codeworks employees are eligible to enroll in the company’s benefits plan. Codeworks, an LRS Company, is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status. In some cases, LRS Consulting uses generative artificial intelligence (“AI”) in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. Please contact AI.Questions@lrs.com with any questions.