Technology & Transformation - Engineering - Senior Consultant - ETL Testing

\ Senior Consultant | ETL Testing | Bengaluru | Engineering Job requisition ID: 99693 Location: Bengaluru Entity: Deloitte Touche Tohmatsu India LLP What impact will you make? Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration and high performance. As the undisputed leader in professional services, Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential. 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. Learn more about Analytics and Information Management Practice Work youll do As a Senior Consultant in our Consulting team, youll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations. Youll: Your role as a leader At Deloitte India, we believe in the importance of leadership at all levels. We expect our people to embrace and live our purpose by challenging themselves to identify issues that are most important for our clients, our people, and for society and make an impact that matters. Key Responsibilities Design and develop Python-based automation frameworks and reusable utilities for ETL validation and data reconciliation. Conduct end-to-end ETL testing, including source-to-target validation, transformation logic verification, and data completeness checks. Write, review, and optimize SQL queries (joins, CTEs, window functions) to validate complex business rules and data transformations. Execute Unix/Linux commands and shell scripts for ETL job monitoring, file validation, and log analysis. Work with Mainframe systems for flat file validation, dataset checks, and job executions in ETL processes. Test data warehouse components such as staging, fact, and dimension tables, including Slowly Changing Dimensions (SCDs). Integrate automated validation into ETL CI/CD pipelines (Jenkins, GitHub Actions). Collaborate with ETL developers, data modelers, and business analysts to investigate issues and ensure accurate data flow across banking systems. Prepare test evidence, automation reports, and dashboards for traceability and coverage metrics. Must Have Skills: Strong proficiency in Python (pandas, pyodbc, data comparison and validation frameworks). Expertise in SQL complex joins, aggregations, subqueries, and analytical functions. Strong understanding of Oracle databases/datawarehouse and relational data modeling. Proficiency in Unix/Linux commands (grep, awk, sed, shell scripting). Basic knowledge of Mainframe systems for dataset handling. Good understanding of Data Warehousing concepts staging, data marts, fact/dimension modeling, and SCD handling. Familiarity with test management tools (Rally, JIRA, Qtest) and CI/CD tools (Git, Jenkins). Location : Delhi Educational Qualification: UG: B. Tech /B.E. in Any Specialization. Good to Have Skills: Banking domain exposure, especially in: Corporate & Institutional Banking (e.g., treasury, lending, payments, trade finance). Personal Banking (e.g., retail accounts, loans, deposits, credit cards). Knowledge of data governance and quality frameworks. Exposure to API testing for data ingestion and integration layers. Ability to implement data validation automation within ETL CI/CD pipelines. Soft Skills Strong analytical and problem-solving skills with keen attention to data accuracy. Excellent communication and collaboration with cross-functional teams. Ability to work independently in fast-paced Agile environments. Detail-oriented, proactive, and quality-driven mindset. How you will grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there is always room to learn. We offer opportunities to help build excellent skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Centre. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. Our purpose Deloitte is led by a purpose: To make an impact that matters . Every day, Deloitte people are making a real impact in the places they live and work. We pride ourselves on doing not only what is good for clients, but also what is good for our people and the Communities in which we live and workalways striving to be an organization that is held up as a role model of quality, integrity, and positive change. Learn more about Deloitte's impact on the world Recruiter tips We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you are applying to. Check out recruiting tips from Deloitte professionals.