Quality Assurance Analyst – ETL Tester

Job not on LinkedIn

🕒 April 29

🌽 Illinois – Remote

🌽 Illinois – Remote

⏳ Contract/Temporary

🟡 Mid-level

🟠 Senior

🔧 QA Engineer (Quality Assurance)

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

DATAMAXIS, Inc

WebsiteLinkedInAll Job Openings

51 - 200 employees

🤖 Artificial Intelligence

🔒 Cybersecurity

☁️ SaaS

Artificial Intelligence • Cybersecurity • SaaS

DATAMAXIS, Inc is a company that specializes in transforming big data into actionable insights for competitive advantage, market growth, and customer satisfaction. They provide services in artificial intelligence, machine learning, digital transformation, cyber security, and analytics. DATAMAXIS helps organizations use data to make informed decisions, minimize cyber risks, and digitize business processes. The company offers data engineering, data governance, business intelligence, data monetization, cloud solutions, and strategic staffing services. With expertise in both traditional and modern data architectures, DATAMAXIS supports various industries including insurance, automobile, and government sectors. They are also known for their cyber security analytics solutions which help protect against intrusions and data loss, while complying with security requirements for government organizations.

📋 Description

• The ETL Tester will be responsible for designing, automating, and executing test cases for Enterprise Data Warehouse (EDW) ETL processes in a State Government Medicaid environment. • Responsible for ensuring the accuracy, integrity, and reliability of data as it moves through ETL processes. • Leverage expertise to design and execute test strategies that validate both functional and non-functional requirements of data pipelines. • Perform backend testing to compare data in source systems to target Medicaid EDW. • Verify source-to-target data mapping and transformation logic for Medicaid datasets. • Validate data quality, standardization rules, and loading accuracy. • Write complex SQL queries to validate ETL outputs against business rules. • Conduct row counts, null checks, duplicate checks, and referential integrity validation. • Design test plans, test cases, and test scenarios for ETL processes. • Document test results and provide detailed feedback to stakeholders, highlighting areas for improvement. • Execute manual and automated tests for both full-load and incremental-load cycles.

🎯 Requirements

• 5+ years of experience in software testing and quality assurance. • 5+ years of experience testing backend, database, EDW, or ETL systems. • 4+ years of strong SQL experience and hands-on work with at least one RDBMS (e.g., Teradata, SQL Server). • 4+ years of experience in UI, smoke, end-to-end, and integration testing. • 4+ years of strong troubleshooting and analytical skills, with the ability to debug and resolve complex technical issues. • 4+ years of experience in test design and working with at least one test management tool. • Bachelor’s degree or higher in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or related field.

🏖️ Benefits

• Health insurance • Flexible work hours • Professional development opportunities