QA Engineer – AWS Data Warehouse

1 day ago

Lahore, Punjab, Pakistan Techbridge Consultancy Services Full time 900,000 - 1,200,000 per year

About the Role:

We are looking for a QA Engineer with strong AWS Data Warehouse (DWH) expertise to ensure data quality, accuracy, and reliability across our cloud data platform. You will work closely with Data Engineers, BI Developers, and Business Analysts to design and execute test strategies for ETL pipelines, data transformations, and reporting systems built on AWS services such as Redshift, Glue, Athena, S3, and DMS.

Key Responsibilities:

Design, develop, and execute test plans, test cases, and test scripts for data warehouse and ETL processes.

Validate data extraction, transformation, and loading (ETL) processes between source systems and target AWS DWH (Redshift, S3, Athena).

Perform data quality, reconciliation, and validation testing (counts, duplicates, schema, nulls, transformations).

Test CDC (Change Data Capture) pipelines built with AWS DMS and Glue.

Write complex SQL queries in Redshift/Athena to validate data integrity and business rules.

Test partitioning, performance, and query optimization in Redshift and Athena.

Collaborate with developers and DevOps teams to integrate QA into CI/CD pipelines.

Create and maintain test automation frameworks for data validation (e.g., using Python, Pytest, Great Expectations, dbt tests, etc.).

Document defects clearly, work with the engineering team to resolve issues, and re-test fixes.

Ensure compliance with data governance, lineage, and security policies.

Required Skills & Experience:

3–6 years of experience in Data Warehouse / ETL QA.

Hands-on experience with AWS DWH services: Redshift, Glue, Athena, S3, DMS, Glue Catalog.

Strong SQL skills for data validation (window functions, aggregations, joins).

Experience testing ETL pipelines (batch and incremental loads).

Familiarity with data lake concepts, partitioning, and schema evolution.

Experience with Python or Shell scripting for automation.

Knowledge of QA best practices in data engineering projects (functional, regression, performance testing).

Experience with Git / CI-CD pipelines (Jenkins, CodePipeline, GitHub Actions, etc.).

Excellent problem-solving and communication skills.

Good to Have (Plus Skills)

Experience with Snowflake, BigQuery, or Azure Synapse (multi-cloud exposure).

Knowledge of BI tools (Tableau, Power BI, QuickSight) for report validation.

Experience with data testing frameworks like Great Expectations, dbt, or Pytest.

Familiarity with Redshift performance tuning (distribution keys, sort keys, compression).

Exposure to agile methodology and tools like JIRA, Confluence.

Education

Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or related field.

Job Type: Full-time

Ability to commute/relocate:

  • Lahore: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

  • As an SQA, how do you design test cases to validate data quality and transformations in an AWS Data Warehouse environment (e.g., Redshift, Glue, Athena)?
  • When you identify a defect in an ETL pipeline or reporting system, how do you document it and communicate it to developers for resolution?
  • Have you automated any data validation or testing processes (using Python, Pytest, or Great Expectations)? Can you share an example?
  • Do you have strong English communication skills?

Location:

  • Lahore (Required)

Work Location: In person

  • AWS Data Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan Cloudelligent Full time $104,000 - $130,878 per year

    Position Title: AWS Data Engineer Job Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location: LahoreAbout Cloudelligent Cloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to make...

  • AWS Data Engineer

    1 week ago

    Lahore, Punjab, Pakistan Cloudelligent Full time $104,000 - $130,878 per year

    Position Title: AWS Data EngineerJob Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location: Lahore About Cloudelligent Cloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to make...

  • AWS Data Engineer

    7 days ago

    Lahore, Punjab, Pakistan Cloudelligent Full time

    OverviewPosition Title: AWS Data EngineerJob Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location: LahoreAbout CloudelligentCloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to...

  • Data Engineer

    5 days ago

    Lahore, Punjab, Pakistan Data Prism Full time 104,000 - 130,878 per year

    About the Company:Data Prism is on a mission to democratize data, helping startups and enterprises alike in an effort to make data-driven decisions. We provide data acquisition (and analysis) and data engineering services, adding huge value for our clients around the globe. Our robust and reliable solutions have helped clients improve both their top line as...

  • SQA Engineer – Automation, API, and Data Warehouse Testing

    2 weeks ago

    Lahore, Punjab, Pakistan Techbridge Consultancy Services Full time $90,000 - $120,000 per year

    Job Summary:We are seeking a skilled and detail-oriented Software Quality Assurance (SQA) Engineer with 2 to 3 years of experience in automation testing, API testing, and Data Warehouse validation. The ideal candidate should have strong problem-solving skills, hands-on experience working with APIs and data pipelines.Key Responsibilities:Design, develop, and...

  • QA Engineer

    1 week ago

    Lahore, Punjab, Pakistan Data Wise Full time

    Job Description:We are seeking a highly skilled test and quality assurance engineer to join our dynamic team. The ideal candidate will possess extensive experience in software testing and development. The QA testing engineer will play a crucial role in enhancing our software quality and performance by applying advanced testing strategies and will collaborate...

  • Data Warehouse Developer

    2 weeks ago

    Lahore, Punjab, Pakistan Cadnz, LLC Full time $60,000 - $100,000 per year

    Location:Lahore, PakistanExperience Level:3–5 YearsJob Type:Full-Time / On-siteResponsibilitiesDesign, develop, and maintain scalable data warehouse solutions using MySQL.Build and optimize ETL pipelines to support data integration from multiple sources.Collaborate with front-end and back-end teams using Laravel, , and Ensure data accuracy, consistency,...

  • SQA Engineer – Automation, API, and Data Warehouse Testing

    2 weeks ago

    Lahore, Punjab, Pakistan Tech Bridge Consultancy Full time

    Job SummaryWe are seeking a skilled and detail-oriented Software Quality Assurance (SQA) Engineer with 2 to 3 years of experience in automation testing, API testing, and Data Warehouse validation. The ideal candidate should have strong problem-solving skills, hands-on experience working with APIs and data pipelines.Key ResponsibilitiesDesign, develop, and...

  • Data & Software QA

    3 weeks ago

    Lahore, Punjab, Pakistan ClearGrid Full time

    The Data & Software Quality Assurance (QA) Specialist will play a key role in ensuring the integrity, reliability, and performance of our software solutions and underlying data. As a vital member of our product and technology teams, you will be responsible for developing and executing comprehensive test plans, identifying potential issues, and collaborating...

  • Data Engineer

    1 day ago

    Lahore, Punjab, Pakistan Kwanso Full time 900,000 - 1,200,000 per year

    As a Data Engineer, you will play a key role in designing and implementing a lightweight data aggregation and reporting solution for our client. Your responsibilities will include building and optimizing ETL pipelines, integrating data from various sources, and ensuring efficient data storage and retrieval. You will work closely with stakeholders to...