Data Quality Engineer

Role Summary

As a Data QE at PalTech you will play an important role in designing and executing test strategies for end-to-end data validation, ensuring data completeness, accuracy, and integrity across ETL processes, data warehouses, and reports..

The role requires strong analytical skills, collaboration with cross-functional teams, and the ability to enhance testing processes through automation and best practices.

Key Responsibilities

• Create test strategies, test plans, business scenarios, data validation scripts for end-to-end data validation.
• Verify data completeness, accuracy, and integrity throughout the ETL processes and reports.
• Evaluate the performance of ETL jobs and ensure that they meet defined SLAs.
• Experienced in validating various types of fact tables and dimension tables
• DWH skills are a must
• Should have expertise in validating larger datasets
• Should have experience working with relational databases
• Should have experience in validation of file ingestions and data exports
• Should be expert in validation of the data security standards implemented in the project.
• Should be proficient in SQL and validation of ETL/ELT tools
• Should be proficient in writing complex scripts to validate business logics and KPIs
• Should be proficient in validating data encryption, anonymization, authorization processes
• Extensive experience in creating test data as and when needed based on the business requirements
• Should be able to identify and validate the corner business use cases
• Work closely with cross-functional teams including developers, business analysts, and data architects.
• Suggest enhancements and implement the best practices to improve testing processes.

Required Skills and Qualifications

• Educational Background:

  Bachelors degree in computer science, Information Technology, or a related field.

• Technical Skills:

  Strong understanding of ETL processes, data warehousing concepts, and SQL. Should have strong Python skills

• Experience:

  4 to 6 years of experience in ETL testing/Database. Experience in automation of data validation processes

• Tools:

  Familiarity with ETL tools and defect tracking systems like JIRA.

• Soft Skills:

  Excellent communication, teamwork abilities, and strong analytical and problem-solving skills.

Why Join PalTech?

Great Place to Work Certified