ETL Tester

Req number:

Employment type:

Worksite flexibility:

Who we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are looking for an ETL Tester to execute and validate ETL processes, perform testing of databases and APIs, and ensure data accuracy and integrity. This position will be full-time, long-term contract, and remote.

What You’ll Do

• SQL testing – Validation of source to target

• Database testing

• API testing

• Automation

• Thorough knowledge with ETL (extract, transform, load) process and validation points within the process

• ETL testing experience with Data Stage, Databricks

• Experience executing jobs in ETL software, such as Datastage

• Data testing:

  • Testing in large datasets

  • Missing data

  • Duplicate data

  • Data from different sources

  • Structural errors

  • Data attribute validations

• Experience creating test cases, defects in ADO, JIRA

• Ability to work with other members and follow directions

• Work their scheduled hours

What You'll Need

Required:

• Experience

  :

  5 to 8 years

• Experience with Sql testing, database testing, API testing, and automation

• Thorough knowledge of ETL process and validation

• ETL testing experience with Data Stage and Databricks

• Data testing experience with large datasets, missing data, duplicate data, data from different sources, structural errors, and data attribute validations

• Experience creating test cases and defects in ADO and JIRA

• Ability to work collaboratively and independently

Preferred:

• Familiarity with tools/software:

  • Linux

  • SSMS (SQL Server)

  • Oracle Sql

  • IBM Datastage/Director

  • Google Cloud Platform

  • Talend

  • Databricks

  • PYSPARK

  • JIRA/Azure ADO

• Knowledge of software methodologies:

  • Agile Methodology

  • Waterfall

Physical Demands

• Ability to safely and successfully perform the essential job functions

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.