FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in ETL processes, data validation, and test automation within healthcare data environments, utilizing tools such as Informatica and Azure Data Factory. Proficient in SQL and data quality validation, with strong analytical and problem-solving skills to ensure data integrity and compliance.
Highest-signal resume keywords
ETL Process DesignData Validation AutomationSQL Query DevelopmentAzure DevOps CI/CD IntegrationHealthcare Data Standards Knowledge
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
ETL TestingSQLPythonInformatica PowerCenterAzure Data FactoryTeradata RDBMSData Quality ValidationTest Strategy DevelopmentData Mapping ValidationShell Scripting
Soft Skills
Analytical SkillsProblem-SolvingCollaborationCommunicationStakeholder Management
Tools & Technologies
Azure DevOpsJIRAHP ALMSQL AlchemyPandasGitHubCI/CD PipelinesAgile/Scrum
Industry Keywords
Healthcare AnalyticsMedicaidData WarehouseEnterprise Data PlatformsHIPAA ComplianceDimensional ModelingStar/Snowflake SchemasSlowly Changing DimensionsData TransformationGovernment Healthcare Programs
Tech Stack
Tools & technologiesAzureCloudETLInformaticaOraclePandasPostgresPythonRDBMSSQLSSIS
About the role
Key responsibilities & impact- Design, automate, and execute test cases for Enterprise Data Warehouse (EDW) ETL processes in a State Government Medicaid environment
- Ensure the accuracy, integrity, and reliability of data throughout ETL processes
- Design and execute test strategies validating functional and non-functional data pipeline requirements
- Use Informatica PowerCenter and Teradata RDBMS for ETL and core data store validation
- Work within Azure DevOps and Agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing
- Review Change Requests and participate in requirements analysis for new EDW extracts and transformations
- Participate in data modeling and requirements gathering sessions
- Perform backend testing comparing source systems with target Medicaid Enterprise Data Warehouses
- Verify source-to-target data mappings and transformation logic for Medicaid datasets
- Validate data quality, standardization rules, and loading accuracy
- Write complex SQL queries with multi-table JOINs and aggregations
- 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 stakeholder feedback
- Execute manual and automated tests for full-load and incremental-load cycles
- Identify, document, and track discrepancies using JIRA, HP ALM, or Azure DevOps Test Plans
- Collaborate with ETL developers to resolve defects and perform regression testing
- Develop automated database validation scripts using Python, SQL Alchemy, and Pandas
- Create shell scripts for ETL monitoring and log analysis
- Integrate automation into Azure DevOps CI/CD pipelines
Requirements
What you’ll need- 5+ years of QA/testing experience supporting ETL, data warehouse, backend data systems, healthcare analytics, or enterprise data platforms
- 5+ years of hands-on experience with Python, Azure, and Azure Data Factory (ADF) for data validation, test automation, pipeline testing, and cloud-based data solutions
- Strong expertise in SQL and relational databases such as Teradata, SQL Server, Oracle, PostgreSQL, or equivalent
- Experience testing ETL, data warehouse, backend, integration, end-to-end, and UI solutions
- Strong understanding of data warehousing and ETL concepts, including dimensional modeling, Star/Snowflake schemas, Slowly Changing Dimensions (SCD Type 1/2), data transformations, and data quality validation
- Experience validating data mappings, business rules, source-to-target reconciliation, data transformations, and overall data integrity
- Experience with ETL tools such as ADF, Informatica, Talend, or SSIS
- Experience with test management tools such as Azure DevOps, Jira, or HP ALM
- Experience developing and executing test strategies, test plans, test cases, automation frameworks, and defect management processes
- Strong analytical, troubleshooting, problem-solving, and root-cause analysis skills
- Experience working in Agile/Scrum environments, with strong communication, collaboration, and stakeholder management skills
- Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, Mathematics, Statistics, or a related field
- Preferred: experience in healthcare, Medicaid, managed care, payer, or government healthcare programs
- Preferred: knowledge of HIPAA and healthcare data standards and transactions, including 837/835, ICD-9/10, CPT, and HL7
- Preferred: experience supporting Medicaid Enterprise Systems, State Medicaid programs, or state health and human services agencies
- Preferred: experience testing large-scale healthcare data warehouses, reporting platforms, cloud modernization initiatives, or enterprise data transformation programs
- Preferred: experience with Informatica or other enterprise ETL platforms
- Preferred: experience building or maintaining test automation, ETL validation, or data quality automation frameworks
- Preferred: experience with CI/CD pipelines, DevOps practices, GitHub/Git, release management, and automated deployment processes
- Preferred: experience supporting Azure cloud migration, data platform modernization, and enterprise-scale transformation initiatives
- Preferred: experience collaborating with business, operational, technology, and regulatory stakeholders in highly governed healthcare environments
Benefits
Comp & perks- Fully remote work arrangement
- Opportunity to work on meaningful state Medicaid and healthcare data projects
- Professional growth across Informatica PowerCenter, Teradata, Azure DevOps, and Python automation
- Collaborative Agile work environment
- Purpose-driven consulting work supporting government and healthcare clients