ETL Tester

SIDMANS, INC.; Minneapolis (MN); On-site; USD 80,000 - 120,000; Full time

Job summary

SIDMANS, INC. is seeking a data quality analyst to support requirement analysis, data validation, and ETL validation for Medicaid data sets. The role focuses on backend testing, source-to-target checks, and ensuring data accuracy across the enterprise data warehouse.

The candidate will design and execute SQL-driven tests, perform data comparisons, and create comprehensive test documentation for stakeholders, aligning with business rules and quality standards.

Qualifications

• Strong SQL and data validation experience.
• Experience with ETL and data warehouses.
• Ability to design test plans and implement validation checks.

Responsibilities

• Requirement Analysis: participate in data modeling and requirements sessions to ensure testing aligns with business needs.
• Data Validation: verify source-to-target data mappings and transformations for Medicaid datasets and EDW quality.
• SQL and Scripting: write complex SQL with multi-table joins to validate ETL outputs against business rules and ensure referential integrity.
• Test Strategy and Execution: design test plans, cases, and scenarios for ETL/warehouse processes and document results for stakeholders.

Skills

SQL

Relational databases

Oracle

SQL Server

PostgreSQL

GitHub usage

Tools

GitHub

Job description

• Requirement Analysis: Participate in data modeling and requirement gathering sessions to ensure testing aligns with business needs
• Strong understanding of Bronze Silver Gold data architecture in modern data platforms
• Data Validation: Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses EDW Verify source to target data mapping and transformation logic for Medicaid datasets Validate data quality standardization rules and loading accuracy
• SQL and Scripting: Write complex SQL queries including multi table JOINs aggregations to validate ETL outputs against business rules Conduct row counts null checks duplicate checks referential integrity validation.
• Test Strategy and Execution: Design test plans test cases and test scenarios for ETL and data warehouse processes Document test results and provide detailed feedback to stakeholders highlighting areas for improvement Rigorous test case review and approval cycles

Required Skills and Qualifications:

• Technical Skills: Deep proficiency in SQL and relational database systems Oracle SQL Server PostgreSQL
• Analytical Skills: Ability to compare datasets identify root causes of discrepancies and validate against business rules
• Consistent Use: Maintain a minimum of 90% weekly usage of AI tools such as GitHub

Preferred Qualifications:

• Knowledge of MMIS data warehouse migration and data mart validation
• Familiarity with state Medicaid agencies