Khushaboo Dhanorkar
ETL Developer/Lead
Pune
Summary
Senior ETL Developer/Lead over a decade of experience in developing and delivering data warehousing solutions for banking and medical domains. Skilled in leading ETL processes, collaborating with cross-functional teams, and implementing ETL strategies for real-time analysis. Proficient in Informatica Cloud, IDMC Data Integration, Data Profiling/Quality . Informatica Powercenter, SQL, Snowflake, and various databases. Accomplished in Agile methodologies and deploying DevOps technologies. Adept at providing end-to-end support for middleware applications and ensuring data integrity. Proven success in developing complex data warehouse solutions and resolving data-related issues.
Overview
11
11
years of professional experience
7
7
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
Senior ETL Developer/Lead
Zensar Technology
04.2022 - Current
- Developed and delivered data warehousing solutions for banking and medical domains
- Led ETL processes for data extraction from various sources (REST API, AWS, Blob, relational DBs) to target databases
- Design and build a data warehouse to store data safely and securely
- Troubleshoot and fix issues
- Organized daily technical discussions and participated in Scrum sprints
- Developed ETL processes for incremental HR data from REST API into Snowflake
- Manage the issues raise from QA and assign work items to the team and take up critical work items
- Document ETL mapping strategies and transformations involve in the extraction, transformation and loading process
- Created dimensions and fact tables for HR reporting (e.g., turnover and headcount summaries)
- Built a complex data warehouse for real-time analysis and reporting of key metrics
- Integrated data from multiple sources into a unified data warehouse
- Collaborated with cross-functional teams to resolve data-related issues
- Developed a data governance strategy to ensure data integrity and security
- Worked on IDMC Data Profiling and Data Quality to clean up the source data
- Streamlined data transformation for faster processing, reducing overall processing time.
- Ensured compliance with industry standards by adhering to strict guidelines during data migration projects.
- Improved collaboration between IT and business stakeholders through clear communication of project goals and progress updates.
Senior ETL Developer
Wipro Technologies
09.2019 - 03.2022
- Worked in the Banking and Financial Domain (Credit Suisse)
- Engaged in ETL processes for trade facts and economic data extracts from various source systems
- Participated in Agile methodology, including daily scrums and sprint planning
- Create data pipelines that organize and filter data
- Ensure that data is of high quality
- Utilized DevOps technologies for deployment (e.g., GIT, SVN)
- Conducted complete unit testing and prepared test data
- Prepared test results documents and S2T mapping
- Provided SIT, UAT, and RIT testing support
- Successfully deployed components in production
- Offered L3 support for ongoing production issues
- Mentored junior developers, sharing knowledge of best practices in ETL development and design.
ETL Developer
Cognizant Technology Solutions
07.2014 - 08.2019
- Worked in the Banking and Finance domain (Voya Financial)
- Provided end-to-end support for middleware applications and ETL services
- Troubleshooted the production failure and fixed them timely
- Worked on Performance improvement techniques
- Managed numerous job streams and ensured incident resolution
- Developed and enhanced ETL applications for banking projects
- Analyzed data discrepancies and collaborated with business for solutions
- Handled re-hosting requests and application decommissioning, including impact analysis.
- Prepared WSR for project maintenance activities
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
Education
B.Tech -
Shri Guru Gobind Singhji Institute of Engineering and Technology
07.2010 - 06.2014
Higher Secondary School - undefined
Nagpur Board
06.2008 - 06.2010
Secondary School Certificate - undefined
Nagpur Board
06.2007 - 06.2008
Skills
ETL TOOLS- Informatica Cloud,Informatica Powecenter, ADF
undefinedCertification
Snowflake Certified, SnowPro Core Certification
Timeline
Senior ETL Developer/Lead
Zensar Technology
04.2022 - Current
Senior ETL Developer
Wipro Technologies
09.2019 - 03.2022
ETL Developer
Cognizant Technology Solutions
07.2014 - 08.2019
B.Tech -
Shri Guru Gobind Singhji Institute of Engineering and Technology
07.2010 - 06.2014
Higher Secondary School - undefined
Nagpur Board
06.2008 - 06.2010
Secondary School Certificate - undefined
Nagpur Board
06.2007 - 06.2008
Similar Profiles
AKSHAY GMAKSHAY GM
Technical Consultant at Zensar TechnologyTechnical Consultant at Zensar Technology
Rutuja Yashwant PatilRutuja Yashwant Patil
Software Engineer F2 at Zensar TechnologySoftware Engineer F2 at Zensar Technology
Ankita NaphadeAnkita Naphade
Developer at Zensar TechnologyDeveloper at Zensar Technology
Minal GhubdeMinal Ghubde
Sr. System Engineer at Zensar TechnologySr. System Engineer at Zensar Technology
Soumyadeep GhoshSoumyadeep Ghosh
Graduate Engineer Trainee at Air ProductsGraduate Engineer Trainee at Air Products