- 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 solid 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