Previous Job
ETL Programmer Analyst
Ref No.: 19-09995
Category: Experienced Professional
Location: Menomonee Falls, Wisconsin
Position Type:Right to Hire
Start Date / End Date: 01/06/2020 to 07/03/2020
Genesis10 is currently seeking a ETL Programmer Analyst for a contract to hire position working with a healthcare client in the Menomonee Falls, WI area.

Candidate is expected to work independently and possess solid project management and prioritization skills. Has understanding of Data Warehousing concepts, architecture and standards and has demonstrated ability to quickly learn new technologies and processes. Work within formal Change Management methodologies and with a variety of teams and organizations to provide responsive and quality support.

  • Responsible for coding testing debugging and implementing Extract Transform Load (ETL) mappings and workflows.
  • Create document and implement test plans and scripts.
  • Optimize performance of (ETL) mappings processes and load routines.
  • Assist in operationalizing the ETL production environment.
  • Proficient in ETL for data architectures operational data stores and data marts defined by the Data Modeler.
  • Focuses on enterprise-wide data modeling and database design.
  • Understands and articulates logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Optimize and update logical and physical data models to support new and existing projects.
  • Maintain conceptual logical and physical data models along with corresponding metadata.
  • Reviews business requirements and ensures the ETL design meets the goals. Participates in implementing data policy.
  • Understand and translate business needs and data models into supporting long-term ETL solutions.
  • Develop best practices for standard naming conventions and coding practices to ensure consistency in ETL.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Provides thought leadership in enterprise-wide data quality business data stewardship and data modeling project assignments.
  • Ensures data quality in the data warehouse by enforcing data integrity rules.
  • Acts as a technical consultant and adviser to IT Directors and leadership.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Tracks industry trends and maintains knowledge of new technologies to better serve the organization's information needs.
  • Assists in developing long-term strategy for Data Management Services integration with other parts of Information Management and Data Management Services meeting internal customer requirements.

  • Familiarity with PERL/Unix Scripting and MS Excel is preferred.
  • 5 years of solid ETL programming experience is required
  • 5 Years Good knowledge of the SQL Server and Oracle RDBMS environment is required
  • Healthcare Industry experience is preferred
  • IBI WebFOCUS Business Intelligence Tool experience is preferred
  • Prior experience with EPIC applications is preferred - Highly desired
  • SSIS and/or Data Migrator experience working with large data files and understand the components of efficient ETL processes is required

Bachelor's degree in Computer Science Electrical Engineering or related field; in lieu of degree will also consider comb. of education & experience.

If you are a qualified candidate interested in this opportunity, please apply.

About Genesis10:
Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at

"Genesis10 is an Equal Opportunity Employer, M/F/D/V