SUMMARY:

• 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Communication
• 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.
• Strong Data Warehousing ETL experience of using Informatica 10.x/9.x PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
• Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2012.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger) Connect as ETL tool on Oracle and SQL Server Databases.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g, MS SQL Server and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Tivoli.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills and experience in working with senior level managers, business owners and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.x/9.x

Database: Oracle 11g/10g, MS SQL Server

Database Tools: TOAD, SQL Developer, SQL server 2012

PL/SQL, SQL, T: SQL

Scheduling Tools: Tivoli

Erwin 9.5: 9.6

OS: Windows, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Informatica Consultant

Roles & Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (Oracle and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• This role carries primary responsibility for problem determination and resolution for each application system database server and application server.
• Constantly interacted with business users to discuss requirements.

Tools: &Technology Used Informatica Power Center 10.1, Oracle, SQL, PL/SQL, UNIX Shell Scripting, MS SQL Server, Erwin 9.5,9.6

Confidential, Dublin, OH

Informatica Developer

Roles & Responsibilities:

• Worked as a Data Quality offshore team lead and developer.
• Created Informatica mappings to capture volume and data analysis to implement data quality across source and destination systems.
• Regular data analysis for data quality failures, perform analysis along with the business contacts to identify the root cause and partner with technical / business experts to remediate the issue.
• Write queries to cross verify business rules validation and create workflows to send data issue alerts to respective team's BA.
• Daily Status call with client to report data issues and gathering requirement for new loops to implement data quality across all source and destination systems.
• Maintain and effectively communicate data design using ERWIN 9.6 to other members of the team to ensure proper implementation and utilization of the data structures; with continuous support development and maintenance.
• Analysis of the specifications provided by the clients.
• Design, Data extraction, transformation and loading.
• Testing, validation and implementation of delivered components.
• Provide support for System testing and Integration testing.
• Responsible for overseeing the Quality procedures related to the project.
• Design and improve process to reduce the ETL window period. Tune ETL code & Queries for better performance.

Tools: &Technology Used Informatica Power Center 9.6, Oracle, MS SQL Server, Cognos, Erwin 9.5.

Confidential, Dallas, TX

Informatica Developer

Roles & Responsibilities:

• Created Technical System Design Document for data flow process, Test plan, Test cases and review with Architects & Business analysts.
• Created Mappings using Transformations like Expression, Filter, Sorter, Union, Joiner, Aggregator, Connected & unconnected lookup, Filter, Router, etc.
• Created reusable transformations and Mapplets.
• Analyzed existing mappings and transformation for business logics and changed them as per the requests.
• Debugged IDQ mappings and enhanced as per the requirement using Informatica Developer.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to QA/UAT environment.
• Created Teradata objects tables, views, join indexes and stored procedures and used it in the mappings.
• Accepted work for team members as well and explained the requirements to complete build. Assisted them with the testing and PROD release activities.
• Tuned ETL process for performance improvement. Also used pushdown optimization.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it is implemented into production.
• Log test cases into quality center 9.2 and keep track of issues and resolve it on time.

Technical Environment: Informatica Power Center 9.1, IDQ, UNIX, PL/SQL, Visio, Shell Scripting, Quality Center, Tivoli.