SUMMARY:

• Over 7 years of ETL Experience focusing on Data Migration, Data Integration, ETL Process and Implementation of applications for Insurance, Banking and Financial, Healthcare domains.
• Expertise in ETL Design, requirements gathering, Data Modeling, Effort Estimation, Development, System testing, Implementation and production support.
• 7 years of Real Data Integration experience in application development with huge data volumes and large enterprise data warehouse systems.
• Experience in Agile methodology working on ETL process and strong Knowledge on Data Warehousing trends - Ralph Kimball, Bill Inman methodologies, Star Schema, Snowflake schema, ODS, EDW, DM, OLAP, Dimensions and Facts.
• Worked extensively on Informatica Power Center to Extract, Transform and Load (ETL) data from various sources into several downstream systems.
• Proficient in the Integration of heterogeneous data sources like Oracle, SQL Server, Netezza, Teradata, and Flat Files.
• Implemented Slowly Changing Dimensions Type-1, Type-2, Type-3 approach for loading the target tables
• Demonstrated ability prioritizing and managing development and implementation of enhancements /changes to multiple applications.
• Perform troubleshooting on ETLs and related components, identify application bottlenecks and opportunities to optimize performance.
• Develop Data Quality checks such as Reconciliation, Balancing, Duplicates, Orphan records, Constraint checks and Aggregate calculations.
• Develop complex applications that combine data from various sources, tailored to specific business needs.
• Develop automated processes to control data access, transformation, and movement. Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling.
• Hands-on experience in different phases of Software Development Life Cycle (SDLC) like Requirements gathering, Data mapping and Build.
• Creating HLD, LLD,UTP for all code deliverables and get signoff from SME’s.
• Experience in using Automation Scheduling tools like ESP, AutoSys.

TECHNICAL SKILLS:

Database Systems: Oracle 12c/11g/10g, SQL Server 2008/2005, Teradata 12, Netezza

Languages: SQL, COBOL, JCL, VBA, Easytrieve

Software: InformaticaPowerCenter9.x,GuidewirePolicyCenter,ToadforOracle Xpert,Tableau, Tortoise SVN, Teradata SQL Assistant 15, OracleSQL Developer, HP Quality Center

Office Applications: MS Office Professional Plus 2013/2010(Word, Excel, PowerPoint)

Data Modeling Tools: Windows, UNIX

Scheduling Tools: ESP

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Responsibilities:

• Involved in creating the extract control documents (ECD)used to describe the detailed design of the TEDS data conversion.
• Perform data profiling and data quality analysis.
• Create ETL specifications. For example, data mapping between source and target systems, business rule transformations, data models and file layouts.
• Develop, tune, and maintain ETL objects and scripts using Informatica Power center.
• Design and tune the ETL code to move data from multiple data sources (database and files) environments into the target databases.
• Ensures transformed/converted data maintains integrity, accuracy and meets performance expectations.
• Experience of developing Informatica ETL programs on Linux and with Oracle databases as target.

ETL/Informatica Developer/ Tech Lead

Responsibilities:

• Understanding the business requirements and analyzing the producer data (xml format)
• Extracting the data and Staging the extracted producers into source staging tables
• Transforming the extracted producers into the format expected by PolicyCenter
• Extensively worked with Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• Understanding the PolicyCenter Data Model.
• Loading the Producers into the PolicyCenter Database.
• Scheduling the ETL jobs daily, weekly and monthly based on the business requirement.

Environment: : Guidewire PolicyCenter, Informatica Power Center 9.6/9.5, Oracle SQL Developer, MS Excel, RFHUtil, Unix Shell and Delimited Flat files with XML data

Responsibilities:

• Understanding Personal Umbrella, Auto and Property PolicyCenter schema models to load PolicyCenter Data to Oracle Integration Data Store.
• Extracting data from Oracle source, moving into Staging area and then loading to target Oracle/Teradata DBs using Informatica.
• Developed Informatica mappings, Workflows, re-usable components, procedures for getting the data from the PolicyCenter Source systems to build Document Production Integration file.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent batches and sessions.
• Worked with scripting pmcmd to interact with Informatica server from command mode.
• Built Batch Framework in Informatica to trace workflow run for each interface.
• Designed Common Error Handling Framework for all Interfaces.
• Scheduled the ETL jobs daily, weekly and monthly based on the business requirement using ESP.
• Created different Events in ESP scheduler, trigger Workflows from ESP using PERL Scripts.
• Automated the execution of Informatica work using Unix Shell Scripts and pmcmd command.
• Define Code Management Process and approach to set up code merge process for ETL Development, System testing and Production phase of the project.
• Involved in the support of user acceptance testing (UAT), the error checking and testing of the ETL procedures and programs in Informatica.
• Developed mappings using different Informatica transformations to build different flat files for Downstream.
• Worked in Agile Scrum environment.
• Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.

Environment: : Guidewire PolicyCenter, Informatica Power Center 9.x, Oracle SQL Developer, MS Excel, RFHUtil, Unix Shell, Teradata and Delimited Flat files

ETL/Informatica Developer

Responsibilities:

• Analyzing the legacy systems and the business requirements.
• Extracting the policies from the legacy sources.
• Staging the extracted polices into the temporary source and target staging tables
• Profiling and Cleansing
• Reconciliation is done on each stage - Teradata, source staging and PC staging
• Transforming the extracted polices into the format expected by PolicyCenter
• Understanding the PolicyCenter Data Model.
• Loading the Polices into the PolicyCenter Database
• Scheduling the ETL jobs daily, weekly and monthly based on the business requirement.

Environment: : Informatica Power Center 9.x, Guidewire PolicyCenter, RFHUtil, Tortoise SVN, Putty, Cobol(Flat files), UNIX Shell Script, Oracle, Teradata.

ETL/Informatica Developer/Program Analyst

Responsibilities:

• Analyze and evaluate present business procedures.
• Understanding and translating the business requirements for Property/Auto/Personal Umbrella line of business into Technical specifications.
• Extraction, loading and Transformation
• Profiling and Cleansing
• Review of the program specification documents, call structures, Flow maps, Data maps and the extracted rule sets.

Environment: : Informatica Power Center 9.x, Cobol, RFHUtil, Tortoise SVN. Putty, UNIX Shell Script, Oracle, Teradata