SUMMARY

• 7+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/ Informatica Power Center.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Expertise in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Worked in various Heterogeneous Source Systems like SQL server, Oracle, DB2, MS SQL Server, Flat files and Legacy systems.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
• Experience in data modeling using Erwin,Star SchemaModeling, andSnowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ.
• Created scorecards to periodically review data quality and to measure data quality progress.
• Experience in scheduling and executing jobs through scheduler such as Control M.
• Involved in understanding Data model and assisted in fine tuning the physical model and best understanding the hierarchies and dependency of the Warehouse loads
• Extensively worked with end users on the UAT of the Data warehouses and Data Marts
• Experience in working with Oracle using SQL, PL/SQL.
• Responsible for Team Delivery and Participated in Design Reviews.
• Developing Informatica scripts to load flat files into Teradata for transformations.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FLoad and MLoad sessions.
• Experience with Teradata as the target for the DataMart, worked with BTEQ, FLoad and MLoad.
• Guided team members to deliver their task.
• Excellent interpersonal and communication skills, self-learner.

TECHNICAL SKILLS

Databases: SQL Server, SAP HANA, Teradata, DB2, Oracle 11g/10g, MS SQL Server 7.0

ETL Tools: Informatica Power Center 9x/8x/7x Informatica Designer, Workflow Manager, Work flow Monitor, DataMart, Mapplet, Transformations, IDQ

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual, Physical and Logical Data Modeling, ER Models, OLAP, OLTP concepts

Languages: PL/SQL, HTML, DHTML, XML

Tools: Toad 9.6.1.1,SQL Developer, SQL, PL/SQL

Operating Systems: Windows XP / Vista/ 7, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Rancho Cordova, CA

Sr. Informatica Consultant

Responsibilities:

• Evaluating business requirements, Technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Extracted data from Oracle / Teradata database transformed and loaded into Teradata DB according to the business specifications.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Designed the ETL processes to load data from multiple sources into the staging area.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Involved in planning, designing, developing mappings/mapplets and reusable transformations to implement the new requirements.
• Involved in creating Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, and Dimensional Data Modeling.
• Coordinated and worked with cross-functional business teams and testing teams to plan and execute the releases as per the timelines.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without any operator intervention.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Worked with the QA team to resolve and fix the defects.

Environment: Informatica Power Center 9.6.1, Oracle, Teradata, SQL Server 2008, IDQ, IBM Rational Clear Case, IBM Rational Clear Quest, XML.

Confidential, Detroit, MI

Sr. Informatica Consultant

Responsibilities:

• Evaluating business requirements, Technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy, sorter, Normalizer.
• Configuring Repository, Session variables to generate dynamic reports.
• Participated in Data modeling meetings, helped to identify the relationship between tables according to the requirements.
• Involved in planning, designing, developing mappings/mapplets and reusable transformations to implement the new requirements.
• Involved in creating Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, and Dimensional Data Modeling.
• Involved in implementing the Land Process of loading the customer and other cross reference tables data into Informatica MDM from various source systems.
• Coordinated and worked with cross-functional business teams and testing teams to plan and execute the releases as per the timelines.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without any operator intervention.

Environment: Informatica PowerCenter 9.6, MDM, SAP HANA, SQL Server 2008, UNIX, Winscp, Putty, Erwin 7.2, SQL, PL/SQL.

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developed several mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and applets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g, Teradata, SQL, PL/SQL, UNIX, Flat files, XML, MS Access, Web services, DB2, SQL Server 2008, Business Objects.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the work flows using workflow manager
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Tuned performance of informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tuned performance of existing SQL statements and PL/SQL code.
• Developed procedures, functions, packages and triggers in PL/SQL
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/9i, SQL, PL/SQL, SQL * Loader, UNIX Shell Scripting, Win 2000/NT.

Confidential

Informatica Consultant

Responsibilities:

• Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 7.1. Re-engineered on existing Mappings to support new/changing business requirements.
• Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Involved in writing UNIX Shell scripts (Pre/Post Sessions commands) for the Sessions & wrote Shell scripts to kickoff workflows, unscheduled workflows, get status of workflows. Tuned SQL Statements, Mappings, Sources, Targets, Transformations, Sessions, Database, Network for the bottlenecks, used Informatica parallelism options to speed up data loading to target.
• Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions (SCD).
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy for Designing and optimizing the Mapping.
• Created various tasks like Pre/Post Session, Command, Timer and Event wait.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Created Materialized view for summary data to improve the query performance.
• Prepared SQL Queries to validate the data in both source and target databases.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Created UNIX shell scripts to extract data from various sources like Oracle and Flat Files and loaded the transformed data into targets database and to schedule the session and workflow.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources to the target database.

Environment: Informatica Power Center 7.1.2, Oracle, Mainframe, DB2, COBOL, VSAM, SQL, PL/SQL