Professional Summary:

7 years of experience in System Analysis, Design, Development, Data warehousing and Data Marts.

Extensive experience in Informatica Power Center/Power Mart to implement Data Marts which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow.

• Experience with high availability systems Very Large databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
• Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling.
• Database and table design and implementation for data warehouse and related ETL processes.
• Expert knowledge in working with Informatica Power Center 9.1, 8i, 7i.
• Knowledge in working with Informatica Power Exchange 8.6.1
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Extensively worked with large Databases in Production environments.
• Experience on Informatica Designer tools - Transformations and Reusable Transformations, Mappings, Mapplets.
• Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, Worklets and sessions.
• Experienced in developing Dashboards Reports in Cognos 8 and 10.
• Experience in Salesforce.com Applications and Integration.
• Experience in working various other databases like Oracle, Netezza and Sybase.
• Experience in Using SFDC Sales Force CRM
• Experience in building very large data warehouse with many complex transformations with many sources and targets.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL Server, XML files, Teradata and loaded into Oracle database.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
• Experience in analyzing relational and dimensional databases SQL, Oracle and strong knowledge in UNIX Operating System.
• Implemented SCD -Type I Type II and Type III.
• Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, indexes.
• Experience in working with various Databases like Oracle, DB2 UDB, Teradata, flat files, SQL Server 2005/2008/2012, Sales force and MS Access 2000.
• Experience on Performance Tuning of Mappings and Sessions and Batches.
• Experience in using Automation tools like Autosys scheduling workflows Using CA7 scheduling
• Implemented CDC in Oracle databases to capture latest updates from source to destination.
• Experience in using Informatica Debugger to test the data flow and fix the mappings.
• Extensive experience in error handling and problem fixing in Informatica.
• Extensive experience and knowledge of the Project Life Cycle, including Requirement gathering, and Test Plans Development and Execution.
• Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Skilled in Unit Test, System Integration Test and User Acceptance Test.
• Excellent communication skills, good organizational skills, self-motivated, positive attitude, ability to work independently or co-operatively in a team.

Technical Skills:

Professional Experiences:

Role: Informatica ETL Developer

• Project Description: The facilities, advanced medical treatments and procedures, as well as highly qualified staff have distinguished Novant Health as a not-for-profit healthcare leader serving more than five million residents from Virginia to South Carolina.
• DB2-NZ migration project involved converting existing DB2 targets to NZ which were sourced from SQL server and Siemens DB. This project was primarily aimed to convert the staging and ODS layers from DB2 to Netezza which involved converting the DB schemas as well as Informatica objects.

Responsibilities:

• Understanding present process flow and business functionalities and prepare ETL process flow for Predictive analysis.
• Implemented technical specification document for ETL process and Design documents for each module. Designed, Developed and Supported Extraction, Transformation and Load Process ETL with Informatica Power Center 9.5.1.
• Executed them with Oracle's SQL plus and Teradata's Query man or BTEQ.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Used DataStage as an ETL tool for developing the Data Warehouse.
• Used SQL Server 2008 Integration Services SSIS transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Developing Dashboards Reports in Cognos 10.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Involved in generating FLoad, Mload and Tpump scripts to load the data into Teradata tables.
• Extensively worked on tuning of sessions and mappings for better performance.
• Wrote test scripts to validate the data for the testing team. Did unit testing, system integrated testing.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Performed integration and performance testing on DataStage ETL jobs.
• Creating list reports and cross tab reports using Business Objects and Cognos.
• Created Dimensional and Relational Physical logical data modeling fact and dimensional tables using Erwin.
• Worked with production support in finalizing scheduling of workflows and database scripts using Autosys.

Environment: Informatica Power center 9.5.1, Informatica Power Exchange, oracle 11g, TSQL, Teradata 14, SCD, SQL server 2012, DB2, Cognos 10, XML, Business intelligence BI , Data Modeling, IBM Info Sphere DataStage 8.5, Flat Files, SSIS, Linux/UNIX.

Confidential

Role: Informatica ETL Developer/Support

Description: The Confidential , commonly referred to as BNY Mellon, is an American multinational banking and financial services corporation formed on July 1, 2007 as a result of the merger of The Bank of New York and Mellon Financial Corporation.

Responsibilities:

• Extensively worked with the data modelers to implement logical and physical data modeling to create an enterprise level data warehousing.
• Extensively worked on creating Facts and Dimensions tables.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Worked Extensively on ETL process using SSIS packages.
• Extensively used Informatica Power Center 8.6 to extract data from various sources and load in to staging database.
• Used Teradata Parallel Transporter TPT for loading pipe delimited, comma delimited and fixed-width data files onto Teradata EDW.
• Generated Complex reports in Cognos 10 report studio including Drill Down reports.
• Involved in data cleansing, mapping transformations and loading activities.
• Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Implemented Slowly Changing Dimension methodology for Historical data.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Fine-tuning of PL/SQL Stored Procedures.
• Writing Oracle Stored Procedures, SQL scripts and calling them by using Perl shell and Korn shell scripts at pre and post session. Designing mapping templates to specify high level approach.
• Used DataStage Director to run and monitor the jobs for performance statistics.
• Managed migration from Cognos to SQL Server 2008 Reporting Services.
• Involved in TSQL Scripting for complex business logic.
• Creating BTEQ Basic Teradata Query scripts to generate Keys.
• Coordinated between Development, QA and production migration teams.
• Extensively involved in documentation of the project.
• Reports were generated using OBIEE for analysis.

Environment: Informatica Power center 9.1, Informatica Power Exchange 9.1, oracle 11g, SQL server 2008, ER-studio, Autosys 11.3, DB2, Sybase, XML, Flat Files, Business intelligence BI , Data Modeling, Cognos 8/10, Windows 7, IBM Info Sphere DataStage 8.1, Teradata V2R5, SSIS, TSQL, Linux.

Confidential

Informatica ETL Developer

Description:

Confidential started as a small community bank called the High Street Bank in Providence, Rhode Island back in 1828. Since then it has grown and established itself as large commercial bank holding company. It is headquartered in Providence, Rhode Island and operates its branch network in 12 states and has non-branch retail and commercial offices in more than 30 states.

Responsibilities:

• Worked with Informatica power center client tools like Source Analyzer, Warehouse Designer, and Mapping.
• Extensively used Informatica power center 8.6.1 for extraction, transformation and loading process.
• Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc.
• Extracted data from Oracle, DB2, SQL server, flat files and XML files transformed the data based on business requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Involved in different data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Created ETL design for a DB2 UDB data mart loading using Informatica PowerCenter.
• Extensively used ETL to load data from multiple sources to Staging area Oracle 11g using Informatica PowerCenter.
• Created export scripts using Teradata Fast export Utility.
• Used TOAD, Oracle SQL Developer for testing SQL code.
• Experience working with very large volumes of data.
• Created jobs and job variable files for Teradata TPT and load using tbuild command from command line.
• Load operational data from Oracle, DB2, SQL Server, flat files, Excel Worksheets into various data marts.
• Migrated DTS packages to SSIS packages.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Worked with third party CA7 scheduling Team for scheduling the Informatica PowerCenter Workflows.
• Utilized Informatica debugger for trouble-shooting the Mappings.
• Created UNIX shell scripts and called as pre session and post session commands.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Written complex SQL queries and queried the Oracle database to test DataStage ETL code.
• Structuring Metadata and Cognos Models using Framework Manager.
• Scheduled and executed ETL jobs using DataStage Director.
• Developed COGNOS cubes against an Oracle OLTP database.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica PowerCenter 8.6.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console , Power Exchange 8.6.1, Teradata V2R4, Business Objects XI r2, Oracle Developer, Netezza4.6.8,TOAD 9.6, DB2,Oracle 11g, Business intelligence BI , Data Modeling, IBM Info Sphere DataStage 7.1, Cognos 8.4, SQL Server 2008/2005, SSIS, TSQL, PL/SQL,UNIX SUN Solaris ,Flat Files.

Confidential

Informatica ETL Developer

Description:

Confidential . software company that provides cloud and virtualization software and services

Responsibilities:

• Analyzing the source data coming from different sources SQL Server, Oracle, Sales force and also from flat files like Access and Excel and working with business users and developers to develop the Model.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Expertise in Developing Mappings, Define Workflows Tasks, Monitoring Sessions, Export Import Mappings and Workflows and Backup, Recovery.
• Load the data into staging tables from different servers like SQL server, Oracle, Sales force SFDC and also from flat files like Access and Excel.
• Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
• Creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked on Sales Force Sales, Service Support, Analytics, and their collaboration platform .
• Worked on both Extracting and loading the data from and to Sales Force Sales, Service Support, Analytics, and their collaboration platform .
• Partitioned Sessions for concurrent loading of data into the target tables.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Remodeling the existing system using ER Studio for logical/Physical data modeling.
• Migrated the folders, mappings, sessions, Mapplets, Worklets, and Workflows from Informatica 8.1 to 8.5.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups connected and unconnected while transforming the Sales Force Data SFDC according to the business logic.
• Coded MVS/JCL for TERADATA BTEQ in batch.
• Developing Teradata Utility scripts like Fast Export, FLoad, and MLoad to load data from various source systems to Teradata.
• Involved in upgrading the Informatica version 8.1 to 8.5
• Created Materialized views for summary tables for better query performance.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Written Shell Scripts and control files to load data into staging tables and then into oracle base tables using SQL Loader.
• Created test data to test the functionality of the DataStage jobs.
• Automated existing ETL operations using Autosys.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Used perl and shell scripts to pre-process data in UNIX.
• Providing extensive changes as a part of User acceptance testing and deployment of mappings at client place.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
• Setup of the ETL process for integration of Oracle EBS with OBIEE.
• Preparing the Design documents based on the Functional/requirements specifications.

Environment: Informatica Power Center 8.1 Informatica Power Center Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console , IBM Info Sphere DataStage 7.0, Teradata V2R4, Sales force SFDC , Oracle 10g, Business intelligence BI , SQL Server 2005,Oracle Developer, PL/SQL, Flat Files, TSQL, SSIS, UNIX, Erwin 3.5, TOAD 9.0, Data Modeling, OBIEE,UNIX AIX

Confidential

Informatica/ETL Consultant

Description:

Confidential , is part of a 6.9 billion family of companies that finances and delivers health care services across upstate New York and long term care insurance nationwide

Responsibilities:

• Designed and developed ETL process using Informatica Power Center
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Oracle Data warehouse.
• Involved in SDLC from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Loading data from various data sources Oracle, SQL Server into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and Execute the SQL's on UNIX environment.
• Accomplished data movement process that load data from SQL Server, Oracle into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD.
• Perform logical and physical Data Modeling using Sybase power designer.
• Utilized SSIS SQL Server Integration Services to produce a Data Warehouse for reporting.
• Created Informatica mappings with PL/SQL Procedures/Functions and triggers in TSQL to build business rules to load data.
• Created Materialized views for summary tables for better query performance.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Documented the issues related to cleaning of the Data.
• Used PMCMD command to interact with Informatica server from command mode.
• Used PMREP command to create back ups, copy, and delete repositories.
• Developed UNIX Shell scripts for validating the files, running stored procedures Informatica workflows.
• Created UNIX shell scripts and called as pre session and post session commands.
• Coordinating with the client and gathering the user requirements.

Environment: Informatica PowerCenter 8.1, Teradata V2R4, UC4, Oracle 10g, TSQL, SSIS, SQL Server 2005, PL/SQL, Flat Files, Business intelligence BI , ERWIN Data Modeling tool, Advanced Query Tool, LINUX Red hat .

Confidential

ETL/Database Developer

Responsibilities:

• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.
• Identify source systems, connectivity, tables, and fields, ensure data suitability for Mapping
• Designed and developed complex Informatica mappings using expressions aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Used SQL Over rides in Source Qualifier and Lookups to improve mapping performance.
• Implemented the slowly changing dimensions as per the requirements.
• Created sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Tuned the session parameters to increase the efficiency of the sessions in the workflow manager.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Extracted client information data and history from Flat files, Oracle, transformed and loaded into Oracle database.
• Developed SQL, PL/SQL scripts for extracting data to system.
• Developed UNIX scripts for scheduling the jobs.
• Designed and developed Oracle PL/SQL Procedures.
• Prepare MDM platform roadmaps for current vs. future state

Environment: Informatica Power Center 7.1.1, Data Stage 7.5.1, Oracle 9i, PL/SQL, Business Objects 6.5, Shell scripting, Sun Solaris UNIX, Windows 2000.