ETL Tester

ETL Tester

Req number : R6494

Employment type : Full time

Worksite flexibility :

Remote

Who we are

CAI is a global technology services firm with over 8500 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 rightwhatever 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 a motivated ETL Tester ready to take us to the next level! If you have strong validating ETL processes performing database and data testing and ensuring the integrity and are looking for your next career move apply now.

Job Description

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 Youll 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 Youll 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 or (888).

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full-Time

Experience : years

Vacancy : 1