> Markdown version of [/jobs/ext/90682-data-warehouse-engineer](https://www.wearedevelopers.com/jobs/ext/90682-data-warehouse-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Engineer - **Company:** TeamSoft IT Solutions - **Location:** Madison, WI, United States - **Experience:** Expert - **Salary:** $93,600.0 - $108,160.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Warehousing, IBM DB2, Database Queries, Meta-Data Management, Oracle (Applications), Performance Tuning, Systems Development Life Cycle, Sap Business Objects, Data Pipelines - **Published:** May 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=33c531eadc8421c8 ## About the Role Do you have experience in Validation design?, * 7+ years of experience in Data Warehouse Design & Development * Strong expertise in Informatica ETL development (IDMC preferred) * Experience with data integration, data pipelines, and ETL frameworks * Strong knowledge of relational and dimensional data models (Kimball) * Strong SQL skills and experience with Oracle / DB2 * Experience with SDLC, requirements gathering, and documentation * Experience with testing (unit, system, UAT) * Strong analytical, problem-solving, and communication skills, * Experience with Business Intelligence tools (e.g., Business Objects) * Knowledge of data warehouse best practices and performance optimization * Experience supporting large enterprise environments ## Description Seeking a Data Warehouse Engineer to design, develop, and maintain enterprise data warehouse solutions. This role requires strong expertise in Informatica IDMC, ETL development, and data integration to build scalable, secure, and high-performing data pipelines., * Design, develop, test, and implement ETL solutions using Informatica IDMC * Build and maintain data integration pipelines, taskflows, and mappings * Develop data warehouse architecture, data models, and metadata management * Perform data analysis, performance tuning, and optimization * Ensure data accuracy, data integrity, and security standards * Gather and translate business requirements into technical solutions * Develop and execute test plans, test cases, and validation processes * Monitor and improve data warehouse performance and scalability * Collaborate with technical teams and business stakeholders * Provide guidance and support to junior team members ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Exploring 5 Key Applications of AI Abundance with Blockchain Assurance](https://www.wearedevelopers.com/videos/971-exploring-5-key-applications-of-ai-abundance-with-blockchain-assurance) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)