SUMMARY:

• Over 8 years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center Informatica 9.x/8.x/7.x, PowerExchange, IDQ, Informatica Developer, IDE, MDM, SSIS,OBIEE, Qlikview etc .
• Extensive experience using tools and technologies such as Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, DB2 UDB, Sybase, Teradata 13/12/ V2R5/V2R4, Netezza MS Access, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, Erwin 4.0/3.5, SQL* Loader, TOAD, Stored procedures, triggers.
• Experience in using Teradata Utilities such as Tpump, Fast Load and Mload. Created BTEQ scripts.
• Experience in designing, developing, testing, and maintaining BI applications and ETL applications.
• Strong business understanding of Banking, Retail, Finance and Healthcare and Telecom sectors.
• Experienced in integration of various data sources like Oracle 11g,10g/9i/8i, MS SQL Server 2005/2000, XML files, Teradata, Netezza,Sybase,DB2, Flat files, XML, Salesforce sources into staging area and different target databases.
• Strong data modeling experience using Star/Snowflake schemas, Re - engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling .
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as Autosys and Tidal .
• Experienced in the development, modification and testing of UNIX Shell scripts.
• Experienced in Performance Tuning, identifying and resolving performance bottlenecks at various levels in Business Intelligence applications. Applied the Mapping Tuning Techniques such as Pipeline Partitioning to speed up data processing. Conducted Session Thread Analysis to identify and fix Performance Bottlenecks.
• Strong experience in Informatica administration and was involved in maintaining Informatica Repository and Server processes, performing code migration from DEV to TEST/ PROD, backup and restoring of Informatica Repository and upgrades.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems.
• Experienced in creating reports using Qlikview, Oracle Analytic functions, Tableau, Microstrategy, etc.
• Performance tuning at Mapping, Session and database level.
• Advanced Knowledge of Oracle PL/SQL programming, stored procedures & functions, indexes, views, materialized views, triggers, cursors and tuning the SQL query.
• Worked with the Business Analysts to gather requirements.
• Outstanding communication and interpersonal skills, ability to learn quickly grasp new concepts, both technical and business related and utilize as needed.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups and proven ability to implement technology based solutions for business problems.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Power Exchange 9.6/9.5/8.6/8.1 7.1, Metadata Manager, Power-Exchange, IDS, IDQ, IDE, MDM, SSIS, DataStage, Salesforce etc.

Reporting Tools: Business Objects XIR2/6.1/5.0, Qlikview, OBIEE, Microstrategy, Oracle Analytics, etc.

Databases: Oracle 11g/10g, MS SQL Server 2008/2005/2000, MS Access, IBM, DB2, Teradata 14.0,Netezaa 4.0, Siebel CRM, PeopleSoft

Data Modeling: Data Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

DB Tools: TOAD, SQL Developer, SQL Assistant, Visio, ERWIN

Languages: C, C++, Java, SQL, PL/SQL, Unix Shell Scripting

Operating Systems: UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr.ETL Developer/Sr.Application Developer

Responsibilities:

• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Involved in Designing High level Technical Documentation based on specification provided by the Manager.
• Designed and created Physical and Virtual Data Objects using Informatica Data Virtualization environment(IDS).
• Drived out requirements and designs and worked with business and technical teams.
• Created Complex SQL queries for reporting against tables.
• Independently migrated code from IDS to Informatica Power Center.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Performance tuned ETL processes at the mapping, session, physical data objects, logical data objects and Database level.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Provided production support as required.
• Worked on special assignments such as targeted data loads for WCDST and business partner needs.
• Worked with SQL server, SSIS and XML.
• Integrated sources from different databases and flat files.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Independently perform complex troubleshooting, root-cause analysis, solution development
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Used Deployment group to move Informatica objects from DEV to TEST and from TEST to QA/PROD.
• Suggested best practices in Informatica and ETL processes to improve efficiency of the ETL process.

Environment: Informatica Power Center 9.6.1, Informatica Data Services(IDS) 9.6.1, Oracle 11g, SQL Server 2008, SSIS, PL/SQL, Visual Studio 2012, UNIX, TOAD, XML.

Information Architect/BI Developer

Responsibilities:

• Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Design and developed Amazon Redshift databases
• Worked with XML, Redshift, Flat file connectors.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Worked in different subject areas - Medical, Pharmacy, Dental, Vision, Medicare, Medicare Advantage, PPO, HMO, POS, Master Medical and Care Management.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Creating and managing Virtual machines in Windows Azure and setting up communication with the help of Endpoints and also VM migrations from Transactional hosts.
• Worked on Inbound, Outbound and Carve-out Data Feeds and developed mappings, sessions, workflows, command line tasks etc. for the same.
• Used Teradata Utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Used Data stage as an ERL tool to extract data from source systmes, and loaded the data into Oracle database.
• Provided Teradata Data Warehouse Administration and maintain existing physical and logical model
• Involved in Migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata
• Used Data stage to manage the Metadata repository and for import /export for jobs
• Used IDQ address validation transformation to generate CASS and AMAS report for US and China addresses
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Worked with Connected and Unconnected Stored Procedure for pre & post load sessions
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.
• Worked on production tickets to resolve the issues in a timely manner.
• Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

Environment: Informatica Power Center 9.5, Informatica IDQ, Oracle 10g, Teradata, SQL Server 2008, Toad, SQL Plus, SQL Query Analyzer, SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, Tivoli Job Scheduler , Windows Azure,Erwin.

Sr .ETL Developer/Analyst

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Involved in the data modeling and designed the Data Warehouse using Star Schema methodology. Also, responsible for all the ongoing data model design decisions and database implementation strategies.
• Extracted data from different source systems such as Oracle, SQLServer, MS Access, DB2, Mainframes, XML and Flat Files.
• Created customer hub (MDM) - by consolidating and integrating various sources and storing the golden record as individual identity in the hub.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and Load Data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Used Metadata Manager to manage the Metadata associated with the ETL processes.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
• Used error handling mapplets to capture error data into PMERR tables for handling nulls, analysis and error remediation process.
• Defined the test strategy, created unit test plans and supported UAT and regression testing using HP Quality Center.
• Used IDQ to do data profiling of the master data. Used Informatica Analyst to get an overview of the accuracy of the data and percentage populated.
• Used Informatica Developer client to set up Address validation, name matching using Match transformation, etc.
• Identified slowly running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Advocated best practices for ETL Processes and conducted Data Integration COP meetings.
• Created slice and dice and drill down Reports, Dashboards, and Scorecards using OBIEE 11g for various subject areas.

Environment: Informatica Power Center 9.5/9.1.1/8.6, Informatica MDM, Informatica Developer client, Power Exchange CDC, Oracle 11g, Erwin, Informatica IDQ, Quality Center, SQL SERVER 2005/2008, MS Access, XML, T-SQL, Shell Scripts, Control-M, Teradata.

Sr .ETL Developer/Analyst

Responsibilities:

• Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Performed Source System Data Profiling using Informatica Data Explorer (IDE).
• Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems.
• Informatica Power Exchange for Mainframe was used to read/write VSAM files from/to the Mainframe.
• Basic Informatica administration such as creating folders, users, privileges, server setting optimization, and deployment groups, etc.
• Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Used Informatica IDQ to do data profiling of the source and check for the accuracy of data using dashboard.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part of Unit/Integrations testing, UAT testing.
• Used Teradata Utilities such as Mload, Fload and Tpump.
• Created BTEQ scripts.
• Used UNIX scripts for automating processes.

Environment: Informatica Power Center 9.1.1, Informatica Developer Client, IDQ, MDM, Power Exchange, SAP , Oracle 11g, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE, Teradata.

Sr .ETL Developer

Responsibilities:

• Translated the business processes/SAS code into Informatica mappings for building the data mart.
• Used Informatica powercenter to load data from different sources like flat files and Oracle, teradata into the Oracle Data Warehouse.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Developed reusable transformations and mapplets to use in multiple mappings.
• Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Created mappings using Data Services to load data into SAP HANA.
• Involved in data quality checks by interacting with the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Involved as a part of Production support.

Environment: Informatica Power Center 9.1, Oracle11g, Teradata, SAP HANA, UNIX Shell Scripts.

Informatica Developer

Responsibilities:

• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Involved in Designing High level Technical Documentation based on specification provided by the Manager.
• Created Complex SQL from Technical requirement document and optimized it.
• Created Complex SQL queries for reporting against tables.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Performance tuned ETL processes at the mapping, session and Database level.
• Integrated sources from different databases and flat files.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Independently perform complex troubleshooting, root-cause analysis, solution development
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Extensively used SQL and PL/SQL Scripts.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems. Used SAP BO as the reporting tools.
• Used Deployment group to move Informatica objects from DEV to TEST and from TEST to QA/PROD.
• Suggested best practices in Informatica and ETL processes to improve efficiency of the ETL process.

Environment: Informatica Power Center 8.1/8.6, Oracle 10g/9i, SQL Server 2000/2005, SSIS, PL/SQL, SQL, Visio 2003, UNIX,TOAD, DataStage.

Confidential, Dearborn,MI

Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 8.6.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for Test and Production issue resolutions.
• Developed shared folder architecture with reusable Mapplets and Transformations.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Created events and various tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Migrating Informatica Objects using Deployment groups.
• Trouble issues in TEST and PROD. Do impact analysis and fix the issues.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes .

Environment: Informatica - PowerCenter 8.6, Power Exchange, Teradata, Oracle 10G, MS Access, UNIX, Windows NT/2000/XP, SQL Server 2008, SSIS, OBIEE, Qlikview, Teradata, SQL Assistant, Netezza, DB2.