Responsibilities
Design and implement comprehensive ETL testing strategies covering data validation, reconciliation, and data warehouse testing.
Develop complex SQL queries for large-scale data validation and performance tuning.
Analyze ETL workflows, data models, and transformation logic to identify risks and inconsistencies.
Lead ETL testing efforts across multiple systems ensuring data integrity and quality.
Own ETL validation across source-to-target workflows, including reconciliation, root cause analysis, and resolution support.
Review test cases, SQL scripts, and validation processes ensuring adherence to standards.
Mentor team members in ETL testing, data validation, and SQL optimization techniques.
Collaborate with stakeholders to align data validation with reporting and analytics requirements.
Behavioral Competencies
Demonstrates ownership of ETL validation activities to ensure data quality and testing excellence.
Collaborate effectively with teams and stakeholders for successful delivery.
Apply robust analytical and problem-solving skills to complex testing challenges.
Communicates proactively to ensure stakeholder alignment and transparency.
Mentors team members and promote knowledge sharing across testing practices.
Ensures end-to-end quality delivery through effective test ownership.
Drives innovation in testing strategies, processes, and automation adoption.
Adapts effectively to changing requirements and testing priorities.
Maintains attention to detail in testing, validation, and defect management.
Takes initiative in improving test coverage, processes, and quality practices.
Mandatory Competencies
Big Data - Big Data - Pyspark
Data Science and Machine Learning - Data Science and Machine Learning - Databricks
QA/QE - QA Manual - API Testing
ETL - ETL - Informatica Power Centre
QA - Risk Management
QA/QE - QA Manual - Test Case Creation, Execution, Planning, Reporting with risks/dependencies
Data AI - BI Reporting and Data Visualization - ETL Concepts
QA/QE - QA Automation - Basic Build, Deployment and CI/CD
QA/QE - QA Automation - ETL Testing
Beh - Communication and collaboration