Uttham

732-***-**** / acvn4d@r.postjobfree.com

SUMMARY:

Around 11+ years of experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter 9.1/8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets /Workflow Manager). Knowledge of Informatica tools Power Exchange, Power Analyser, Power Connect, Data Mart, OLAP, OLTP and Master Data Management.

Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.

Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications, COBOL Sources and Teradata.

Experience in integration of various data sources as Flat Files, Oracle, SQL Server, XML with parsing XSD and EDI files and Excel into staging area.

Designed and developed complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.

Expertise in Data Transformation and Data Exchange.

Involved in all phases and complete life cycle of the Datawarehouse/ETL project i.e. Logical and Physical Data modeling, Designing ETL strategies, Development, Testing, Validation of test ETL scripts, Implementation, Production Support

Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions

Having sound knowledge in OLAP & Multi-Dimensional Data Modeling. Designing star-schema / snowflake schemas, Data Marts, Data Mining, Data quality Analysis, Data Integration, Slowly Changing Dimensions (SCD) and Creating job flow diagram

MDM Developer with experience in implementing, development, maintenance and troubleshooting on Informatica MDM solutions, Metadata Management, data quality, data integration.

Good experience in Data Profiling and Data Validation based on the business and functional requirements

Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

3 plus years of experience in understanding the architecture and business process in Informatica MDM 9.1/9.5.1/9.7.1 and also responsible for the developing, enhancing and supporting the MDM and Informatica Data Director (IDD) platforms and related data integration applications.

Extensively worked on transformations, creation of Worklets, Mapplets, reusable transformations, Push down optimization, usage of parameter files, edit rules and validation of business rules

Experience in automating of the ETL processes for migration and patching Informatica objects

Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, Teradata, Sybase, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER.

Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files

Strong experience in the integrated reporting and risk solutions provide complete control over every step of the regulatory reporting process using AxiomSL

Strong experience in the Financial Services Analytical Applications using Oracle Financial Services Analytical Applications Infrastructure.

Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

TECHNICAL SKILLS

Operating Systems: MS Windows, UNIX

Languages: C, C++, JAVA, SQL, PL/SQL, XML

Databases: Oracle, SQL Server2000, Teradata13

ETL Tools: Informatica Power Center 6.1, 7.1.3, 8.1.1, BODS 4.0

OLAP Applications: Business Objects, MSOLAP, Metadata Reporter

Tools: SQL*PLUS, TOAD, PL/SQL Developer, MS Office

PROJECTS:

Client: Southwest Airlines – EDBI, TX Nov’2015 to Till date

Role: Senior ETL / Informatica Developer

The Lone Star Project is Southwest Airline's multi-year strategic reservation system program. The primary goal of this project is to move to a single reservation system that will serve all of Southwest Airline's strategic plans in a more cost-effective way. In addition, this Project will lay the groundwork to enable new revenue-generating capabilities for the future. This project is being implemented using agile methodologies.

Responsibilities:

Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier

Analyzing, designing and implementing complex SQL stored procedures, ETL processes and informatica mappings.

Implemented SCD2 type maps to capture new changes and to maintain the historic data

Providing technical assistance during production phase of project development

Defined and developed technical standards for data movement and transformation as well as review all designs to ensure those standards are met.

Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.

Designed and written the scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.

Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.

Worked on SQL, Oracle, DB2, Teradata databases.

Worked extensively on Unit Testing the ETL mappings and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.

Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica Power Center.

Participated in design workshops, providing technical insight and knowledge.

Environment: Informatica Power Center 9.0.1, Oracle 10G, Cognos BI 8.3, Flat files, PL/SQL, SQL*Plus, TOAD, UNIX.

Client: Unilever – ESRA Englewood Cliffs, NJ Jan 2014 to Oct 2015

Role: Senior ETL / Informatica Developer

ESRA (Enhanced Sales Reporting & Analytics) is a sales reporting capability project. The purpose of this project is to deliver part of the data available to allow each country to access data appropriate to their needs and creating their own reports. The ESRA project consist of designing, building and deploying the improved reporting and analytics tool to the MCO’s based on current and future reporting requirements.

Responsibilities:

Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets

Coordinated MDM program activities for the Member and Provider data domains.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier

Defined measurable metrics and the minimal required attributes for each domain or subject area to support a robust and successful deployment of a MDM platform.

Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer).

Analyzing, designing and implementing complex SQL stored procedures, ETL processes and informatica mappings.

Providing technical assistance during production phase of project development

Defined and developed technical standards for data movement and transformation as well as review all designs to ensure those standards are met.

Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.

Designed and written the scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.

Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.

Worked extensively on Unit Testing the ETL mappings and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.

Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica’s PowerCenter.

Participated in design workshops, providing technical insight and knowledge.

Updated the IDD and Hub design documents.

Environment: Informatica MDM 9.7.1, Oracle 10G, Cognos BI 8.3, Relational Junction,, DB2, Flat files, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripting.

Client: Ahold, Amsterdam Area, Netherlands Mar 2010 to Dec 2013

Role: Informatica/ ETL Developer

Sourcing MI is an application used by Ahold to gather data from each supplier and generate reports that will be used to find out best supplier for particular product

Responsibilities:

Worked with Informatica PowerMart client tools like Source Analyzer, Warehouse Designer, and Mapping.

Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.

Extracted data from Flat files loaded them into EDW.

Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.

Involved and Worked with DBA to build Dimension Tables and Fact Tables.

Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Designing, Implemented the Inbound & Outbound interfaces to send data to MDM System to the sources.

Extensively participated in functional and technical meetings for designing the architecture of ETL load process

Involved in designing the Data mart and entire data warehousing life cycle.

Mainly involved in developing Star Schema (Facts and dimensions based on future requirements).

Developed source to target mappings and scheduling Informatica sessions.

Environment: Informatica MDM Hub 9.5.1/9.7.1, Oracle 10G, WLM, UNIX AIX, DB2, Flat files, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripting, Autosys, Erwin 4.2.

Client: PNC Bank (Cleveland, OH) Nov 2008 to Sep 2009

Role: ETL Developer

The project involves the extraction of master data and transaction data from various systems. Based on this Risk Weight Asset is calculated and Minimum regulate is blocked

Responsibilities:

Involved in creating design document Informatica mappings based on business requirement.

Extracted data from Flat files loaded them into EDW.

Strong technical knowledge of OFSA Infrastructure, managing multiple OFSA environments, data model and multiple terabytes database in Profitability Management domain.

Managing multiple OFSA environments, Erwin Data Model, Upgrades and hardware sizing for multi terabytes release of Profitability Management analytics.

Transformed and imported large volumes of raw data from client systems into the Axiom database. This process included detailed data analysis, database planning and utilization of SQL processes to transform data into acceptable and usable formats.

Migrated data from Axiom in the Data Warehouse and Data Mart tables using Data Stage ETL and Linux Server

Developing Transformations, Mapplets using Informatica to Extract, Transform and Load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS)

Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement logics while coding a Mapping

Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.

Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor

Tested scripts by running workflows and assisted in debugging the failed sessions

Analyze functional requirements provided by Business Analysts for the code changes.

Writing UNIX scripts for unit testing the ETL Code

Execute the Test cases for the code changes.

Extensively participated in functional and technical meetings for designing the architecture of ETL load process

Environment: Informatica Power Center 9.0.1 Power Exchange, Teradata V13.0, SQL Server 2008, Oracle 11g/10g, SOA, TOAD, SSH, WLM, UNIX AIX, Windows XP.

Note: Please Contact/Email the requirement I will share Updated Resume.

Contact this candidate