Data Warehouse Engineer

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

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

4.34.3 out of 5 stars Madison, WI 53703 $45 - $52 an hour - Contract

Peoplelink LLC, a leader in the staffing industry for the past 33 years, continues our vision of 'linking' communities through employment. TeamSoft's dedication to the safety, health & well-being of our associates, clients and communities remains our #1 priority. TeamSoft is proud to be an EEOE, M/F/D/V, and we are committed to diversity both in practice and spirit at all levels of the organization.