CTG ETL Designer in Des Moines, Iowa

Title: ETL Designer

Location: US-IA-Des Moines

Other Locations: US-TX-Austin

Job Number: 18203496

CTG has an excellent opportunity available! Are you looking to grow your career and skill set in an exciting new role?

Job Title: ETL Designer

Location: Austin, TX or Des Moines, IA

Job Type: contract

Pay Range: Competitive

Work Hours: Monday – Friday, 8 am – 5 pm

Senior ETL Designer responsible for the designing and loading of new data warehouses efficiently from our new data lake platform.

Responsible for data validation, data cleansing, and data transformation, as well as writing and scheduling complex ETL jobs.

Includes analyzing and understanding the data transformation rules required to extract and transform and load the new Data Lake and the downstream Client Data Warehouses or BI solutions.

Experience with Pentahoe Kettle is required.

Experience with Amazon Glue is a major plus.


Perform complex ETL coding using Pentaho Kettle or Amazon Glue, database programming using MySQL, DB2 or MariaDB and batch scheduling and scripting tools.

Perform build, test and deploy. Utilizes advanced technologies and methods to integrate data systems and other existing platforms such as AWS EMR, S3 and Elasticsearch.

Design and build system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target application.

Define and manage the data load procedures; facilitate the change data capture.

In addition to developing new mappings / ETL jobs, you will also be responsible for automation, monitoring and supporting mappings, and re-designing if required to make them run faster and more reliable.

Provide analysis and issue resolution on business reported concerns. Participate in design and delivery of cubes, dashboards and various self-service business intelligence solutions.

Using various resources, continually learns, studies, and applies new information in fast paced, dynamic technical environment.


Seven or more years of progressively complex programming/analysis experience. Successful record in design and implementation of complex, multi-programming projects.

Proven successful technical leadership, consultative application of technical and management principles to others, and design skills.

Strong analysis and design skill and strong experience with Kimball Dimensional modeling.

Strong experience with business intelligence and data warehousing design principles and industry best practices.

Excellent written, verbal, and presentation skills.

Experience documenting procedures for solving business problems.

Additional Information:

  • No third party resumes will be accepted

  • Drug testing and/or other employment-related inquiries may be conducted

  • All interested individuals MUST be able to work on a W2 Tax basis (no C2C or third party vendors)!

  • Candidates must currently reside in USA or Canada

  • CTG is an Equal Employment Opportunity employer

  • CTG is an E-Verify Company

To be considered for this opportunity, please apply directly through our website by clicking the link below or email your Word version resume and salary requirements to johna.rogers@ctg.com.


CTG (NASDAQ: CTG) provides industry-specific IT services and solutions that address the business needs and challenges of clients in high-growth industries in North America and Western Europe. CTG also provides strategic staffing services for major technology companies and large corporations. Backed by more than 50 years of experience and proprietary methodologies, CTG has a proven track record of reliably delivering high-value, industry-specific staffing services and solutions to its clients. CTG has operations in North America, Western Europe, and India.

CTG's greatest asset is its people, and as such, we are committed to providing employees programs and processes to support their performance, hone their skills, and advance in their careers. This commitment is reflected by CTG being named a Best Places to Work in Healthcare company by Modern Healthcare (2013-2016) in North America, and a Best Workplace in the United Kingdom (2013), Belgium (since 2007), and Luxembourg (since 2011).

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity/Affirmative Action Employer and strong advocate of workforce diversity. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.

Job: Data Warehousing