Nikita Vijaywargia
Senior ETL Developer
Pune
Summary
Highly skilled ETL developer with over 5 years of experience in designing, building, and maintaining complex data extraction, transformation, and loading processes. Proficient in Informatica, IICS(IDMC), SQL, Snowflake, with a proven track record in data warehousing, ETL development, and delivering high-impact data integration solutions. Demonstrated ability to leverage SQL and data warehousing skills to enhance data accuracy and accessibility. Strong leadership skills and ability to inspire teams to achieve project goals and maintain a customer-centric engineering mindset. Proficient in COBOL, JCL, DB2, IMS-DB, CICS, leading mainframe developers to successful implementations.
Overview
8
8
years of professional experience
2
2
Languages
Work History
Senior ETL Developer
Sun Life Financial
08.2022 - Current
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Developed complex SQL queries for improved data extraction and accurate reporting.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Spearheaded the production deployment of 5 key features, ensuring the go-live within the expected deadlines, with no operational disruptions
- Collaborated with the client's leadership team in brainstorming technical solutions aligned with their objectives, translating them into actionable strategies
- Hands-on experience in fast-paced agile-scrum cross-functional delivery projects, even under high-pressure requirements
- Evaluated new technologies as potential solutions for enhancing current ETL processes, providing recommendations based on research findings.
- Addressed critical issues in a timely manner, minimizing downtime and ensuring uninterrupted service levels.
- Documented technical specifications, enabling seamless knowledge transfer among team members.
- Acknowledged for delivery of high-complexity tasks with complete ownership within timeline, earning multiple applause and 'Owner's Mindset' award.
- Mentored junior developers, sharing knowledge of best practices in ETL development and design.
- Also, leading mainframe development work in the squad, with responsibilities such as tasks delegation, facilitating discussions with team members to address challenges and risks, resolving blockers, conducting thorough code reviews, ensuring timely sprint task delivery, and providing technical support for Production releases using CI/CD which require rapid bug resolutions.
Senior Software Engineer
Accenture
06.2021 - 08.2022
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Streamlined reporting processes by developing reusable SQL queries and stored procedures.
- Implemented change management procedures throughout the development lifecycle ensuring minimal disruption during production transition.
- Created detailed documentation outlining the functionality of developed ETL processes which served as valuable reference material for future maintenance or enhancements.
- Collaborated with cross-functional teams to define data requirements, resulting in accurate and timely delivery of business-critical data.
- Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
- Acknowledged for exceptional analytical skills and consistent delivery of high-complexity tasks with complete ownership, earning the prestigious 'Star Performer' award at Accenture 2 times.
Senior Engineer
Accenture
05.2017 - 05.2021
- Business Relationship Management: Dealt with client-side delivery leads, bridged the gap between business and technical team by addressing their needs and maintaining the business deliverables
- Sprint coordinator - Led Sprint meetings with the client, planned monthly sprints, managed backlogs, and drove standup calls in the team.
- Subject Matter Expert in one of the financially critical mainframe applications in the project
- Application Developer - Actively involved in the build, testing, and deployment of COBOL/JCL/DB2 modules where my daily responsibilities include - Business requirement analysis, designing DADs, code changes, impact analysis, testing (unit, integration, system, performance and capacity, regression, acceptance) and deployment
- Acknowledged for exceptional analytical skills and consistent delivery of high-complexity tasks with complete ownership, earning the prestigious 'Star Performer' award at Accenture 4 times
- Automated multiple processes that substantially improved the business process and reduced the manual effort by 80%
- Lead Technician for the yearly event - Led a significantly critical, yearly bonus declaration event for 4 years
- Led new joiners' transition process- Delivered Knowledge Transition sessions, prepared KT plans, provided domain expertise, and mentored 20+ new team members
- Wrote 30+ technical guides and knowledge base manuals for mainframe applications in the project
Education
Bachelor of Technology - Information Technology
Rajasthan Technical University (JECRC)
Jaipur, India 8 2013 - 5 2017
Skills
IICS
undefinedProjects
TICKET NOW - A movie ticket reservation application (05/2016)
Makes the ticket reservation & management task effortless via an easy interface for the users and the admins of a movie theatre.
Developed using HTML5, CSS & Bootstrap for front-end, Java servlets & JDBC for the back end.
Volunteering
• Volunteer at International NGO Child Rights and You (04/2021-08/2021)
• Research collaborator - Coronavirus visualization team (07/2021-10/2021)
• Ambassador & Volunteer – Jaipur Literature Festival (02/2016)
• Organized and anchored (Spell Bee) Mar ’16 Spelling competition with a participation of 100+, College fest (03/2016)
Timeline
Senior ETL Developer
Sun Life Financial
08.2022 - Current
Senior Software Engineer
Accenture
06.2021 - 08.2022
Senior Engineer
Accenture
05.2017 - 05.2021
Bachelor of Technology - Information Technology
Rajasthan Technical University (JECRC)
8 2013 - 5 2017
Similar Profiles
SHERYL DE VERASHERYL DE VERA
Financial Advisor at Sun Life FinancialFinancial Advisor at Sun Life Financial
Cristian TononCristian Tonon
Financial Advisor at Sun Life FinancialFinancial Advisor at Sun Life Financial
Deepika GotterDeepika Gotter
Insurance Broker at Sun Life FinancialInsurance Broker at Sun Life Financial