• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 10th Mar 2021

Oracle Developer

Developed PL/SQL Stored procedures in Oracle12 for processing data and populating staging table, error table and fact tables

Developed autosys job to load data from staging table to warehouse
Created informatica mapping, workflow, and session that also includes transformation like lookup strategy, update strategy, router strategy and so on.
Developed PL/SQL stored procedures, changes on transaction database as part of enhancements
Used Jenkins to do continuous integration builds.
Created PL SQL packages to handle order generation on the transactional database.
Performed performance tuning of sql queries that were being used in packages.
Environment: Oracle 12c, SQL Loader, PL/SQL Developer, Visio 2010, Informatica 10, Autosys, Jira, Sonar, Unix Shell Scripting, ETL tools