Technology & Transformation-EAID-Engineering- Senior Consultant - ETL Testing -

Technology & Transformation-EAID-Engineering- Senior Consultant - ETL Testing - Job requisition ID : 106372 Location : Bengaluru Entity : Deloitte Touche Tohmatsu India LLP The team Deloittes Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning. Your work profile As aSenior Consultant in our Technology & Transformation Team youll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations: - Design, develop and deploy solutions using different tools, design principles and conventions. Configure robotics processes and objects using core workflow principles in an efficient way; ensure they are easily maintainable and easy to understand. Understand existing processes and facilitate change requirements as part of a structured change control process. Solve day to day issues arising while running robotics processes and provide timely resolutions. Maintain proper documentation for the solutions, test procedures and scenarios during UAT and Production phase. Coordinate with process owners and business to understand the as-is process and design the automation process flow. Key skills required: Experience in database testing, with expertise in validating data integrity, consistency, and accuracy across multiple environments and systems Proven expertise in writing and optimizing complex SQL queries for data validation, transformation, and migration in both relational and non-relational databases Proficient in automating data manipulation tasks with custom Python or Java scripts for efficient handling and preparation of large datasets Experience with AWS is a must Pharmaceutical industry expertise is required Advanced knowledge of data preprocessing techniques(data cleansing, transformation, and aggregation) Extensive experience in developing and executing automated test scripts using Python or Java to support efficient and scalable test automation Strong experience in designing and maintaining test automation frameworks focused on database testing and ETL process validation Education Bachelors degree in computer science, Information Technology, or related field.