Data Warehouse Developer

Job Description 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. Primary Responsibilities Data Integration & ETL Development 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. Support migrations, including PowerCenter → IDMC modernization efforts. Perform performance tuning for ETL workflows, SQL queries, and database operations. Collaboration & Requirements 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. Testing & Quality Assurance 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. Documentation & Operational Support 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. Required Skills & Experience- Approx. 4+ years, or equivalent experience 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 experience. The range displayed reflects the minimum and maximum target for new hires of this position across all U.S. locations. Individual pay is determined by work location and additional job-related factors. 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, Codeworks, an LRS company, uses generative artificial intelligence ("AI") in support of our hiring processes. Codeworks 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 with any questions.

Created: 2026-03-10