With an experience of 7 years 2 months in Datawarehousing, Confidential attended requirement sessions and performed design, development and production activities across various locations and clients.
ETL Development Tool: Ascential Datastage V7.5.1, IBM Infosphere Datastage V8.5Informatica 8.1.1, Informatica 9.1
Reporting Tool: Crystal reports 2008, Cognos 10.1
Scripting: UNIX/Shell script, Perl
Programming Language: C: program
Job Scheduling: Autosys, Mainframe Job Scheduling
Service Ticket Tracker: HP Service Center, Siebel Call Center 8.1
Database: DB2, Vertica 3.5, Oracle
SME/Onshore Tech Lead
Confidential, Morristown, New Jersey
Technology: IBM Infosphere Datastage V7.5, UNIX/Shellscript, Siebel Call Center 8.1, Informatica 8.1, Cognos 10.1
- Handled Production Implementation for various Major, Standard and Off - cycle releases.
- Created Value-ads for production support.
- Handle Weekly Production Load, validations and communication to Functional and Business Users.
- Support Functional leads on day-today production service requests.
- Host Daily calls with Offshore team on production service requests and follow-up on them to completion.
- Create Process Documentations to support New Joiners.
Onsite Tech Lead
Confidential, Blue Bell, Pennsylvania
Technology: Ascential Datastage 7.5.1, IBM Infosphere Datastage V8.5, Oracle, DB2, Shell script, Mainframe
- As application SME, gather Business requirements and communicate them to Offshore.
- Host daily meetings with Offshore team to communicate critical requirement updates and monitoring the work progress to meet Client timelines.
- Validate the ETL Jobs and other design deliverables to meet Business needs and Coding standards with maximum accuracy in Quality.
- Support Onshore Testers and Business Users when needed.
- Handle Production Implementation for various Major, Minor, Off-cycle and Emergency releases.
- Provide support on Day today batch Production runs during US Business hours.
Technical Lead Developer
Technology: Ascential Datastage 7.5.1, Shell script, DB2, Perl
- Prepare Design and Test deliverables to meet Business Requirements.
- Develop Datastage jobs and involving complex logics
- Support and Validate the deliverables of teammates
- Train new joiner with Application and Tool knowledge
- Support Onshore during Production Implementation and post production changes, if any.
Technology: Informatica 8.1.1, Facets, SQL
- Prepare Application Design and Detailed design document for Business Requirements.
- Develop and Unit testing of Informatica Mappings, Mapplets and Workflows.
- Support Onshore during Production Installation and Business Checkout
Technology: Datastage V7.5.1, Oracle, Crystal reports 2011, Perl
- Preparation of technical design document for Business Requirements.
- Develop and Unit testing of Datastage parallel jobs.
- Preparation Unit and Integration Test deliverables.
Technology: Datastage 7.5.1, C Programming, Shell script
- Coded and compiled C-programs transforming Java script logic to C program.
- Programmed Shell script to generate Statistical and Operation reports.
- Prepared function design specification documents
- Developed Datastage parallel jobs and performed reconciliation on Datastage Server and Parallel job outputs