SUMMARY

• Over 7 years of ETL experience using Informatica Power Center (9.1, 8.6/8.1).
• Experience in Database Design, ER Modeling, and Dimensional Modeling.
• Worked on various phases of SDLC such as Project Requirement Study, HLD (High Level Design), LLD (Low Level Design), Coding, and Testing, Quality assurance Documentation, Implementation and Project Planning.
• Strong Data Warehousing experience using Informatica PowerCenter (Workflow Manager, Workflow Monitor, Repository Manager, Source Analyzer, Mapping Designer, Mapplet Designer, Transformation developer).
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources in Data Warehouse.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous sources like Flat Files, Oracle, Sybase, XML, SQL server and DB2.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using Source Qualifiers, Expressions, Normalizers, Routers, connected/unconnected Lookups/procedures, Update strategies, Sequence Generators, Java Transformation and Mapplets.
• Expertise in implementing complex business rules by creating re - usable transformations, and robust mappings/mapplets.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using SCD (Type1/Type2/Type3) loads.
• Extensive experience in implementation of Data Cleanup procedures, transformations Scripts, Triggers, Stored Procedures and execution of test plan for loading the data successfully into the targets.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. Knowledge of Partitioning Data and session partitions.
• Created sessions, workflows and worklets and scheduling using Control-M, AUTOSYS scheduler as well as informatica scheduler and production support of the jobs in the production.
• Proficient in using PMCMD and PMREP command.
• Experience in writing UNIX shell scripts and automated the entire processes using UNIX shell scripting.
• Knowledge of Cognos, OBIEE Reporting tool
• Team player and self-starter, capable of working independently and motivating a team of professionals.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter/PowerMart 9.x,8.x,7.x

BI Tools: OBIEE 10g, Cognos 8.4

Data Modeling: Dimensional Modeling (Star/Snowflake Schema Design), Erwin

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , Sybase, DB2, MySQL, MS Access

Languages: C, SQL, PL/SQL, Java, UNIX Shell Scripting

Environment: Red-hat Linux, Sun Solaris, HP UNIX, Windows NT/XP

Automation Tools: Autosys, Appwork, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Canton, MA

ETL Informatica Developer

Responsibilities:

• Involved in the analysis of business requirements and functional requirement documents to create technical design and technical specifications.
• Design, develop and implement source to target mapping specifications.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Router, Sequence Generator, Update Strategy
• Design and develop the Appworx scheduling scripts for the Informatica workflows, Oracle programs and the UNIX processes as per the dependencies.
• Create Audit control reports; send to different source and target systems with the counts of inbound, exceptions, warnings and informational only and outbound records for reconciliation.
• Create PL/SQL store procedures, functions and packages to extract and load the data.
• Create test cases and test data step up to verify accuracy and completeness of various processes, unit, system integration, user acceptance testing.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Mapping Specification documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Toad 9.5, Solaris

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Router, Sequence Generator, Update Strategy
• Involved in Performance Tuning both ETL informatica mappings and SQL statements.
• Developed and Mappings, Transformations and sessions.
• Used workflow manager to create sessions and other tasks and used them to build customized worklets and workflows using various task and scheduled the workflows using informatica scheduler to run at predetermined time.
• Used Pre session and Post Session to send e-mail through the Workflow Manager.
• Work closely with project manager to ensure all technical solutions are met and any gaps identified in earlier stages of development.
• Develop and support the creation of high value test cases to validate individual module functionality and end-to-end process.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Toad 9.5, Unix

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

• Designed the staging database and consumer dimensional datamart (STAR).
• Involved in analysis, design and development to ensure the successful execution of the data loading process.
• Designed and developed the ETL processes for loading data into Dimension Tables, Fact Tables, handling the Change Data Capture, Slowly Changing Dimension supporting Type 1 and Type 2.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Java transformations
• Involved in Performance Tuning both ETL informatica mappings and SQL statements.
• Used Parameters and Variables in both mapping level and session level as INCREMENT to extract the recent data from the source tables. Legacy system was full load only.
• Developed and documented data Mappings, Transformations and sessions.
• Code change migration from Dev to QA and QA to Production.
• Used workflow manager to create sessions and other tasks and used them to build customized worklets and workflows using various task and scheduled the workflows using informatica scheduler to run at predetermined time.
• Used Pre session and Post Session to send e-mail to various business users through the Workflow Manager.
• Work closely with project manager to ensure all technical solutions are met and any gaps identified in earlier stages of development.
• Develop and support the creation of high value test cases to validate individual module functionality and end-to-end process.
• The primary challenge of this role is to handle large volume of data, performance tuning and complex mappings.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 8.6, Oracle 11g, Toad 8.5.1, Red hat ES, Autosys

Confidential, Columbus, Ohio

ETL Informatica Developer

Responsibilities:

• Analyzed data flow requirements and developed a scalable architecture for staging and loading data, Translated business rules and functionality requirements into ETL procedures.
• Responsible in designing and introducing new (FACT or Dimension Tables) to the existing Model and decide the granularity of Fact Tables.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used the Informatica Designer, Source Analyzer, Target Designer and Mapping Designer.
• Developed and documented data Mappings/Transformations, Audit procedures and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, Stored procedure, XML web Services transformations.
• Used Informatica Power Center’s Workflow Manager to create sessions, worklets to run with the logic embedded in the mappings.
• Involved in scheduling the Informatica jobs, Unix scripts and Oracle procedures.
• Used the update strategy to effectively migrate data from source to target.
• Responsible to collaborate with DBA and Data Architects on implementation of database changes.
• Assisted in design and maintenance of Metadata environment.
• Created Partitions through the session wizard in the Workflow Manager to increase the performance

Environment: Informatica Power Center 8.5, Power Exchange, Autosys, HP UNIX, Windows NT, Oracle 10g, DB2, Erwin 4.0, SQL, PL/SQL, SQL * Loader, TOAD.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Created reusable Mapplets/transformations by embedding business logic.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplet, and Transformations for ETL Processes to load operational data into multi-dimensional database.
• Worked closely with various DW Analyst/Developers working on specific data marts, multiple business units to identify key information that will enhance business decision-making.
• Responsible for tuning ETL procedures and STAR and SNOWFLAKE Schema to optimize load and query Performance.
• Wrote UNIX scripts and PL/SQL scripts for implementing business rules.
• Generating Unix Scripts for Data warehouse applications and maintaining batch processing.
• Developed Database Triggers and Stored Procedures in Oracle.
• Involved in organizing production environment for different warehouse projects and documentation of complete project for maintenance purposes.
• Involved in unit testing, systems testing, integration testing and user acceptance testing.
• Scheduled and monitored sessions and batches on the Informatica Server using Informatica Workflow Manager and Control-M Scheduler
• Migration of the mapping from Development to test and test to production database.

Environment: Informatica Power Center 7.1.3 (Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 10g, Control M, Windows XP, Sun Solaris 9, Flat Files, Toad.

Confidential

Informatica developer

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Setup Procedures to Extract, Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse by Using Informatica PowerCenter.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Involved in the creation of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis for Loans, Deposits, Mortgage, Online Banking and Human Resources Departments of the Bank.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Created various transformations such as Update Strategy, Look Up, Joiner, Filter, Aggregator, Joiner and Router.
• Performance Tuning of Sessions and Mappings.
• Involved in creating, editing, deleting and scheduling of the Sessions in Informatica.
• Wrote Stored Procedures and triggers for faster processing of bulk volume of the data

Environment: Informatica PowerCenter 7.1, Oracle 9i, XML, UNIX Shell Scripts, Toad and PL/SQL

Confidential

Informatica developer

Responsibilities:

• Worked with the Data Business Analyst group to extract the medical claims data from flat files into Oracle database. Interacted with business analysts and end users to identify information needs and business requirements for final reports and created a comprehensive Technical Specification Document for the project.
• Extensively used Informatica for extracting and loading data from over 50 different clients each of which varied in data loads, anywhere from nightly, to weekly, monthly and semi annually.
• Major Involvement in tuning to improve the performance of mappings, both existing and newly developed. Created Tasks, Workflows and Worklets using Informatica and Monitored the Data loads in Workflow Monitor Module.
• Cleaned data as data was usually different from client to client.
• Scheduled the sessions and batches to run at specified intervals.
• Involved in unit, Integration, functional and performance Testing.

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, Windows NT 4