SUMMARY:

• Over 7+ Years of IT Experience in experience in all aspects of Software Development Life Cycle - Analysis, Design, development, implementation and troubleshooting of Data warehouse applications in various industries such as HealthCare, Financial and Retail Domains.
• Technical expertise in ETL methodologies, Informatica 9.x/8.x/7.x - Power Center, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager.
• Implemented Slowly Changing dimensions Type 1 and Type 2 methodology for accessing the full history of accounts and transaction information.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Extensive knowledge with dimensional data modeling, OLTP, and OLAP, star schema/snowflakes schema, fact and dimension tables.
• Data modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology.
• Extensively used SQL and PL/SQL to write stored procedures, Functions Packages and Triggers.
• Solid database experience in Oracle 10g/9i/, DB2, MS SQL Server 2005/2000/7.0/6.5.
• Extracted and transferred source data from different databases like Oracle, SQL SERVER, Teradata, DB2and flat file into Oracle.
• Involved in writing UNIX shell scripts and writing autosys jobs to automate the scheduling process.
• Experience with Process Scheduling Tools Like Autosys, Tivoli.
• Experience with Production Support and working in Onshore and Offshore model.
• Highly proficient in converting business requirements into feasible technical solutions applying client-server database skills in mixed OS environments.
• Strong analytical, organizational, presentation and problem solving skills, as well as excellent inter-personal communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.1/8.1/8.6.1 / 9.0

RDBMS: Oracle 10g/9i, MS SQL Server, Teradata

Programming: SQL, PL/SQL, Unix

Operating Systems: Windows 95/98/2000/XP/NT4.0, UNIX (AIX, HP and SUN)

Other Tools: Aqua Data Studio, SQL Developer, SQL*Plus, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, CA

INFORMATICA/ETL CONSULTANT

Responsibilities:

• Designed and developed ETL mappings to load data from Sql Server, Oracle and Flat file System of records into Oracle and Teradata database using Informatica PowerCenter version 9.6.1
• Closely worked with Data Analysts and Data modelers to understand the Business Requirements and data elements.
• Worked with Java based Offshore Team to design and build a automation framework which automatically generates ETL informatica Workflows (XML Files) using Informatica Java API.
• Created Unix Scripts for record count and delimiter count validation of flat file sources.
• Used Autosys for Scheduling the Informatica Workflows.
• Extensively used informatica debugger to figure out the problems in mappings.
• Used SQL Developer and Teradata Sql Assistant for writing and executing Complex Queries and Store Procedures.
• Created Mapping parameters and variables and used them in different parameter files.
• Coordination with offshore ETL team included assigning daily task, mentoring and getting status updates.

Environment: Informatica 9.6.1,Teradata, Oracle 11g, DB2, Unix

Confidential, OH

ETL CONSULTANT

Responsibilities:

• Worked Extensively with Business Analysts and Users to understand the Business Requirements and created ETL Mapping Documents.
• Extensively used Informatica Client tools - Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Designed and Developed complex mappings by using lookup, expression, update strategy, sequence Generator, Aggregator, Router transformations to implement complex logics while coding a Mapping.
• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, DB2 and Flat Files and loaded into Oracle.
• Created mappings which involved Slowly Changing Dimensions Type 2 to implement the history management
• Created re- usable mapplets and used them in different mappings to streamline the process.
• Experience in using debugger to debug the mapping and check the data flow in the mapping.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, target based commit interval and SQL overrides.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Created UNIX shell scripts for automation of ETL processes
• Worked closely with reporting team and helped them whenever they had any ETL issues.
• Used Informatica Repository Manager to create folders, deployment groups, users and user groups and give permissions.

Environment: Informatica 9,Oracle 11g, DB2, Unix

Confidential, IL

INFORMATICA DEVELOPER

Responsibilities:

• Worked with Business Analysts to develop the Dimensional Data Models and Developed ETL code to Extract the Data from various sources and Load them Into Common Staging Environment, Transform the Data as per the Business Logic and Load them into Dimensional and Fact Target Tables.
• Mostly used expression, aggregator, look up, update strategy and SQL transformations in informatica mapping designer for doing data extraction, transformation and loading.
• Used Toad for oracle to analyze the data in production environment while doing the root cause analysis of the production issues.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
• Used Informatica Repository Manager to create folders, deployment groups to migrate the code between Dev, QA and Prod environments.
• Used AutoSys to Schedule the ETL jobs.
• Used SQL tools like SQL Developer, Toad for unit testing, data validation and develop Stored Procedures.
• Designed Parameter driven INFORMATICA sessions and workflows for extracting, cleansing, transforming and loading the data from the heterogeneous sources into the data warehouse by using parameter files
• Involved in the change control process for the maintenance of the developed code.

Environment: Informatica 8.5.1, Oracle 10g, Toad, OBIEE, Unix

Confidential, CA

INFORMATICA/ETL CONSULTANT

Responsibilities:

• Used Informatica Power Center to create mappings for extracting data from SQL Server, Flat File and XML files and loading them into Oracle.
• Wrote UNIX shell scripts and SQL stored Procedures to Import the data from the feed files into the Oracle staging tables.
• Used Informatica Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping’s run process.
• Worked with Database Storage Team in implementing Architecutural changes to support rapidly growing Data.
• Database query tool Toad was used to Design and Develop Stored Procedures in Oracle.
• Wrote UNIX shell scripts to load the data from the feed files into the Oracle staging tables.
• Used Tivoli (scheduling tool) to schedule the workflows, stored procedure and scripts to achieve the automation of report generation every quarter.
• Worked with OBIEE team to create the dashboards to generate the reports.
• Involved in production support to resolve production issues effectively.
• Worked on information that is secure, accurate, consistent, organized, and timely as in an enterprise or corporate data warehouse.

Environment: Informatica 8.1,Oracle, Sql Server 2008, UNIX, Tivoli

Confidential

ETL CONSULTANT

Responsibilities:

• Involved in the requirements analysis to define business and functional specifications
• Collaborated with Business Analysts to refine user's needs into designs and implementations
• Responsible for Extraction, Transformation and Loading which was performed using Informatica Power Center 7.1 to build the data warehouse
• Experience in developing ETL mappings using Designer (Source Analyzer, Mapping designer), Repository Manager, Workflow Manager & Workflow Monitor
• Developed complex mappings using multiple sources and targets in different databases, flat files
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
• Extensively involved in Production Support in Weekly Rotational Basis
• Designed and Developed mappings needed for enhancement of project.
• Created Informatica Mappings to populate the data into dimension and Fact tables.
• Exported and Imported mappings between different Informatica folders and also Repositories.
• Used different transformations like Aggregator, Lookup, Filter, Expression, Router, Update Strategy, XML Generator and Sequence Generator.
• Informatica Debugger is used to test the mappings and fixed bugs.

Environment: Informatica Power Centre 7.1, Oracle, SQL/PLSQL, UNIX