Senior Test Specialist - Cloud ETL, DW Automation

Job Summary

The Senior Test Specialist in Cloud Automation Testing focuses on automating testing processes in ETL (Extract, Transform, Load) and Data Warehousing environments to ensure the quality and reliability of data pipelines. The role involves designing, developing, and implementing automation scripts for testing data transformations, data loading processes, and data quality verification.

Key Responsibilities

1. Develop and execute automated test scripts for etl processes and data pipelines.
2. Collaborate with cross functional teams to design and implement automated testing frameworks.
3. Create test plans and test cases for etl and data warehouse testing.
4. Identify and troubleshoot issues in data transformations and data loading processes.
5. Conduct performance testing and ensure scalability of data pipelines.
6. Implement best practices for data quality assurance in etl environments.

Skill Requirements

1. Proficiency in cloud based automation testing tools like selenium, appium, or similar.
2. Experience in automation testing of etl (extract, transform, load) processes and data warehousing.
3. Strong understanding of sql for data querying and validation.
4. Knowledge of big data technologies such as hadoop, spark, or kafka is a plus.
5. Familiarity with scripting languages like python, java, or shell scripting.
6. Excellent analytical and problem-solving skills with a keen attention to detail.
7. Ability to work collaboratively in a team environment and good communication skills.

Other Requirements

1.Relevant certifications in Automation Testing, ETL Testing, or Cloud technologies are a plus.

Client JD : Role SummaryETL Test Engineer responsible for validating data pipelines, ensuring data accuracy, completeness, and integrity across source and target systems in Data Warehouse/Cloud environments.Key ResponsibilitiesDesign and execute ETL/Data Warehouse test strategies for batch and real-time pipelinesPerform source-to-target validation, data reconciliation, and transformation testingWrite complex SQL queries for data validation and defect analysisValidate data ingestion, transformation logic, and reporting outputsDevelop and maintain automation scripts (Python/ETL testing tools)Work with GCP/AWS data platforms (BigQuery, Cloud Storage, etc.) for validationParticipate in Sprint ceremonies (Agile), defect triage, and release validationEnsure data quality, governance, and compliance standards are metPrepare test plans, test cases, execution reports, and defect reports****Required SkillsStrong experience in ETL/DWH TestingHands-on expertise in **SQL (advanced queries, joins, validation)**Experience in data validation and reconciliation techniquesKnowledge of ETL tools (Informatica / SSIS / DataStage / Ab Initio)Experience with Test Management & Defect Tools (JIRA, QTest, ALM)Understanding of Agile/Scrum processes****Preferred SkillsExperience in GCP (BigQuery, Dataflow, Cloud Storage, Spanner) Automation using Python / QuerySurge / Selenium-based frameworksExposure to API testing (Postman) and data pipelinesExperience in Banking/Financial domain (preferred for LBG use case) Knowledge of data migration / CDC validation / BI reporting validation