Etl Test Analyst at Pi Square… · Hybrid -…

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.