Data Warehouse Engineer

TeamSoft IT Solutions

Madison, WI, United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Compensation

$93,600.0 - $108,160.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

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

+1 more

Data Pipelines

Job 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

Requirements

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

Benefits & conditions

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

About the company

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.