Nikita Vijaywargia
Pune
Summary
Senior ETL Developer with 5+ years of experience in designing, building, and optimizing data integration solutions. Proficient in Informatica, IICS (IDMC), SQL, Snowflake, and data warehousing, with a strong ability to enhance data accuracy, streamline workflows, and improve accessibility. Skilled in leading cross-functional teams to drive high-impact solutions and ensure seamless data processing across platforms.
Experienced in mainframe development (COBOL, JCL, DB2, IMS-DB, CICS) with a proven track record of leading critical implementations and optimizing legacy systems. Adept at leveraging PowerShell scripting to automate processes and coordinate cross-system interactions, improving efficiency and scalability. Recognized for problem-solving, leadership, and a customer-centric engineering mindset, consistently delivering robust, efficient, and scalable ETL solutions.
Overview
8
8
years of professional experience
Work History
Senior ETL Developer
Sun Life Financial
Gurugram
08.2022 - Current
- Designed and implemented ETL solutions using IICS (Informatica Intelligent Cloud Services) to streamline data extraction, transformation, and loading (ETL) processes.
- Developed advanced SQL scripts and optimized stored procedures, improving data retrieval and query performance by 30%.
- Led data warehousing initiatives, ensuring efficient data modeling and integration with Snowflake for scalable, cloud-based analytics.
- Automated ETL workflows and deployment processes using PowerShell scripting, reducing manual effort, and improving operational efficiency.
- Developed PowerShell scripts to coordinate data exchanges and system interactions across multiple platforms, improving cross-system communication and automation.
- Spearheaded the production rollout of key features, maintaining 100% adherence to project deadlines, and minimizing downtime.
- Optimized data pipelines and debugging processes, identifying bottlenecks, and implementing performance enhancements.
- Collaborated with cross-functional teams to align ETL strategies with business objectives and technical requirements.
- Managed and resolved time-sensitive issues, ensuring high system availability, and operational stability.
- Created and maintained comprehensive technical documentation, standardizing best practices, and improving knowledge transfer.
- Mentored junior ETL developers, fostering best practices.
- Earned multiple accolades and recognition for exceptional task handling and ownership.
- Led mainframe development efforts, delegated tasks, facilitated team discussions, and resolved blockers to ensure timely sprint deliveries.
Senior Software Engineer
Accenture
Pune
06.2021 - 08.2022
- Optimized data integration workflows by designing and developing high-performance ETL processes using Informatica PowerCenter.
- Improved reporting efficiency by creating reusable SQL queries and stored procedures, reducing query execution time, and enhancing data accessibility.
- Implemented robust change management procedures to ensure seamless production transitions, with minimal operational disruptions.
- Authored comprehensive documentation detailing ETL functionalities, serving as a valuable reference for maintenance and future enhancements.
- Collaborated with cross-functional teams to define data requirements, ensuring the timely and accurate delivery of business-critical insights.
- Provided production support, troubleshooting issues, and facilitating smooth deployments across different environments.
- Recognized for exceptional analytical skills and full ownership of high-complexity tasks, earning the prestigious 'Star Performer' award at Accenture (2x).
Senior Engineer
Accenture
Pune
05.2017 - 05.2021
- Bridged the gap between business and technical teams by collaborating with client-side delivery leads, ensuring effective communication of business needs, and deliverables.
- Led sprint planning and coordination, including stand-up meetings, backlog management, and monthly sprint planning, to drive project efficiency.
- Served as a Subject Matter Expert (SME) for a financially critical mainframe application, providing strategic guidance and technical expertise.
- Developed, tested, and deployed COBOL/JCL/DB2 modules, managing: Business requirement analysis, impact assessment and code changes, comprehensive testing (unit, integration, system, performance, regression, and acceptance), final deployment, and post-release support.
- Recognized as a ‘Star Performer’ (4x) at Accenture for exceptional analytical skills, and consistent delivery of high-complexity tasks with complete ownership.
- Automated multiple manual processes, improving efficiency, and reducing manual effort by 80%.
- Led the yearly bonus declaration event for four consecutive years, ensuring a seamless and error-free execution of a critical financial process.
- Facilitated onboarding and transition of 20+ new hires, delivering: Knowledge Transition (KT) sessions, structured KT plans, and domain expertise, as well as hands-on mentoring and training.
- Authored 30+ technical guides and knowledge base manuals to document key mainframe application processes, ensuring streamlined knowledge transfer, and operational consistency.
Education
Bachelor of Technology - Information Technology
Rajasthan Technical University (JECRC)
Jaipur, India, India05-2017
Skills
ETL & Data Warehousing:
- PowerCenter Informatica
- IICS (IDMC)
- Snowflake
- SQL
- Data Warehousing
- ETL Development
Mainframe Technologies:
- COBOL
- JCL
- DB2
- IMS-DB
- CICS
DevOps:
- Jenkins
- GitHub
- CI/CD
Scripting
- PowerShell Scripting
Agile & Project Management:
- Scrum
- JIRA
- SDLC
- Sprint Coordination
Technical & Soft Skills:
- Debugging
- Problem-Solving
- Critical Thinking
- Leadership
- Excellent Communication
Projects
Volunteering
- Volunteer – 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 & Hosted ‘Spell Bee’ Competition (100+ participants) – College Fest (03/2016)
Languages
Hindi
First Language
English
Proficient (C2)
C2
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)
Similar Profiles
Jawondee TuckJawondee Tuck
Intake Supervisor-Outbound at Sun Life FinancialIntake Supervisor-Outbound at Sun Life Financial
Renee SmithRenee Smith
Shares Services /Claims Examiner at Sun Life FinancialShares Services /Claims Examiner at Sun Life Financial
Marc RegisMarc Regis
Analyst Programmer at Sun Life Financial Asia Services LimitedAnalyst Programmer at Sun Life Financial Asia Services Limited