• Responsible for Developing and enhancing client applications by servicing new requests which involves ETL design, development, testing and review of code along with supporting documents like HLD, LLD, UT and hand over documents like technical specifications, etc.• Development of various interfaces using shell scripting and PL/SQL.• Creation of multiple UNIX scripts to perform ETL and to cater daily, weekly and monthly reporting needs. Batch scheduling and batch processing.• Enhancing the client application based on identified architecture and support implementation of design by resolving technical issues faced by the IT team during development, testing and support.• Responsible for management and performance tuning for Oracle DB objects and Unix Scripts.• Responsible for analyzing and preparing technical specs, ETL code development.• Creating detailed level technical design specifications based on high level specifications provided. Played role in design of scalable, reusable and low maintenance ETL templates• Involved in ETL job automation and scheduling and design ingenious strategies for implementing complex business requirements • Involved in development of re-usable components for the project to automate process.

• Understanding requirements, Macro and Micro design of the project.• Preparing documents for unit test plan and unit test cases.• Development of informatica mappings, workflows and sessions.• Scheduling the execution of workflows, perl scripts and unix shell scripts using internal tool (consisting of perl script and static data) called GOMD (Generic Operational Metadata).• Code review.• Preparing implementation plan and release notes to move the code to the higher environment.• Involved in Impact Analysis,Test Case(Unit Testing),Approach documentof the development done.• Execution of the various modules of data warehousing structure of the project and providing support in case of issues.• Analysis of the issues that occur while execution and sending the resolution to the client.• Reponsible for the effective handling and proper closing of the tickets within timeline.• Involved in Resolving the issue and blockersduring execution of the process of the datawarehouse load for the months data.• Worked onTOAD for Oracle,SQL,PLSQLand having Intermediate level knowledge on them.