ETL Tester

TechDigital Group; Rosemont (IL); On-site; USD 80,000 - 120,000; Full time

Job summary

An innovative firm is seeking a skilled contractor with extensive experience in data warehouse testing and BI reporting. This role involves working on complex data models and big data projects, ensuring robust testing of back-end systems and ETL processes. The ideal candidate will possess strong SQL skills and hands-on experience with cloud services like AWS and Azure. You'll be responsible for developing test plans, preparing test cases, and evaluating overall testability in medium to large projects. If you thrive in a dynamic environment and have a passion for data, this opportunity is perfect for you.

Qualifications

• 7+ years in data warehouse testing and BI reporting.
• Strong SQL skills and hands-on experience with cloud services.

Responsibilities

• Conduct testing for data warehouses and complex data models.
• Analyze requirements and develop comprehensive test plans.

Skills

Data Warehouse Testing

SQL

Back-end/ETL Testing

Big Data Projects

Test Plan Development

Test Case Preparation

Data Mart Testing

Tools

AWS

Azure

IICS

SSMS

Oracle

Workbench

Snowflake

Merlin

Tableau

Sigma

Job description

Job #: 2252
Pay Rate: Not Specified
Job type: contractor
Location: Rosemont, IL

Responsibilities

• 7+ years of work experience, particularly in data warehouse testing, complex data models, BI reporting, big data projects.
• Extensive exposure to Back-end/ETL testing with strong SQL skills is a must.
• Hands-on experience with Cloud services such as AWS, Azure, IICS.
• Experience working with databases like SSMS, Oracle, Workbench, Snowflake.
• Experience working with reporting tools such as Merlin, Tableau, Sigma.
• Experience analyzing stories, acceptance criteria, general requirements, developing test plans, test cases, and preparing test data, including evaluating the overall testability.
• Experience testing multiple test phases in medium to large projects.
• Experience handling multiple concurrent priorities with limited oversight.
• Should have adequate experience and a clear understanding of data warehouse and data mart testing.

Nice to Have

• Knowledge of FiveTran, DBT, Airflow, Great Expectations is a PLUS.
• Data automation experience using Great Expectations, TabJolt, DataBricks, RightData etc., is a PLUS.
• Experience working in food and transportation industry is a PLUS.