PROFESSIONAL SUMMARY:

• Around 8 years of experience in Information Technology with a strong background in Database development and Data warehouse and ETL process using Informatica Power Center 9.6/9.1/8.x/7.x/6.x/5.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Sybase, COBOL files, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Hands on experience in Pentaho Business Intelligence Server Studio.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Extensively used Pentahoreport designer, Pentaho kettle, Penatho BI server, BIRT report designer
• Experience with slowly changing dimension methodology and slowly growing targets methodologies.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Excellent communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Talend, Data Stage, Pentaho,SalesForce.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.

Data Modeling tools: Erwin, MS Visio

Languages: SQL, PL/SQL, UNIX, Shell scripts, C++, SOAP UI, JSP, Web Services, Java Script, HTML, Eclipse

Scheduling Tools: Autosys, Control-M, TWS

Testing Tools: Quality Center, Clear case.

PROFESSIONAL EXPERIENCE:

Confidential, Glendale CA

Sr. ETL Informatica Developer/Team Lead

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
• Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Functioned as an ETL Team Lead, Informatica Senior developer and part of the ETL Production support team.
• Lead both onsite and offshore teams including allocation of development and support tasks offshore to reduce cost
• • Proven abilities in process improvements and best practices, database environment control and change management. Lead projects from initialization phase from capturing business requirements to final phases of testing
• Have created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc using IDE.
• Designed and developed complete BI infrastructure using Pentaho BI Suite.
• Have created Match, and Merge rules, developed address validations etc and developed address validations to countries like US, and also developed reusable error handling rules using IDQ
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Published cubes and reports onto Pentaho repository and refreshed Pentaho BI repository after uploading each object to be available for central use,
• Developed various reports for the client using Pentaho Report designer.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica Power Center 9.6/9.1, Oracle 11g,, Flat Files, TOAD, Teradata, Autosys, Perl Scripting, Windows XP, UNIX, Sales Force, Web Services

Confidential, Texas

Sr. ETL Informatica Consultant/Team Lead

Responsibilities:

• Attended multiple requirement gathering sessions with source system teams and business users.
• Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
• Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Developed advanced mysql Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Enhanced system performance by tuning mysql scripts.
• Developed unit test plans for each scenario and programmed for data validation and proper error handling to manage the transactions without any data loopholes.
• Responsible for tuning the Informatica Mappings and Sessions for optimum performance.
• Enhancing the system with change requests and fault fixes delivery.
• Responsible for loading the flat files into Oracle database by using SQL* Loader and Informatica.
• Database performance by optimizing back end queries, mysql tuning and implementing performance improvements by analyzing indexes, table partition, parallelism etc
• Documentation of all changes made to enhance the code for new requirements.
• Used external tables to manipulate data obtained on monthly basis for vehicle information before loading them into the tables.
• Utilized Quest tool (Toad 8.0) for database monitoring and tuning.
• Involved in writing complex report SQL queries, oracle forms and oracle reports solutions.
• Involved in post support activities.

Environment: Informatica 8.6, Erwin 7.1,Oracle 11g,, Data Stage, MySql (SQL Server), SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server 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.
• This is multi database environment, migrated SQL Server backend to Teradata.
• Converted mysql queries, procedures functions and packages to Teradata scripts.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, 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.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and Imported data fromSalesForce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 7.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,My SQL

Confidential, Hartford, CT

InformaticaDeveloper

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application.
• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, mysql and Unix Shell Scripting.
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets, dynamic lookups and reusable transformations in ETL maps
• ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
• Performed Database/ETL migrations from Dev environment to Test//UAT/Staging and PROD environments

Environment: SQL Server 2005, MYSQL/T-SQL, Pro*C, Toad, ER-Studio, UNIX, Informatica 7.1

Confidential

PL/SQL Developer

Responsibilities:

• Requirements gathering from users designing the database.
• Functional specs review and created technical specs documents.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed Ab Initio graphs to manipulate the logs and load the data into the Oracle databases.
• Developed re-usable graphs for data extraction and scrubbing for various transformation processes
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.