Sandhya Mudaliyar
Lead Consultant
Mumbai
Summary
Results-driven and highly skilled ETL Lead Consultant with 8+ years of experience designing, developing, and implementing complex data integration solutions across diverse industries.
Domain experience spans across banking, healthcare, pharmaceuticals, and public service, providing a comprehensive understanding of industry-specific challenges and solutions.
Proven expertise in IBM DataStage, Oracle, Hive SQL and Unix along with Snowflake knowledge.
Overview
2025
2025
years of professional experience
5
5
Certifications
Work History
Lead Consultant
Genpact India Pvt Ltd
6 2021 - Current
- Led team of 7 members for the migration of legacy data systems to a modern Hadoop ecosystem, ensuring seamless transition with minimal downtime and data integrity.
- Collaborated with cross-functional teams to design and implement scalable and efficient data pipelines.
- Assessed potential risks during project planning stages, developing contingency plans to mitigate negative impacts on deliverables.
- Designed and Developed multiple Datastage jobs to implement new workflow designs.
- Scheduled jobs using UAC (Universal Automatic center).
- Used Azure CI/CD pipelines to deploy code.
- Active involvement in all technical discussion, decision making meetings and regular interaction with Product Owner and architects to gain better understanding of the business process, requirement and design.
- Delivered training to team members on the new Hadoop environment, resulting in improved operational knowledge and productivity.
Senior Technical Services Specialist
IBM India Pvt Ltd
06.2020 - 06.2021
- Senior ETL developer possessing both Technical and Functional knowledge of Banking Domain.
- Working on the data mart creation and report creation for Bank's RBI Regulatory reporting track.
- Handle large volume of data on a daily basis to maintain the centralized data repository for India's largest Bank.
- Interact with Client on a regular basis to understand the new requirements.
- Develop new DataStage jobs as per the requirement and perform Unit testing.
- Provide quick analysis and fix for the data issues reported by business.
Software Engineer
Accenture Services Pvt Ltd
07.2016 - 05.2020
- Experience in performing SDLC activities from gathering requirements and designing solutions, through developing jobs/codes to testing and deployment.
- Have developed multiple new interfaces using IBM Datastage and have also enhanced the existing jobs to fit in the upcoming changes.
- This include extracting data from different sources like flat files or Database and transforming it as per the business needs and then loading it in the target tables.
- Vice versa, Extracting data from tables and creating extract files to supply to the client/vendor.
- Hands-on experience in job scheduling using TWS.
- In this project, we develop and manage a data warehouse which act as a global repository for Post Office Ltd products, customers and sales.
- Have exposure to Kalido DIW which is a Dynamic Information Warehouse and represent to be a global repository in our project.
- Look after the day-to-day batch and fix issue when encountered.
Education
B.Tech - Electronics
SNDT Women's University
HSC - undefined
Maharashtra State board
Skills
IBM Datastage
Certification
Leadership Excellence: Innovation Award, Genpact
Timeline
Senior Technical Services Specialist
IBM India Pvt Ltd
06.2020 - 06.2021
Software Engineer
Accenture Services Pvt Ltd
07.2016 - 05.2020
HSC - undefined
Maharashtra State board
Lead Consultant
Genpact India Pvt Ltd
6 2021 - Current
B.Tech - Electronics
SNDT Women's University
Similar Profiles
Deepesh TalegaonkarDeepesh Talegaonkar
Operation Manager at Genpact India Pvt Ltd.Operation Manager at Genpact India Pvt Ltd.
Nidhi NimkarNidhi Nimkar
Assistant Manager – Procurement Support at Genpact India Pvt. Ltd.Assistant Manager – Procurement Support at Genpact India Pvt. Ltd.
AISHWARYA DAMODARANAISHWARYA DAMODARAN
Manager - R2R Profile (Transition Project) at GENPACT INDIA PVT LTDManager - R2R Profile (Transition Project) at GENPACT INDIA PVT LTD
Hiteshi KapoorHiteshi Kapoor
Senior Manager Ops at Genpact India Pvt. Ltd.Senior Manager Ops at Genpact India Pvt. Ltd.
Shikha NishadShikha Nishad
Director of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt LtdDirector of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt Ltd