remoteonsite
Senior Consultant - ETL Testing - Deloitte
Software Engineer
Senior Consultant role focused on designing, developing, and executing ETL test frameworks, validating data pipelines, and ensuring data quality across complex data warehousing environments using SQL, Python and automation tools.
About the role
Key Responsibilities
- Design, develop and maintain automated ETL test suites to validate data extraction, transformation, and loading processes.
- Collaborate with data engineers, architects and business analysts to define test strategies, data quality rules, and acceptance criteria.
- Execute functional, regression, performance and data integrity tests across multiple source systems and data warehouses.
- Identify, document and track defects; work with development teams to drive root‑cause analysis and resolution.
- Implement test automation using Python, SQL scripts and industry‑standard ETL testing tools within Agile delivery cycles.
Requirements
- 5+ years of hands‑on experience in ETL testing, data validation and data warehousing concepts.
- Strong proficiency in SQL and Python for data manipulation and test automation.
- Experience with ETL tools (e.g., Informatica, Talend, DataStage) and test frameworks (e.g., Great Expectations, dbt).
- Solid understanding of Agile methodologies and CI/CD pipelines for data engineering.
- Excellent analytical, problem‑solving and communication skills, with the ability to work in a fast‑paced consulting environment.
Skills
sqlpythontest automationagile