PROFESSIONAL SUMMARY:

• Over 6 years of IT experience as ETL Developer (Informatica PowerCenter 10.x/9.x/8.x/7x), Reporting (Cognos), OBIEE 10.1.3 (DAC), Scheduling of ETL workflows.
• Experience in complete Software Development Life Cycle SDLC (Requirement Analysis, Design, Development and Testing).
• Expertise in Installation, Configuration, and Administration of Informatica Power Center and Server.
• Experience in perforing all dimensions of development including Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.
• Working experience extensively with mappings using Expressions, Joiners, Routers, Lookup and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets and Sessions.
• Knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Experience in creating Transformations and Mappings using Informatica Power Center …
• Expertise in creating ETL mappings using XML Source Qualifier, XML Parser and XML Generator to load data from XML Applications to downstream systems
• Experience in Migration of Jobs and workflows from Development to Test and to Production Servers to perform the integration and system testing.
• Applying patches, taking backup and restore repositories.
• Expertise in Data Modeling using Erwin.
• Experience in integration of various data sources like Oracle, DB2, SQL server and MS access and non-relational sources like flat files into staging area.
• Strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
• Provided 24 x 7 supports to Key Production Environments.

TECHNICAL SKILLS:

Programming Languages: C, C++, HTML, PL/SQL

Data Bases: Oracle 11c/10g/9i/8i/8.0, DB2, Sybase, SQL*Plus, Teradata, Siebel

Packages &ETL Tools: Informatica 10.x/9.x/8.x/7.x, Cognos 8, OBIEE 10.1.3, Siebel 8.1, TOAD

Unix, Win NT, MS: DOS, Solaris

Erwin 7.3, Star: Schema Modeling, Snowflakes Modeling

PROFESSIONAL EXPERIENCE:

Confidential, FL

ETL Informatica Developer

Responsibilities:

• Worked along with the Business Analysts for requirements gathering, business analysis, and testing and project coordination.
• Involved in the design team for creating the PPS system.
• Created Process and Technical Design Documents for the mappings that is built to load the dimensions in the data warehouse.
• Involved in all the phase of the project development, acceptance and production.
• Optimization and Performance tuning of mappings to achieve high response times.
• Created reusable transformations and Mapplets and used them in various mappings.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to the business rules and technical specifications.
• Prepared Document for Root Cause Analysis (RCA).
• Extensively used ETL to load data using PowerCenter/PowerConnect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Design and Development of ETL routines, using Informatica PowerCenter within the Informatica Mappings, usage of Lookups, Ranking, Stored procedures, functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers.
• Debugging and Trouble Shooting of Informatica Mappings.
• Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Assisted in knowledge transfer to client personal for maintaining the environment after implementation.
• Written Test scripts and Test cases for testing and enhancements which were used by QA for unit testing and user acceptance testing.
• Configure the workflow, Tables and indexes using Oracle Data warehouse Administration Console (DAC) and monitor the job runs for full and incremental loads.
• Coordinated User Acceptance Testing (UAT) with the business users.
• Written shell scripts in UNIX to execute the workflow, created Workflow, Worklets and Tasks to read parameters from parameter files.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.

Environment: Informatica PowerCenter 10.x/9.x, ETL, PL/SQL, DB2, Oracle11c, DAC, Teradata, Windows NT and UNIX Shell scripting.

Confidential, New York, NY

Informatica Developer (ETL)

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer and Workflow Manager.
• Involved in discussions with the users to get the exact requirements on the reporting perspective and designed a mechanism in Informatica for commercial customer hierarchies.
• Debugged the mappings extensively hard coding the test data ids to test the logics going by instance by instance.
• Developed mappings in the DEV environment and once tested and passed moved to QUAL and further scheduled for production using Autosys tool.
• Implemented Business Logic using PL/SQL Stored Procedures, Functions, and other Packages.
• Tested the data by writing SQL queries in command center for DB2 and SQLNavigator for Oracle.
• Tested data extracts in test, qual and prod environments.
• Tuned ETL mappings and SQL queries for better performance and efficiency.
• Assisted in knowledge transfer to client personal for maintaining the environment after implementation.
• Written shell scripts to run the workflows and automated them through Autosys.
• Supported production jobs, data enhancements and code fixes.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Performed 24/7 production on call Admin support.

Environment: Informatica Power Center 9.1, Oracle10g, SQL Server, DB2 Command Center, Sun Solaris 7.0, Autosys.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Identification of various Data Sources and Development Environment.
• Data modeling and design of for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Prepared user requirement documentation for mapping and additional functionality. Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, MS SQL.
• Prepare user requirement documentation for mapping and additional functionality. Extensively used ETL to load data using PowerCenter/PowerConnect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Created PL/SQL packages, Stored Procedures for data transformation on the data warehouse.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL and SQL.
• Used Update strategy and Target load plans to load data into Type1 Dimensions.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Development of ETL routines, using Informatica PowerCenter Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures, functions, MS SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Developed joiner transformation for extracting data from multiple sources.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Documented the complete Mappings.

Environment: Informatica Power Center, Oracle 9i, MS SQL, PL/SQL, TOAD and Windows.

Confidential, Network, CA

Informatica Developer

Responsibilities:

• Extracted data from DB2 and oracle based Market soft sources and transformed those and loaded in to DB2 targets.
• Debugged the mappings extensively hard coding the test data ids to test the logics going by instance by instance.
• Involved in discussions with the users to get the exact requirements on the reporting perspective and designed a mechanism in informatica for commercial customer hierarchies.
• Tested the data by writing SQL queries in command center for DB2 and SQLNavigator for Oracle.
• Used transformations like Source Qualifier, Unconnected Lookup, Router, Update, Expression, Aggregator, and Sequence Generator.
• Created reusable transformations in the shared folder and used the shortcuts in mappings.
• Involved in the code reviews and Bug fixing of the mappings in production to increase the efficiency.
• Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
• Used Mapping Parameters and Variables.
• Written Test scripts and Test cases for testing and enhancements which were used by QA for unit testing and integration testing.
• Maintained the repository, created users, user groups and security access control using Informatica Repository Manager.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Implemented Performance tuning concepts for Informatica at database, designer and workflow manager for the faster retrieval by the BI people.

Environment: Informatica Power Center, Business Objects, Oracle, SQL Navigator, Embarcadero Rapid SQL, TOAD, UNIX Shell Scripting.