ETL Tester
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Req number:
R6494Employment type:
Full timeWorksite flexibility:
RemoteWho 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
About Company
CAI helps organizations leverage technology, people, and processes to solve business problems, enable savings, and spur innovation.
