Quality Assurance Analyst – SME Level

Job DescriptionThis position will require a qualified Quality Assurance Analyst to take the lead on the following tasks:Review and validate the output of SQL and ETL development to ensure data accuracy, consistency, and alignment with business rules.Develop and execute detailed data test plans, test cases, and validation scripts targeting Azure Synapse pipelines, stored procedures, and data transformations.Reconcile data between source systems, staging areas, and curated data layers in Azure Data Lake or Synapse.Conduct regression testing on modified pipelines, stored procedures, or data models to confirm that changes do not introduce new issues.Collaborate with data engineers, ETL developers, and business analysts to document and resolve data discrepancies.Maintain data QA documentation including test results, issue logs, and validation procedures.Support the development of automated data quality checks or unit tests using SQL, Python, or other approved tools.Contribute to continuous improvement of QA processes, data validation frameworks, and DevOps testing integration.Required Skills and ExperienceMust be able to effectively communicate (verbally and written) test cases with stakeholders as well as the development team. — No min.Must be able to collaborate with the Project Manager, Architect, Business Analyst, and developers to ensure test cases are communicated, accepted, and meet expectations. — 7 yearsMust be able to write test plans, test cases, and test scripts from scratch, validating that user expectations are achieved during the testing process. — 7 yearsMust be able to work closely with the Business Analysts to formulate test plans, prepare test cases, execute the tests, and fully document and report the results. — 7 yearsMust be able to perform user acceptance testing, functionality testing, regression testing, performance testing, and end-to-end system testing on various applications. Documentation includes: Formal Test Plan, Test Case Document, Technical Use Cases and Test Plan, User stories, etc. — 7 yearsMust be able to review user requirements to ensure that requirements are testable. — 7 yearsMust be able to create diagrams, flowcharts, and workflows of data flow through systems. — 7 yearsMust be able to create and manage test cases for Quality Assurance. — 7 yearsMust be familiar with software and database development concepts. — 7 yearsMust have experience as a Quality Assurance Analyst working on a software development team. — 7 yearsMust have strong experience in QA management and creating all documents listed above. — 7 yearsMust have strong experience in mapping business processes into test case documentation. — 7 yearsMust understand software quality best practices, test strategy and planning, test case development, test case deployment and execution, test data, defect tracking, and test manuals. Must actively participate in process improvements. — 7 yearsStrong experience in acceptance testing — 7 yearsAbility to analyze business functions — 7 yearsScrum — 7 yearsAgile — 7 yearsPreference given to candidates with the below skills/experience. Must also meet minimum requirementsDatabase Entity DesignSamples of previous documents created strongly preferred.PL/SQLData Factory/SynapseSQL ServerDevOpsOracleStored ProceduresVisioSoftware Development Life CycleScrum / AgileC# Apply tot his job