Job Description
Overview
End to end testing using SQL(SQL server) to validate data accuracy, transformations and business rules across pipelines or ADF (Azure Data Factory). Advance SQL (complex joins, CTE's, aggregations, windows functions ) for data validation and analysis.
Your role
- Design and execute test plans for data pipelines, transformations, and integrations within Azure.
- Validate data accuracy, completeness, and consistency across source and target systems.
- Test data flows in Azure Data Factory, Synapse Analytics, and Azure SQL.
- Monitor and validate performance, scalability, and reliability of cloud-based data solutions.
- Develop automated test scripts using Python, SQL, and Azure DevOps.
- Integrate QA processes into CI/CD pipelines for continuous validation.
- Identify and document data issues, working closely with data engineers and developers to resolve them.
- Maintain a defect log and contribute to root cause analysis.
- Partner with data analysts, data architects, and stakeholders to understand requirements and ensure test coverage.
- Document test cases, results, and QA metrics for reporting and compliance.
About you
- 2-4 years of experience in data QA or testing roles in a data and analytics space
- Strong SQL skills and experience with data validation technique.
- Hands-on experience with Azure services: Data Factory, Synapse, Azure SQL, Blob Storage.
- Familiarity with data modeling, ETL processes, and data governance principles.
- Experience with test automation tools and scripting (e.g., Python, PyTest, dbt tests).
- Experience in enterprise reporting environments (e.g., Power BI).
- Knowledge of Agile methodologies and DevOps practices.
- Exposure to finance or operational data domains.
Reward & benefits
Explore the rewards and benefits that help you thrive - at every stage of your life and your career.
This includes:
. Comprehensive life insurance coverage.
. Premium medical insurance for you and your dependents.
. Generous annual leave balance.
. Flexible and hybrid work solutions.
. Remote work opportunities outside of country.
. Company gratuity scheme.
. Discretionary bonus program.
. Relocation assistance.
. Employee Wellbeing Program: 24/7 access to specialists in finance, legal matters, family care, personal health, fitness, and nutrition.
Seize every opportunity to sharpen your skills, expand your expertise, and be recognized for the impact you make.
About AtkinsRealis
We're , a world-class engineering services and nuclear organization. We connect people, data and technology to transform the world's infrastructure and energy systems. Together, with our industry partners and clients, and our global team of consultants, designers, engineers and project managers, we can change the world. We're committed to leading our clients across our various end markets to engineer a better future for our planet and its people.
Worker Type
Employee
Job Type
Regular