About the role
About Us:
Atlas Systems Inc. is a Software Solutions company headquartered in East Brunswick, NJ. Incorporated in 2003, Atlas provides a comprehensive range of solutions in the areas of GRC, Technology, Procurement, Healthcare Provider, and Oracle to customers across the globe. Combining our unparalleled experience of over a decade in the software industry and global reach, we have grown with extensive capabilities across industry verticals.
For more information, please visit our website https://www.atlassystems.com/
Please click on the link below to apply for this position:
https://atlas.bamboohr.com/careers/626
QA Specialist – ETL / Data Engineering / Power BI / Microsoft Fabric
Overview
Seeking a QA Specialist with strong hands-on experience in ETL/ELT testing, SQL, data validation, and data quality, with working knowledge of Microsoft Fabric, Databricks, and Power BI.
The role involves validating data across source systems → ETL pipelines → data platforms → semantic models → Power BI, with a strong focus on reconciliation, transformation validation, migration testing, and RCA.
Key Responsibilities
• Test ETL/ELT pipelines, transformations, mappings, workflows, and data migrations.
• Perform source-to-target reconciliation, completeness, accuracy, duplicate, null, aggregation, and business-rule validations.
• Validate initial, incremental, historical, and delta loads, including insert/update/delete scenarios.
• Validate data across SQL Server, Azure SQL, Snowflake, Fabric Lakehouse/Warehouse, and Databricks.
• Test pipelines and transformations using ADF, SSIS, Informatica, Talend, Alteryx, Fabric Pipelines/Notebooks, and Databricks where applicable.
• Use SQL, Python, PySpark/Spark SQL for data validation and automation.
• Perform RCA across source → ETL → data platform → semantic model → Power BI.
• Validate Power BI reports, semantic models, relationships, DAX, filters, RLS, refresh, and backend reconciliation.
• Build reusable data validation/reconciliation automation frameworks and integrate checks into CI/CD or pipeline execution.
• Document test cases, defects, evidence, QA metrics, and release validation.
Required Skills
• Strong ETL/Data Warehouse QA experience.
• Strong SQL and data reconciliation skills.
• Hands-on experience with one or more ADF, SSIS, Informatica, Talend, Alteryx, or similar ETL tools.
• Strong understanding of data quality, ETL testing, data lineage, and migration testing.
• Working knowledge of Microsoft Fabric and/or Databricks.
• Good understanding of Power BI, semantic models, and DAX validation.
• Experience with Python/PySpark/Spark SQL for data validation is preferred.
• Strong RCA, defect management, and QA documentation
skills.
Preferred
• Fabric / Databricks migration testing
• Fabric Lakehouse/Warehouse, Pipelines, Notebooks
• Databricks, Delta Lake, PySpark
• ADF / SSIS / Informatica / Talend / Alteryx
• Power BI Service, DAX, XMLA/SemPy
• Playwright / UI automation
• Metadata-driven or reusable QA frameworks
• CI/CD and automated data-quality checks