Aniket Mohan Nevase
Pune
Summary
Having 4+ years of experience as an Informatica ETL Developer in the IT development space at IGO Solutions Pvt. Ltd. Experience in development, implementation, testing, and production support of Data Warehousing and Data Integration solutions using Informatica PowerCenter. Proficient in SQL, PL/SQL, and UNIX scripting with hands-on experience in Oracle, SQL Server, and MongoDB. Worked with Control-M for job scheduling, monitoring, and automation of ETL workflows. Involved in all phases of Software Development Life Cycle (SDLC) including analysis, design, coding, unit testing, and production support. Extensive experience in ETL design and development for data extraction, transformation, and loading (ETL) using Informatica PowerCenter. Extracted and integrated data from flat files, relational databases, and staging areas. Migrated Mappings, Sessions, and Workflows across Development, Test, and Production environments. Developed Informatica Mappings, Reusable Transformations, and Mapplets for Star and Snowflake schema implementations. Expertise in using Aggregator, Lookup (with SQL overrides), Router, Source Qualifier (with filters), Update Strategy, Expression, Joiner, Sequence Generator, and Normalizer transformations. Created sessions, performed data extraction, applied transformations, and loaded data into Data Warehouse environments. Participated in daily status calls, customer discussions, and Agile/Scrum ceremonies, ensuring smooth communication and project progress. Collaborated with downstream reporting teams (Tableau, Power BI) to design ETL pipelines supporting business dashboards. Strong problem-solving, debugging, and optimization skills, with proven ability to meet deadlines and handle multiple tasks in fast-paced environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
ETL Developer/Support
Sentry Insurance
09.2023 - Current
- Company Overview: Sentry Insurance is a UK-based insurance services organization. Its subsidiaries provide medical, dental, disability, life, and accident insurance products and services, primarily through employers and group offerings.
- Developed and optimized SQL Server, PL/SQL, and Snowflake stored procedures/functions for compensation and incentive calculations.
- Analyzed and tuned long-running SQL/PLSQL queries, improving performance and reducing execution time by 30%.
- Designed and developed Informatica PowerCenter and IICS mappings to implement business rules and perform ETL data loading with optimization where necessary.
- Worked on long-running ETL jobs and implemented performance tuning solutions at the mapping, session, and SQL levels.
- Efficiently designed mappings using basic transformations (Filter, Router, Source Qualifier, Lookup, etc.) and advanced transformations (Aggregator, Joiner, Sorter, Update Strategy, Sequence Generator, Expression).
- Created Reusable Mapplets and Transformations to implement business rules, ensuring modularity and reducing redundancy.
- Extracted and processed data from Flat Files, Relational Databases, Snowflake, and XML sources into the Data Warehouse.
- Extensively worked with Mapping Variables, Mapping Parameters, and Session Variables for dynamic ETL design.
- Managed and monitored workflows in IICS and Informatica PowerCenter Workflow Manager, including scheduling, monitoring, and error handling.
- Automated and monitored batch ETL processes using Control-M job scheduling for efficient workflow execution.
- Developed test plans, test cases, and test scripts aligned with mapping documents, ensuring accurate validation of ETL processes.
- Performed ETL performance tuning at functional, mapping, and SQL levels to enhance overall data processing efficiency and minimize network data transfer.
- The project involved loading agent and policy details from relational tables into a Data Warehouse and calculating compensation and incentive amounts twice monthly as per defined business rules.
ETL Developer
PNC Bank
01.2022 - 08.2023
- Company Overview: PNC Bank initiated the Trade Repository Project to create a certified global copy of the deal repository, enabling reporting services for a wide range of over-the-counter (OTC) financial instruments. The repository serves both financial and non-financial institutions, providing flexible participation levels tailored to diverse stakeholder needs in the derivatives market.
- Designed and developed Fact and Dimension tables to support reporting requirements.
- Involved in dimensional modeling (Star and Snowflake Schema) as part of the SDLC process for building the Data Warehouse.
- Analyzed source system data and prepared low-level design documents (LLD) to ensure accurate data mapping and successful data loading.
- Extracted, transformed, and loaded data from Oracle databases and Flat Files into staging and target Oracle databases using Informatica PowerCenter.
- Studied functional/BRD documents to gain a complete understanding of business requirements and client needs.
- Identified and resolved session performance bottlenecks using thread statistics, improving overall load efficiency.
- Implemented Slowly Changing Dimensions (SCD Types 1, 2, and 3) and Change Data Capture (CDC) using Informatica.
- Created and optimized indexes and views to improve query performance and simplify complex queries.
- Designed and implemented various Informatica mappings using Expression, Lookup, Update Strategy, Router, Aggregator, and Sequence Generator transformations.
- Optimized mappings by filtering data at the Source Qualifier, reusing logic in the Expression Editor, and applying Informatica best practices.
- Implemented partitioning strategies to further enhance ETL performance.
- The repository serves both financial and non-financial institutions, providing flexible participation levels tailored to diverse stakeholder needs in the derivatives market.
Developer
ETC PJS
Dubai, UAE
06.2021 - 12.2021
- Company Overview: PNC Bank initiated the Trade Repository Project to create a certified global copy of the deal repository, enabling reporting services for a wide range of over-the-counter (OTC) financial instruments. The repository serves both financial and non-financial institutions, providing flexible participation levels tailored to diverse stakeholder needs in the derivatives market.
- Designed and developed Fact and Dimension tables to support reporting requirements.
- Involved in dimensional modeling (Star and Snowflake Schema) as part of the SDLC process for building the Data Warehouse.
- Analyzed source system data and prepared low-level design documents (LLD) to ensure accurate data mapping and successful data loading.
- Extracted, transformed, and loaded data from Oracle databases and Flat Files into staging and target Oracle databases using Informatica PowerCenter.
- Studied functional/BRD documents to gain a complete understanding of business requirements and client needs.
- Identified and resolved session performance bottlenecks using thread statistics, improving overall load efficiency.
- Implemented Slowly Changing Dimensions (SCD Types 1, 2, and 3) and Change Data Capture (CDC) using Informatica.
- Created and optimized indexes and views to improve query performance and simplify complex queries.
- Designed and implemented various Informatica mappings using Expression, Lookup, Update Strategy, Router, Aggregator, and Sequence Generator transformations.
- Optimized mappings by filtering data at the Source Qualifier, reusing logic in the Expression Editor, and applying Informatica best practices.
- Implemented partitioning strategies to further enhance ETL performance.
- The repository serves both financial and non-financial institutions, providing flexible participation levels tailored to diverse stakeholder needs in the derivatives market.
Education
Master of Science (M.Sc.) - Organic Chemistry
Savitribai Phule Pune University
05.2021
Bachelor of Science (B.Sc.) - undefined
Savitribai Phule Pune University
05.2019
Skills
- Databases: Oracle 10g/11g, Teradata, SQL Server, Snowflake, PL/SQL
- Domains: Insurance, Finance & Banking, Healthcare
- ETL Tools: Informatica PowerCenter (9x/10x), Informatica Intelligent Cloud Services (IICS)
- Programming Languages: Python
- Reporting/BI Tools: Power BI, Tableau
- Other Tools: UNIX Shell Scripting, Control-M
- Operating Systems: Windows 7/8/10/11
Certification
Adv. Certification - Full Stack Data Science and AI | Indian Institute of Technology, Guwahati (IIT-G) EICT (Pursuing)
TECHNICAL SKILL
Languages Known: English, Hindi, Marathi
Timeline
ETL Developer/Support
Sentry Insurance
09.2023 - Current
ETL Developer
PNC Bank
01.2022 - 08.2023
Developer
ETC PJS
06.2021 - 12.2021
Bachelor of Science (B.Sc.) - undefined
Savitribai Phule Pune University
Master of Science (M.Sc.) - Organic Chemistry
Savitribai Phule Pune University
TECHNICAL SKILL
- Name: Aniket Mohan Nevase
- Date of Birth: 12 April 1997
- Nationality: Indian
- Address: Katraj, Pune, 411046