Job requisition ID 80842 Date Jul 25 2025 Location Bengaluru Designation Analyst Entity Deloitte India LLP Your potential unleashed India s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realize your potential amongst cutting edge leaders and organizations shaping the future of the region and indeed the world beyond At Deloitte your whole self to work every day Combine that with our drive to propel with purpose and you have the perfect playground to collaborate innovate grow and make an impact that matters The Team Deloitte s 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 a Analyst Consultant Senior Consultant in our T T Team you ll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations - ETL Testing Perform functional regression integration and system testing on ETL processes to ensure data extraction transformation and loading operations are executed accurately Test Case Design Design create and execute test cases based on ETL requirements data models and business logic Data Validation Validate data integrity by comparing source data to target data ensuring data is accurately transformed and loaded Automation Develop and maintain automated ETL test scripts using tools like Selenium Python or custom frameworks Data Mapping Review data mapping documents and ensure that all data transformations are properly implemented Issue Reporting Identify and report any data discrepancies performance issues or ETL process failures and collaborate with the development team to resolve them Test Environment Setup Set up test environments ensuring that the correct data sets are available for testing ETL processes Performance Testing Perform performance testing of ETL processes to identify bottlenecks and optimize the efficiency of the data load and transformation processes Collaboration Collaborate with developers business analysts and other stakeholders to understand data requirements business rules and ensure proper test coverage Documentation Document test results defects and provide feedback to the development team to ensure continuous improvement Compliance Ensure that all ETL testing is in compliance with data governance and security standards Requirements 2 years of experience in ETL testing or data validation Robust understanding of ETL processes including data extraction transformation and loading Experience working with SQL and relational databases e g MySQL SQL Server Oracle Hands-on experience with ETL testing tools like Apache Nifi Talend or Informatica is a plus Proficient in writing SQL queries for data validation and troubleshooting Knowledge of data warehousing concepts such as star snowflake schemas and data modeling Ability to write and maintain test cases and test plans Familiarity with defect tracking and test management tools like JIRA TestRail or Quality Center Strong analytical and problem-solving skills with the ability to troubleshoot and resolve issues Excellent communication skills and the ability to collaborate effectively with cross-functional teams Familiarity with version control systems e g Git is a plus Location and way of working Base location Bangalore Hybrid is our default way of working Each domain has customized the hybrid approach to their unique needs How you ll grow Connect for impact Our exceptional team of professionals across the globe are solving some of the world s most complex business problems as well as directly supporting our communities the planet and each other Know more in our Global Impact Report and our India Impact Report Empower to lead You can be a leader irrespective of your career level Our colleagues are characterised by their ability to inspire support and provide opportunities for people to deliver their best and grow both as professionals and human beings Know more about Deloitte and our One Young World partnership Inclusion for all At Deloitte people are valued and respected for who they are and are trusted to add value to their clients teams and communities in a way that reflects their own unique capabilities Know more about everyday steps that you can take to be more inclusive At Deloitte we believe in the unique skills attitude and potential each and every one of us brings to the table to make an impact that matters Drive your career At Deloitte you are encouraged to take ownership of your career We recognise there is no one size fits all career path and global cross-business mobility and up re-skilling are all within the range of possibilities to shape a unique and fulfilling career Know more about Life at Deloitte Everyone s welcome entrust your happiness to us Our workspaces and initiatives are geared towards your 360-degree happiness This includes specific needs you may have in terms of accessibility flexibility safety and security and caregiving Here s a glimpse of things that are in store for you Interview tips We want job seekers exploring opportunities at Deloitte to feel prepared confident and comfortable To help you with your interview we suggest that you do your research know some background about the organisation and the business area you re applying to Check out recruiting tips from Deloitte professionals