Aniket Patil
Senior System Analyst
Mumbai
Summary
- Having 3+ years of in-depth experience in development, implementation and testing of Data Warehouse solutions.
- Hands on ETL development experience in designing, developing and maintaining data pipelines using Informatica Power Center. PostgreSQL as database, Shell Scripting and SAP Business Objects.
- Proficient in developing complex SQL queries and resourceful in performing analysis of high volume data with purpose of understanding or making conclusion for decision making purposes.
- Experience in working with large datasets, data cleansing and data validation including debugging, troubleshooting, and optimizing ETL pipelines.
- I believe working in a challenging environment with creative aspects that will help me and the organization growth. Keen to learn new technologies.
Overview
4
4
years of professional experience
7
7
years of post-secondary education
3
3
Languages
Work History
Senior System Analyst
National Stock Exchange Of India Limited
Mumbai
04.2021 - Current
- Designed and developed mappings, mapplets, sessions, and workflows using Informatica PowerCenter to load data from source to target databases, with practical exposure to Slowly Changing Dimensions (SCD Type 1, Type 2) for handling historical data in data warehouses.
- Worked with the Business users to gather requirements and implementing the same into a functional data warehouse design.
- Developed and optimized mappings using various transformationslike Source Qualifier, Aggregator, Filter, Router, Sequence Generator, Lookup, Joiner, Expression, and Update Strategy to meet business logic while improving performance and efficiency.
- Extracted data from various sources like Flat Files, Oracle and loaded it into Target systems.
- Developed complex SQL queries to extract user requested data/information from high volume datasets, comprising millions of records.
- Developed new mappings and updating existing mappings according to changes in Business Logic.
- Developed and optimized SQL queries for the clients of largest derivative market by volume (NSE), enhancing process efficiency, data validation, prechecks and process automation while ensuring high-performance data retrieval and analysis.
- Performed performance tuning, including query optimization, partitioning.
- Hands-on experience in Business Intelligence Reporting Tool : SAP Business Objects.
- Took ownership of critical data projects wherein responsible for Regulatory and Inspection compliance.
- Worked in Development as well as production support environment for bug fixes, enhancements, data changes.
- Involved in platform migration activity, converting ETL pipelines and SQL queries from Greenplum to Cloudera(HDFS).
- Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
- Excellent problem solving skills with a strong technical back
Education
Diploma in Advanced Computing -
Mumbai Educational Trust, Bandra
Mumbai 02.2020 - 02.2021
BE in Electronics And Telecommunication -
Saraswati College of Engineering, Kharghar
Navi Mumbai 07.2016 - 05.2019
Diploma in Electronics And Telecommunication -
Vidyalankar Polytechnic, Wadala
Mumbai 06.2013 - 05.2016
Skills
Data Warehousing
Extract, Transform, Load (ETL)
Informatica
SQL
Shell Scripting
SAP Business Object
PostgreSQL
Greenplum
Timeline
Senior System Analyst
National Stock Exchange Of India Limited
04.2021 - Current
Diploma in Advanced Computing -
Mumbai Educational Trust, Bandra
02.2020 - 02.2021
BE in Electronics And Telecommunication -
Saraswati College of Engineering, Kharghar
07.2016 - 05.2019
Diploma in Electronics And Telecommunication -
Vidyalankar Polytechnic, Wadala
06.2013 - 05.2016
Similar Profiles
ABHIJEET MANDOREABHIJEET MANDORE
Senior Manager (Trading application UAT group) at The National Stock Exchange of India LimitedSenior Manager (Trading application UAT group) at The National Stock Exchange of India Limited
VARADARAJAN MVARADARAJAN M
Senior Manager- Regulatory and Compliance - Inspection at National Stock Exchange of India LimitedSenior Manager- Regulatory and Compliance - Inspection at National Stock Exchange of India Limited
Kritika ShahiKritika Shahi
System Analyst at National Stock Exchange of India LimitedSystem Analyst at National Stock Exchange of India Limited