SUMMARY

• 7 Years of IT experience in analysis, design, development and implementation of Data Warehouse/Data Mart applications
• Over 7 years of IT experiences in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica PowerCenter/Power - Exchange from versions 8.1 to 10.1.0, Energy Utilities and Insurance Domains with different Methodologies in LinuxServers.
• Experienced in Migration of codes from Repository to Repository, wrote up Technical/Functional Mapping Specification Documents for each Mapping along with unit testing for futuredevelopment.
• 6.8+ Years of strong working experience on using ETL tools Informatica PowerCenter, Oracle Database,Power-Exchange.
• Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows for load frequencies. Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor thesystem.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications
• Skilled to interact with business users. Pioneered in different load strategies from heterogeneous sources to target. Successfully implemented SCD Type1/Type2load, Capture Data Changes to maintain the Datahistory.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC)involving Systems Analysis, Design, Development, Implementation andTesting.
• Experienced to identify the Bottlenecks of data load and Tuned the Bottlenecks for betterperformance.
• Seasoned in providing Technical solutions and Estimates for newprojects.
• Experienced with medium to large-scale enterprise software projects and well versed with the various phases of the software development life cycle and Application Value Management Lifecycle
• Team Player, excellent communication & interpersonal skills, vivid analytical ability to solve theproblems.

TECHNICAL SKILLS

Operating Systems: Windows 2012, 2008, 2003, 2000, XP, Linux,Unix.

Databases: Oracle, Informix,DB2

ETL: Informatica Power Center 8.x,9.x,10.1, IBM Datastage8.1,8.7,SPSS

Database Tools: Informix Server Studio, SQLDeveloper

Other Tools: , JIRA,ALM,CAWAScheduler,Automic

Web Technologies: HTML,XML

Version Control: Git,SVN,Clearcase

PROFESSIONAL EXPERIENCE

Confidential

Informatica Consultant

Responsibilities:

• Working as the ETL Consultant leading a team of 10 atoffshore
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataWarehouse.
• Data from legacy systems is first loaded into the Staging database table for performing bulk load whereas for change data capture we use Informatica power exchange to get the source tables into Informatica Powercenter then Informatica Maps are executed to load data into the Oracledatabase.
• Built the Informatica workflows to load table as part of dataload.
• Responsible for managing scope, planning, tracking, change control, aspects ofthe project for 22+ ETL interfaces (Flat File,Relational)
• Designed ETL processes and develop source-to-target data mappings,integration workflows and loadprocesses.
• Implemented Type I and Type II slowly changing Dimension to maintain all historical information in DimensionTables.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflowmanager.
• Extracted data from Heterogeneous source systems like Oracle, SQL Server andFlat files with fixed width anddelimited.
• Work with different Functional users for Understanding the business requirements and building technical design solution forit.
• Creating User Stories and Grooming Stories with Technicaldetails.
• Creation of Informatica mappings, sessions,workflows.
• Developed scripts to manage various operations like Flat File Rename, File archival, Notifications,SFTP.
• Worked on Agile model of work for continuousdelivery
• Analysis of the business requirements and preparing functional specification and technicaldocuments.
• Preparing project estimates based on requirements and presenting them to the client and engaging in discussions and negotiations for thesame.
• Translate customer requirements into functional and technical requirements and design documents, establish specificsolutions.
• Developed reusable mapplets and transformations for reusable business calculations.
• Used exception handling logic in all mappings to handle the null values or rejected rows.
• Monitored the workflow transformations in Informatica work flowmonitor.

Environment: s and Tools: Informatica Power Center 10.1/9.6/9.1 ,PowerExchangeOracle 12c, UNIX,SQL,JIRA,ALM,CAWA Scheduler,Automic

Confidential

ETL Developer and CDC

Responsibilities:

• Requirement gathering andanalysis
• Communicated with business customers to discuss the issues andrequirements.
• Extensive experience in Extraction, Transformation, Loading (ETL) datafrom various sources into various targets using Informatica8.1
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems
• Worked on tools Informatica PowerCenter8.1, IBM Change Data Capture 10.2,Cognos 10,IBM DB2,IBM Deployment Manager for CADS and SPSS,Unix,Aix,Portal,Service Now andHPSM
• Used Basic and Advanced Transformations inInformatica.
• Used relational and XML files as sources andtargets.
• Worked on Performance tuning of sources, targets, mappings usingInformatica
• Extensive hands on UNIX server and UNIX ShellCommands
• Well versed with different DB2 database commands and tools like IBMDB2 client,Controlcenter
• Performed multipleAutomations.

Environment: s and Tools: Informatica PowerCenter 8.1, DB2, Oracle,Unix

Confidential

ETL Informatica Developer/Data Support Specialist

Responsibilities:

• Production Support has been done to resolve the ongoing issues and troubleshoot the problems
• Hands on experience on Administrator Tasks like Informatica Services Start/Stop from Unix server,Assigning Roles and creating Groups and Folders in Administrator Console,Repository Backup from Unix and Admin Console,Load Balance Testing,Export/Import from RepositoryManager.
• Used basic and advanced Transformations like Sorter,Router, Filter, Joiner,Sequence generator,Aggregator,Expression and lookup inmappings.
• Used flat files, relational and XML files as sources andtargets.
• Provide 24x7 application maintenance and support to Oncor’s business critical application, quick resolution to high priority incidents, enhancements of applications and operating environments to align them with latest Business requirements, application monitoring andcontrol
• Involved in unit testing, debugging and fixing ofdefects.
• Extensive hands on UNIX server and UNIX ShellCommands.
• Well versed with different SQL Development Tool like Microsoft SQLDeveloper
• Responsible for automation of multiple manual tasks by writing UNIXscripts.
• Proficient with Configuration Management tool Clearteam Explorer 8.0 and Clearcase for maintaining Sourcecode.

Environment: s and Tools: Informatica 8.1,Informatica 9.1,Oracle 10g,SQL Developer,Clear Team explorer 8.0,CAWA