QA Engineer – AWS Data Warehouse

3 days 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



  • Lahore, Punjab, Pakistan Tech Bridge Consultancy Full time 1,200,000 - 2,400,000 per year

    Job description: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...

  • 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...

  • AWS Data Engineer

    2 weeks 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

    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...


  • Lahore, Punjab, Pakistan Techbridge Consultancy Services Full time 120,000 - 180,000 per year

    About the Role:We are looking for a QA Engineer – Database & SQL Testing with strong expertise in AWS Data Warehousing to ensure the quality, accuracy, and reliability of data across our cloud platform. This role involves validating complex SQL logic, database structures, and data flows, and ensuring that ETL processes and data pipelines built on AWS...


  • Lahore, Punjab, Pakistan Techbridge Consultancy Services Full time 900,000 - 1,200,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...


  • 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,...


  • Lahore, Punjab, Pakistan 3DLogistiX Full time 900,000 - 1,200,000 per year

    Company Description3DLogistiX empowers businesses with seamless 3D visualization warehouse management, streamlined accounting, and ERP integration. We revolutionize the future of logistics by offering solutions that ensure unparalleled efficiency and growth. Our innovative technology enhances operational performance and drives success for our clients.Role...

  • Data Engineer

    3 days 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...


  • Lahore, Punjab, Pakistan ACE Union Full time 3,600,000 - 4,800,000 per year

    About Us:We are a dynamic and fast-growing financial technology group headquartered in Manchester, United Kingdom, with an established presence across the UK, Europe, Canada, Australia, Pakistan, and Bangladesh. Our group, encompassing ACE Money Transfer and ACE Union, operates across two regulated verticals: Electronic Money Services (EMI) and Cross-Border...