Join our Technology & Transformation team as a Senior Consultant, specializing in ETL Testing. This role offers the opportunity to work with vast amounts of data, providing strategic guidance and implementation services to help companies manage data effectively. You'll be instrumental in transforming disparate data sources into accurate, actionable information to drive fact-driven decision-making and gain a competitive advantage.

Our practice focuses on business intelligence, data management, performance management, and next-generation analytics, including big data, cloud, and machine learning technologies. As part of a global network, you'll contribute to cutting-edge solutions.

As a Senior Consultant, you will cultivate strong client relationships and exceed expectations. Your responsibilities include designing, developing, and deploying solutions using various tools and principles. You'll configure robotic processes efficiently, ensuring maintainability and clarity.

Furthermore, you will analyze existing processes, adapt to changing requirements, and resolve day-to-day issues arising from robotics processes. Maintaining thorough documentation for solutions and test procedures, including UAT and production phases, is crucial. You'll also collaborate with process owners to understand current processes and design automation workflows.

This role requires 6-9 years of experience in designing and implementing automated test frameworks for ETL/ELT pipelines. You will be responsible for validating source-to-target data reconciliation, transformation logic, and business rules. Key tasks include developing automated scripts for data completeness, accuracy, timeliness, and integrity checks.

Perform comprehensive database, file, and API testing across structured and semi-structured data. Create reusable automation components for essential checks and execute regression, integration, and system testing for data pipelines. You will analyze test failures, identify root causes, and collaborate with data engineers for timely resolutions, while also validating incremental loads and historical data migrations. Proficiency in DBT and automated testing frameworks, along with the ability to prepare test plans, test cases, defect reports, and execution summaries, is essential.