Chisquare Labs - ETL Tester - Data Migration & Quality Assurance

Job Description

Description

Job Title : ETL Tester- Data Migration & Quality Assurance

Location : Infopark Phase 2, Cochin

Job Type : Full Time

Experience Required : 3,5 years

Department : QA Assurance

Who Are We

CHISQUARE LABS is a fast,growing AI, Data Science, Data Engineering, Clinical Decision support, Information & Cyber Security compliance focused organization with a presence in Kochi, UK and US. We aspire to be a prominent player in the Decision Making in the coming years. A team of 150 highly motivated employees are our strength.

What we offer?

A high growth environment where you can take new challenges, build a career, make an impact. Cross cultural, multi national exposure, access to experienced leaders and mentors. Competitive compensation and benefits.

What are we looking for?

We are looking for a Data Engineer with a strong focus on data migration testing and data quality to help validate the movement of data from several PostgreSQL and other databases into our centralized data warehouse. This role ensures that the right data is delivered accurately, consistently, and ready to support mission,critical analytics and operational workflows.

What Youll Do

Data Migration & Validation :

• Testing and validation of data migration from multiple Postgres and other databases into the centralized data warehouse
• Develop comprehensive test plans for comparing source and target datasets, verifying completeness, correctness, transformations, and referential integrity.
• Conduct reconciliation using advanced SQL, profiling tools, and automated comparison scripts.
• Investigate, document, and escalate discrepancies; work with engineering, QA and Data teams to drive resolution.
  
  

• Collaborate closely with data engineers to test and validate models, ingestion pipelines, and transformation logic.
  
  

• Support performance tuning and optimization of SQL transformations.
  
  

• Define and implement reusable data quality checks (e.g., null checks, uniqueness constraints, business rule validation).
• Build automated testing frameworks using tools such as Cursor, custom Python utilities.
• Maintain clear documentation including data mappings, lineage, and testing artifacts to support auditable and compliant systems.
  
  

• Partner with Product, Clinical Operations, and Analytics teams to understand data requirements and downstream use cases.
• Communicate testing progress, risks, and findings in a clear and structured way to both technical and non,technical stakeholders.
• Ensure migrated datasets fully support patient onboarding, provider workflows, and trial,matching intelligence.
  
  

• 3 - 5+ years of experience in data engineering, data quality engineering, or data migration roles.
• Advanced SQL proficiency, especially in PostgreSQL, including performance tuning and analytic functions.
• Hands,on experience validating or testing large,scale data migrations or multi,source integrations.
• Experience with ETL/ELT tooling and Pyspark
• Familiarity with modern cloud data warehouses
• Strong understanding of data modeling: star schema, normalization, SCD patterns, and best practices.
• Proficiency in Python for scripting validation or automated testing.
• Strong analytical mindset with meticulous attention to data accuracy and completeness.
  
  

• Experience with automated data testing frameworks
• Background in healthcare data, PHI handling, or regulated environments.
• Experience with master data management or consolidating disparate operational systems.
• Knowledge of CI/CD workflows and version control via GitHub