Oracle PL/SQL with Unix and Knowledge on Informatica Cognos/Tableau

9/2017 – 9/2020

- Working as Senior Software Developer on ETL Informatica and Oracle in Risk and Finance Department.
- T-Shaped Involved in development, Manual and Automated testing using SpecFlow tool. Technical Analysis, PBI creation and followed structured PBI lifecycle process.
- As a developer involved in APTITUDE to Informatica Migration process.
Migrating Old ETL process to Informatica for AEG – Accounting and S2B – Reconciliation modules.
- NFRA - New Financial Reporting Architecture for decommissioning EUMIS which is European Datawarehouse. This Involves processing both financial and non-financial data through proper Channel Global Financial System to eliminate redundancy. Transfer of data from one system to other using Unix, ETL Informatica and Oracle PL/SQL jobs.
- Used Oracle APEX for processing of manual non-financial data files. Authorizing and approving it before processing the data.
- Understand the functional requirement and gather inputs for tasks. Analyze
data and discuss the outcome of same with client.
- As a senior resource was involved in impact analysis, 3rd line support and grooming new members in team.
- Used Tools like Dollar Universe for scheduling the workflows. Used SpecFlow to Automate testing.
- Followed Agile methodology for development. Used tools like Visual Studio and TFS, Git, Azure Devops for Code Configuration, task tracking, estimation and maintenance. XL-Release and Deploy (Tool by XebiaLabs) for Continuous Integration / Delivery.

ETL, Informatica, PL/SQL

9/2017 – 9/2020

- Working as Senior Software Developer on ETL Informatica and Oracle in Risk and Finance Department.
- T-Shaped Involved in development, Manual and Automated testing using SpecFlow tool. Technical Analysis, PBI creation and followed structured PBI lifecycle process.
- As a developer involved in APTITUDE to Informatica Migration process.
Migrating Old ETL process to Informatica for AEG – Accounting and S2B – Reconciliation modules.
- NFRA - New Financial Reporting Architecture for decommissioning EUMIS which is European Datawarehouse. This Involves processing both financial and non-financial data through proper Channel Global Financial System to eliminate redundancy. Transfer of data from one system to other using Unix, ETL Informatica and Oracle PL/SQL jobs.
- Used Oracle APEX for processing of manual non-financial data files. Authorizing and approving it before processing the data.
- Understand the functional requirement and gather inputs for tasks. Analyze
data and discuss the outcome of same with client.
- As a senior resource was involved in impact analysis, 3rd line support and grooming new members in team.
- Used Tools like Dollar Universe for scheduling the workflows. Used SpecFlow to Automate testing.
- Followed Agile methodology for development. Used tools like Visual Studio and TFS, Git, Azure Devops for Code Configuration, task tracking, estimation and maintenance. XL-Release and Deploy (Tool by XebiaLabs) for Continuous Integration / Delivery.

ETL, Informatica, PL/SQL