SUMMARY

• Over 8 years of Information Technology experience in Data Warehousing and Business Intelligence
• Strong Experience in INFORMATICA, MDM, Teradata and Oracle.
• Extensively used ETL methodology for supporting data extraction, transformation and loading process in a corporate - wide ETL Solution using Informatica.
• Strong ETL Experience in Designing, Developing and Implementation of Data Warehouses & Data Marts with ETL solutions using Informatica Power Center 8.x/9.x.
• Participated in all levels of SDLC like requirements gathering, Preparing Technical Documentation, Development, Testing, Production Implementation and Maintenance.
• Experience in (Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer) in Informatica Power Centre 8.x/9.x.
• Experience in designing and developing complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer, SQL Transformation.
• Extensive experience in design and development of ETL processes from different heterogeneous source systems like Oracle, Flat files.
• Configuring Informatica Server and scheduled Workflows and sessions using Informatica Power Center.
• Experience in developing mappings involving Type1 SCD, Type2 SCD and Type3 SCD.
• Developed entire MDM flow like Loading to landing tables, creating Mappings for implementing cleansing and stage load, executing Match/Merge progress, validating Base object load
• Thoroughly proficient in SQL development in Oracle, Teradata.
• Knowledge on Data profiling and Data cleansing using Informatica tools.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Improved ETL performance by implementing Archival strategy, partitioning etc.
• Good knowledge of Data warehouse concepts and principles (Ralph Kimball / Inman), Star Schema, Snowflake, SCD, Surrogate keys.
• Expertise in designing and writing on-demand UNIX shell scripts.
• Hands on experience with Teradata utilities like bteq, fast export, fast load and multi load.
• Extensive experience in Production Support & Supporting Application as per SLA.
• Team player and self-starter and ability to work independently and as part of a team.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Experienced in Onsite Offshore model coordinating with development/support activities.

TECHNICAL SKILLS

ETL Tools: Informatica (Power Center 8.x/9.x),MDM, Abinitio (GDE 3.2)

Databases: Oracle 10g/11, Teradata

Job Scheduler: Cron Scheduler, Control-M,Autosys

Data modeling Tools: Erwin 4.0 and Microsoft Visio

Programming Languages: SQL, PL/SQL

Scripting Languages: UNIX/LINUX, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

DWH Dev lead

Responsibilities:

• Responsibility in this project involves Creation of Requirement, TSD, FDD and Traceability matrix
• Aanalyzing the incoming Source data, designing and performing independent unit testing.
• Responsibilities also include Development, preparation of Defect Analysis, Unit Test & Release Manual documents.
• Onsite -Offshore coordination, client interacting, bug-fix request, and implementation support

Confidential, Columbus, OH

Associate -ICDW Production support & Analyst

Responsibilities:

• Monitoring the Daily loads and Production Environment.
• Identifying the reoccurring issues and fixing code issues through ITSM
• Implemented the password parameterization for the Teradata ETLs in the Informatica with EPV
• Providing the second level support for the ICDW applications, job scheduling, change and incident support and handling user queries.
• Documenting all the failures, corresponding resolution steps and code fixes for future reference.
• Handling Informatica and Database version upgrades.
• Handling the P1 calls with the help of PAC team
• Handling loads during outages and maintenance activities

Confidential, Delaware

Associate Consultant

Responsibilities:

• Performing UT and doing peer reviews
• Monitoring the ETL flow and troubleshooting the issues
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required. performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Loaded data from Different Formats of Source files to Target tables.
• Helped Production Support team to solve the job failures in production and gave them the resolutions if it happens again.

Confidential, Phoenix Arizona

Software Engineer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used Informatica power centre for loading the data from sources involving flat files to load into target.
• Mainly involved in ETL developing to Extract, Transform and Load the data into Target.
• Creation of sessions for mapping and validate the session.
• Prepare the T100 Document and review the documents.
• Prepare the Test case documents and load to the QC.
• Identified the granularity level of the data required to be available for analysis.
• Reviewing the code and performing Unit test.
• Providing Application Support
• Participating in Design and Code reviews
• Providing Effort Estimation for the Mappings, Sessions, Workflows creation as part of development based on functional point analysis
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation.
• Masked data in tables in pre-prod environments to protect PII information.

Confidential, Phoenix Arizona

Analyst Programmer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used Informatica power centre for loading the data from sources involving flat files to load into target.
• Mainly involved in ETL developing to Extract, Transform and Load the data into Target.
• Creation of sessions for mapping and validate the session.
• Prepare the T100 Document and review the documents.
• Prepare the Test case documents and load to the QC.
• Involved in SIT&UAT Testing
• Reviewing the code and performing Unit test.
• Providing Application Support
• Participating in Design and Code reviews
• Providing Effort Estimation for the Mappings, Sessions, Workflows creation as part of development based on functional point analysis

Confidential

Informatica Developer

Responsibilities:

• Understanding of the Analysis and design documents.
• Prepared Technical Design Document
• Involved in Development of Informatica Mappings using different transformations.
• Used Informatica Workflow manager to create sessions, Workflows to run with the logic embedded in the mappings.
• Developed reusable mapplets using maplet designer.
• Involved in Unit Testing and prepare test cases
• Responsible for the maintenance (Backup, Restore).
• Involved in thePerformance Tuningof Mappings and Sessions.
• Involved in automating the Informatica process by using Unix Shell Script.
• Used InformaticaDebuggerto validate and test business logic implemented in the mappings and fix the bugs.