Etl/dwh Tester

**Req number**: R4379
**Employment type**: Full time
**Worksite flexibility**: Remote 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 Description**:
We are looking for a ETL Tester to ensuring the quality and reliability of our data integration processes. This position will be full-time and remote.
What You’ll Do
We are looking for an experienced ETL Tester to join our team. As an ETL Tester, you will be responsible for ensuring the quality and reliability of our data integration processes. Your expertise in SQL programming, ETL tools, and data warehousing concepts will be crucial in validating data transformations and ensuring data integrity across our systems.

**Responsibilities**:
**SQL Programming**: Develop, execute, and maintain complex SQL queries to validate ETL processes.
**ETL Tools**: Use your proficiency in at least one ETL tool to design, develop, and test ETL processes.
**Automation**: Automate test scripts using SQL automation to streamline the testing process.
**Relational Databases**: Utilize your understanding of relational databases to support data validation and testing tasks.
What You'll Need
**Required**:
**Experience**: Minimum of 3+ years in ETL testing.
**SQL Expertise**: Solid knowledge and experience in writing complex SQL queries and using SQL for automation testing.
**Database Knowledge**: Strong understanding of relational databases.
**ETL Tools**: Proficiency in at least one ETL tool (e.g., Informatica, Talend, SSIS).
**Data Concepts**: Familiarity with data modeling and data warehousing concepts;;
1 year+ experience with Databricks GCP (Google Cloud Platform)
**Additional Skills (Preferred but not required)**:
Experience with data quality tools and data profiling.
Knowledge of scripting languages (e.g., Python, Shell scripting).
Familiarity with cloud-based ETL tools and services.
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