QA Engineer – AWS Data Warehouse

10 hours ago

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

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

  • 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

    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

    1 week 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

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

  • Software QA Engineer

    10 hours ago

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