Project1: - Aug,2022 to Currently

Project Description: Working on a migration of finance data pipelines from Legacy(Oracle) to Cloud Server(Redshift).

Tehnologies:- Oracle, Informatica Powercenter, Databricks, QETL(based on spark), S3, SparkSQL

Roles & Responsibilities:

• Working on analysis and backtracking of informatica mappings.
• Building SQL queries for all ETL jobs which are yet to be migrated on QETL.
• Writing SQL queries to analyse and manipulate data using all type of joins, sub-query, Windows functions.
• Understand analysis framework, data requirements, code analysis, and discuss results.
• Perform data loads and routine updates on an ongoing basis.

Project2: --- June,2020 to June,2022

Project Description: Managing the finance datasets in ODS and using ETL operations like Filtering, Cleaning, Joining, Splitting, Sorting as per business rules and then loading it into Centralized DWH system(Oracle).

Tehnologies:- Oracle, SSMS, Informatica Powercenter

Roles & Responsibilities:

• Involved in client team meeting and provide them the business updates.
• Worked on deployment of objects into Prod Environment.
• Root cause analysis on failed jobs and provide solutions on it.
• Perform data loads and routine updates on an ongoing basis.
• Monitoring ETL and DRM jobs.
• Ensuring all client deliverables to meet client expectations in terms of scope, speed & quality.

Project-3 : -- Aug 2018 to Mar, 2020

Project Description: Maintains the claim data in DWH to support the downstream reporting systems.

Technologies: - Informatica Powercenter, Oracle

Roles and Responsibilities:

• Interacting and understanding with Client Business requirements and work on it.
• Involved in debugging process.
• Data loading through DML using SQL queries.
• Enhancing and bug fixing of existing setup.
• Responsible for Informatica mapping and workflow fixing.
• Taking ownership of requirement gathering, code deployment and testing.
• Deployment Documentations and post production monitoring and support.