ETL Developer / Data WareHouse Developer / Informatica Developer / Business Intelligence Developer

4/2014 – 4/2015

Roles – ETL/Business Intelligence Developer

 Involved in most of the phases of the project like Business requirement, Analysis,

Design, Discussion, Development and Documentation.

 Involved in technical design sessions with business and technical staff to develop

requirements and ETL specification documents.

 Documented the Project Architecture under the guidance of Scrum Master.

 Guided the new team members with the access related issues and providing the

overview of the project.

 Involved in both Historical Load and Incremental loading.

 Performed administration tasks like creating folders, users, groups and granting them

permissions to different repositories (Dev) using the Repository manager.

 Developed Informatica mappings using various transformations in the Power center

designer following the Standard Rules.

 Designed and developed workflows using tasks in the workflow manager.

 Created reports using Query Studio and Report Studio of Cognos BI.

 Collaborated all the sessions from individual team member into a complete workflow.

 Unit test is performed on all the sessions/tasks created by the individual team

members.

 Validating individual team member’s mappings, sessions and test cases.

 Prepared Mapping Documents and Unit Test Cases for ETL Mappings/Workflows.

 Participated in the Scrum calls with the Scrum master ,off shore and onsite teams.

Data Warehousing, Business Intelligence (BI), Informatica, ETL

8/2012 – 8/2014

 Participated in the discussions with the client and the users to explain why the

enhancement or change is needed.

 Developed or enhanced the code as per the changes from the source files/data or

Change Request Ticket.

 Involved in bug fixing to resolve it based on the priority of the ticket.

 Created shell scripts and Autosys jobs to automate some of the tedious tasks in order

to reduce the manual effort and effective utilization of time.

 Used Autosys to schedule the various workflows according to different regions and

time zones.

 Existing application’s code analysis and documentation.

 Performed administration tasks like creating folders, users, groups and granting them

permissions to different repositories (Dev/Test/Prod) using the Repository manager.

 Enhanced the workflows using tasks in the workflow manager as per the Change

Request.

 Prepared Release documents to provide it to the production support team if any

changes or bug fixes needs to take place in production

 Prepared Unit Test Cases for ETL Mappings/Workflows.

 Involved in CAB calls where we need to explain why the release is needed in

production and explaining the release documents.

 Involved in status meetings with the clients.

 Acted as a coordinate member between offshore and onsite team.

Data Warehousing, Informatica, ETL

7/2011 – 8/2012

 Involved in requirement analysis, application’s code analysis and debugging.

 Resolving the issues based on the priority of the ticket.

 Resolving the client related requests by communicating with them effectively and

resolving them in time.

 Participating in the releases and coordinating with the production support team during

the releases.

 Involved in debugging the complex code and documenting it.

 Analyzing the Unix shell scripts if any modification is needed.

 Performing the Unit testing for the changes or enhancements which are to be

implemented in Productions.

Data Warehousing, Informatica, ETL