EXPERIENCE SUMMARY:

• 12 years of IT experience in Analysis, design and development of software applications with all the 12 years of experience in data warehousing with Informatica as a data integration tool Oracle, Netezza, Teradata, DB2UDB, MS SQL databases in a dimensional model data warehouse environment with experience in various capacities and designations from Programmer, Liaison to Project Lead/ Tech Lead.
• Industry experience includes Banking, Credit Cards, Financial Services, Health Care, Retail, Travel and Hospitality.
• Full life cycle of Software Development (SDLC) experience including Define, Analysis and Review of Software and Business Requirement Specifications, Design, Development and Testing, to solidify client requirements in conjunction with Software Developers
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimension phenomenon, surrogate key assignment.
• Strong Experience and strong Knowledge of FACETS Product and Enrollment Process through Health Insurance Exchange for ACA and contract generations and interaction with Health Exchanges.
• Experienced in integration and migration of various data from sources like Oracle, SQL Server, Sybase, DB2, Mainframe system and Complex Flat files into the staging area.
• Provide documentation such as technical specifications, functional requirements, Run Books or Job Docs and test scenarios.
• Strong analytical, problem solving skills.
• Self - motivated, can multitask, team player, great leadership and communication skills.
• Extensively worked on Informatica Teradata database combination using external load tools like Teradata Multiload, T pump etc.
• Worked with SFDC applications and integration of the salesforce data with the in premise/ in house data through sales force.com APIs and also have exposure to cloud instance of Informatica..
• Worked on the projects where n tier/ multi technology tier system like ETL, Tibco, Pega, Java as data integration specialist / ETL Lead.
• Involved in doing Informatica administrative work, like creating and deploying the code in deployment groups and migrating code across the environments and managing repositories etc
• Wrote shell scripts to run the informatica workflows from UNIX OS.
• Worked conversion of PL/SQL scripts to Informatica workflows.
• Worked in conversion of Ab-initio graphs to Informatica workflows.
• Closely worked with Informatica Administrators during upgrades, Informatica 7.1 to 8.1.3, 8.1.3 to 8.6 and 8x and 7x to 9.0.1 by helping in testing etc.
• Expert in doing Data Analysis by running SQL Queries to validate databases do gap Analysis.
• Strong experience in interacting with business users, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and Analyst tools.
• Experience in the creation of Project Plan, Design Document, Test Plan and Test Cases from the Requirements document. Documentation of the Test Plans, Test Cases, Test Scripts, Test Procedures based on the Design Document and User Requirement Document for the Unit, Integration, Regression, Functional, Performance, and User Acceptance Testing (UAT).
• Worked on onsite-offshore Model.

TECHNICAL SKILLS:

Software Products: Informatica PowerCenter 9.6, 9.5.1, 9.0.1, 8.6.1, 8.1.1, 7.1.3 and 6.3,, 6.1SAS 9.1.3

Job Management: Tidal Enterprise Scheduler, Maestro, Autosys and Control M

Databases: Netezza 5.0/ 6.0 Teradata V2R5 and V2R6.1, Oracle 11g, DB2 UDB (DB2/AIX64 9.1.7), SQL server and SalesForce.com API.

Tools: Teradata SQL Assistant, Toad, QMF with windows, WINSql, PL/SQL developer.

Version Control Tool: CVS, PVCS, Serena Dimensions and SCCS

Programming Languages: SQL, UNIX Shell Scripting.

Methodology: ETL Velocity methodology and ETL Factory methodology.

Project Management Tool: Microsoft Project (MPP)

Documentation Tools: Nexus

PROFESSIONAL EXPERIENCE:

Confidential

Data Integration Specialist and ETL Developer Lead

Responsibilities:

• Requirement Analysis and Gap Analysis
• Data Integration Requirements with Business Users
• Data Modelling and Design.
• Task Planning and Delegation
• Build and Development Support and code reviews.
• Support Quality Assurance and Control Phases
• Mentoring Team members
• Act as tier 1 adhoc support for Business teams
• Work with Onsite and Offshore Model

Informatica Lead (COE)/ Coordinator

Responsibilities:

• Task Planning and Delegation
• Design, Build and Development Support and code reviews.
• Support Quality Assurance and Control Phases
• Change Control and Planning Change Requests.
• Improve the support processes and documentations.
• Work with Onsite and Offshore Model

Technical lead/Onsite Coordinator

Responsibilities:

• Technical Lead and Liaison to Onshore and Offshore teams for multiple projects under the Information Warehouse.
• Build and Development Support and code reviews.
• Support Quality Assurance and Control Phases
• Change Control and Planning Change Requests.
• Work on Performance Tuning.
• Work with Onsite and Offshore Model
• Work on Job scheduling and Job Support Documents

Development Team lead (Offshore)

Responsibilities:

• Lead the design and development effort from the offshore, as technical lead and development team lead.
• Designed all the process in the new ETL approach.
• Defining responsibilities and reviewing deliverables.
• High Level Design and Low level design according to requirements and its review
• Project Planning and Task Allocation to Team
• Developing Informatica mappings, BTEQ scripts and Multi-Load scripts.
• Developing pl/sql scripts.
• Unit Testing
• Scheduling the mappings in Maestro (TWS Scheduling tool).
• Preparing Job Documents for the Production Support team
• Code walkthrough and Review of Offshore Deliverables
• Concur with Quality procedures

Confidential

ETL Developer

Responsibilities:

• Preparation of Low Level Design.
• Developing Informatica Mappings, BTEQ scripts and Multi Load Scripts.
• Writing Test cases and Performing Unit Testing.
• Test cases for System Integration Testing and User Acceptance Testing.
• Involved in End to End Testing.
• Ensured all the code and deliverables are adherent to quality procedure.
• Conducted final inspection and audit of code.
• Involved in Migration Informatica Power Center from version 6.1.1 to 7.1.1