PROFESSIONAL SUMMARY:

• Over 7 + years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing with business knowledge of Healthcare, Financial, Insurance domains.
• Good working experience in SDLC (Software Development Life Cycle) methodologies like waterfall, Agile.
• Experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.x/8.6, Power Exchange and Informatic Data Transformation(B2B), Informatica MDM, IDQ
• Experience in Installation and Configuration of Informatica Client and Repository.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL
• Extensively worked Different Database Oracle, SQLServer, SYBASE
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Experience in Interacting with Business Users to gather Business Requirement Specifications Document and Prepare System Requirement Specifications document.
• Extensively worked on Data extraction, transformation, loading with Oracle, SQL Server 2012, Sybase using Informatica.
• Having hands on Experience in B2B DataTranformtion for converting EDI (X12) to XML
• Having hands on Experience in MDM Tool IBM Initiate inspector
• Having good Experience on Scheduler Tool Dollar universe, Control - M, Tidal
• Experienced with Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, flat files, CSV files, EDI, XSD and XML files and loaded into target warehouse by using various transformations in Informatica.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the Session logs.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions and experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimensions.
• Extensive experience in onshore/offshore work model, being on both fronts.
• Having knowledge on Informatica IDQ
• Having knowledge on Big Data.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter PowerExchange, SSIS

Operating Systems: UNIX, Linux, Windows

Databases: Teradata V2R6/V2R5, Oracle 10g/9i/8i, DB2, SQL Server, Netezza MS Access

Database Tools: TOAD, SQL Navigator, and SQL Developer

Load Utilities: BTEQ, FastLoad, FastExport, MLoad, TPump, SQL Loader

Programming Languages: C, C++, HTML, TSQL, SQL, PL/ SQL

Scripting Languages: UNIX Shell Scripting

Test Management Tools: HP Quality Center 9.x, Test Director, Gemini, HP ALM

Version Control: Starteam, BitBucket, Tortoise SVN, Informatica Versioning, Serena ChangeMan Dimensions Desktop Client 3.1.3.3

Scheduling Tools: Active Batch, UC4, Control M

Change Management: Service Now, ITSM, JIRA, and PEREGRINE

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Extensively Used Informatica Designer as an ETL tool to extract data from various source systems to Target system.
• Extracted data from multiple operational sources for loading into staging area, Data warehouse using SCD's (Type 1 and Type 2) loads.
• Created ETL Mappings, sessions and workflows using Informatica Power Center to move Data from multiple sources like XML, DB2, SQL Server, and Oracle into a Enterprise Data warehouse Teradata.
• Used direct and indirect flat files (delimited and fix width) as a source of data.
• Used Normalizer transformation to handle COBOL file source from Mainframe.
• Used different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner (all type of joiner), Update Strategy, Expressions and Aggregator transformations.
• Implemented various loads like daily loads, weekly loads, and quarterly loads and on demand load.
• Implemented Incremental loading strategy and concepts of ChangeData Capture (CDC)
• Involved in Database & Informatica Upgrade testing.
• Performed Tuning of Informatica objects to eliminate performance issues.
• Experienced in using different Teradata Utilities - BTEQ, M-Load and F-Load.
• Wrote complex SQL and TSQL Queries and Store Procedures.
• Created Job Stream and added job definitions in Tivoli Workload Scheduler (TWS) and executed the jobs with appropriate parameters to execute UNIX Shell scripts contains pmcmd command to run workflows.
• Executed UNIX Shell script to archive and clean data to create space in staging area once data loaded successfully into target.
• Created new UNIX Shell script, edited the existing script and transferred from Development server to Testing server to run jobs in testing server.
• Worked with Reporting team, which utilizes Business object tools for objects, to address their needs from ETL point of view.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 10g/11g, DB2, Teradata, Mainframe, Flat Files, SQL Assistant, TSQL, Toad, Erwin, Business Object 6.0, Putty, Microsoft Visio, Tivoli workload scheduler

Confidential

Sr.ETL Informatica Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL)
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer) ..
• Collection of data source information from all the legacy systems and existing data stores.
• Worked on large volumes of Mainframe data extraction.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like Unconnected /Connected Lookup, Data Masking, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Responsible in the development of Informatica mappings and also tuned for better performance.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Worked with Reporting team which utilizes Business Object tools for objects and to address their need from ETL point of view.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC)
• Utilized Mload, Fast Load utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW)
• Used PMCMD commands of Informatica in UNIX scripts to schedule workflows and jobs.

Environment: Informatica Power Center 9.1.1, IDQ 9.0.1, Teradata, Oracle 10g/11g, DB2, Toad, Erwin, Control M, Business Object 6.0, UNIX, Windows.

Confidential

Sr.ETL Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created the Source and Target XSD based on requirements.
• Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML, Oracle, SqlServer.
• Created ETL mappings and mapplets for various layer of data loads like Staging, DWH, DataMart.
• Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, RDT, UTC & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
• Created the XML Files for SIT and Tested in SIT Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards.
• Monitoring ETL loads using Control-M
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Created and defined DDL’s for the tables at staging area.
• Used code debugging at mapping level and did enhancements.
• Created label, Queries and Deployment groups for Migration to QA.
• Created Turns for Code migration to QA.
• Maintained the Defect Tracking and fixed the Defects.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Setting up and coordinating meeting with Offshore and business users.
• Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.
• Provide end to end Knowledge Transfer to Offshore team.

Environment: Informatica Power Center 9.5, Oracle 11g, Sql Server, UNIX (AIX), Windows XP,TOAD, Unix Shell script, Business objects. Flat files, XSD, XML, Informatica MDM

Confidential

Sr.ETL Informatica Developer

Responsibilities:

• Interaction with client for status updates on tasks and requirements gathering for new enhancements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created the Source and Target XSD based on requirements.
• Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML.
• Reviewed the mappings, sessions and workflows for ETL standards.
• Identify the bugs in existing mapping by analyzing the data flow.
• Responsible for writing unit test cases and performing unit testing.
• Created the XML Files for SIT and Tested in SIT Environment.
• Created the UProcs, Session, Task in $Universe Scheduler Tool.
• Scheduled the Informatica jobs by using $Universe in DEV and QA.
• Migration between Development, Test and Production Repositories
• Maintained the Defect Tracking and fixed the Defects.
• Monitored the workflows.

Environment: Informatica power Center 9.1,Flat files, XML, UNIX, Version One, Unix Shell Script, Windows XP, IBM Initiate inspector

Confidential

ETL Informatica Developer

Responsibilities:

• Interacting with the onsite coordinators for getting business requirements on daily basis
• Preparing Mapping spec based on Implementation Guide and Companion Guide
• Used B2B Informatica DT for converting EDI x12 files to XML files.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like EDI834, XSD, XML, Oracle loaded into Transactional Database
• Used Unstructured Data Transformation in PWC to call B2B and generate EDI, XML files
• Understanding existing Unix scripts and modified based on business requirements
• Executing the Workflows and test the jobs.
• Reviewing the mappings.
• Identify the bugs in existing mapping by analyzing the data flow.
• Defect tracking.
• Responsible for unit test and assisted QA team.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
• Preparing Minutes of Meeting with Client.

Environment: Informatica power Center 9.1, EDI, XML,Flat files, SQL, UNIX AIX, Informatica Data Transformation(B2B), Shell Script, FileZilla, Rational Team Connecter.

Confidential

ETL Informatica Developer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used informatica power center for loading the data from sources involving flat files to target as relational table.
• Mainly involved in ETL developing to Extract, Transform and Load the data into Target.
• Creation of sessions for mapping and validate the session.
• Created mappings in Data quality and imported in power center as a mapplet for Data quality.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• Preparing Minutes of Meeting with Client.
• Prepare the Design Document and review the documents.
• Review the Test case documents and load to the QC

Environment: Informatica Power center 8.6, Informatica Data Quality, MQ series, Mainframe, Share point, UNIX, DB2