QA Specialist – ETL / Data Engineering / Power BI / Microsoft Fabric

Overview :

We are calling applicants on behalf of 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.

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