Sahil Gupta
@sahilgupta
Software Engineer at Ameriprise Financial
Shahdara, Delhi
Sahil Gupta is a technically sound professional with 7 years of IT experience, specializing in ETL processes. He possesses 5.5 years of relevant experience in Informatica PowerCenter and 1.5 years in Oracle SQL/PL/SQL. His expertise includes data warehousing concepts, dimensional modeling (Star/Snowflake Schema), and handling complex data mapping and business rules. He is proficient in developing procedures, functions, and performing performance tuning across various database platforms.
Experience
Software Engineer
Ameriprise Financial
Team Member - ETL Developer. Technologies: Informatica Power Center 10.2, Oracle 11g, Sql Server, Mainframe, PowerExchange, TWS. Project: Bank Egret Project. Summary: Bank Egret project is for Ameriprise Financial Bank which provides the factility of credit cards, deposits, Rewards. Ameriprise issues the credit cards to clients for transaction in association with different Vendor. We receive data as per the business requirements and process via ETL and send back to the vendor.
Software Engineer
Qualtech-Constultants
Team Member - ETL Developer. Technologies: Informatica Power Center 9.6, Oracle 11g. Project: System Intergration Check (SIC). Summary: SIC is System Integration Check. It is a process to check the data integrity to make sure that all the data in the large databases of MNYL are as per the rules specified. Checking all the data for its correctness in the database manually on a daily basis is a tedious task. Hence MNYL has taken up a project to automate the process through his project, which will cover the integrity checking of various systems used in MNYL.
Technical Analyst
Kurtosys Systems India Pvt Limited
Team Member - ETL Developer. Technologies: Informatica Power Center 9.5, Oracle 10g. Project: Citi Bank Asset Management. Summary: This project was for digital marketing that provides asset management to the clients. Our client was Citi Bank. We used to take the raw data from the client in various forms like Flat file,Xml,Csv etc. regarding their funds and reponsible for producing the factsheets using various tools. We have developed the mapping for the entire vendor. We used to work on new changes as per client’s requirement. We were responsible for the UAT and used to work with Informatica Support team for the changes in the existing jobs. Responsibilities included preparing TSD/CSD, developing mappings, performance tuning, and creating procedures/functions.
IT Consultant
Adecco India
Team Member – Informatica Developer. Technologies: Oracle 10g, Informatica Power Center 9.5. Project: Travel & I Expense System. Summary: Responsible for uploading credit card transactions and processing/approving expense reports using Oracle Apps Financials. Responsibilities included writing SQL/PL/SQL queries, developing stored procedures, and using Informatica ETL.
Education
Gautam Budh Technical University
B Tech
Information Technology
Completed B Tech in Information Technology.
BVM School
Senior secondary
DMS School
High School