Etl Test Analyst

Pi Square Technologies; Hyderabad, Mysuru; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Pi Square Technologies in Hyderabad is seeking a Senior ETL/Data Testing professional to join our data validation practice. You will design and implement end-to-end testing across ingestion, processing, and serving layers.

You will collaborate with data engineering and platform teams, leveraging SQL, cloud platforms and Python automation to ensure data quality and governance in complex data programs.

Qualifications

• 5+ years of experience in ETL/Data Warehouse/Data Testing.
• Strong expertise in Advanced SQL.
• Hands-on experience in Data Warehouse, Data Lake, Data Lakehouse testing.
• Experience working on at least one modern cloud data platform: Snowflake, BigQuery, AWS Redshift, Azure Synapse, Databricks.
• Strong understanding of data validation and reconciliation, data transformation testing, data quality testing, source-to-target testing, and data profiling and integrity validation.
• Basic Python scripting capability for data testing and automation.

Responsibilities

• Work independently with strong stakeholder management and communication skills.
• Develop and execute comprehensive test strategies, test plans, and test cases for large-scale data programs.
• Validate end-to-end data pipelines from ingestion to consumption across raw, curated, and serving layers.
• Ensure data integrity, data quality, reconciliation, and business rule validation across the data ecosystem.
• Validate data transformations, aggregations, and data movement across source and target systems.
• Perform source-to-target data validation, data profiling, and data quality assessments.
• Collaborate with business, data engineering, and platform teams in an Agile delivery environment.

Skills

ETL/Data Warehouse Testing

Advanced SQL

Data Warehouse Testing

Data Lake Testing

Data Lakehouse Testing

Python scripting

GCP exposure

dbt

Cloud data migration

Tools

Snowflake

BigQuery

AWS Redshift

Azure Synapse

Databricks

Job description

Responsibilities:

• Work independently with strong stakeholder management and communication skills.
• Develop and execute comprehensive test strategies, test plans, and test cases for large-scale data programs.
• Validate end-to-end data pipelines from ingestion to consumption across raw, curated, and serving layers.
• Ensure data integrity, data quality, reconciliation, and business rule validation across the data ecosystem.
• Validate data transformations, aggregations, and data movement across source and target systems.
• Perform source-to-target data validation, data profiling, and data quality assessments.
• Collaborate with business, data engineering, and platform teams in an Agile delivery environment.

Mandatory Skills

• 5+ years of experience in ETL/Data Warehouse/Data Testing.
• Strong expertise in Advanced SQL (mandatory).
• Hands-on experience in Data Warehouse, Data Lake, Data Lakehouse testing.
• Experience working on at least one modern cloud data platform:
  • Snowflake
  • Google BigQuery
  • AWS Redshift
  • Azure Synapse
  • Databricks
• Strong understanding of:
  • Data validation and reconciliation
  • Data transformation testing
  • Data quality testing
  • Source-to-target testing
  • Data profiling and data integrity validation
• Basic Python scripting capability for data testing and automation.

Preferred Skills

• Exposure to GCP ecosystem (BigQuery, GCS, etc.).
• Exposure to dbt (Data Build Tool).
• Experience in cloud-based data migration or modernization programs.

Banking/Financial Services domain experience.