SUMMARY:

• Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager and Workflow Monitor.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, Java transformation, Web Services, XML transformation, etc.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Good experience in working with Informatica Data Quality(IDQ) tool suite
• Expertise in creating rules, physical data objects and logical data objects in Informatica Developer for data profiling.
• Extensively worked with transformations like Case Converter, Look up, Sorter, parser, Labeler, Merger, Expression and Standardizer while creating cleansing rules in Informatica Developer
• Good experience in creating mapping specifications in Informatica Analyst.
• Expert in implementing Type 1, Type 2 and Type 3 Slowly Changing Dimensions as per the business requirements to maintain full historical information
• Experienced in complete life cycle Implementation of data warehouse.
• Experienced in using the PDO (Push down optimization), CDC (Change data capture) mechanism.
• Expertise in creating ETL Mappings using Informatica Power Center to move information from multiple sources into a common target area such as Data Marts and Data Warehouse
• Experienced in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations using debugger.
• 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.
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake Schema, Surrogate keys, Normalization/De normalization.
• Experience in SQL, PL/SQL.
• Expertise in Data Warehouse/Data mart, ODS, OLTP & OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation & production support.
• Experience working with relational databases (Oracle, MySQL, SQL Server), Flatfiles, XML, and high-performance data warehouse appliance like IBM Netezza.
• Intensive knowledge of setting up the Data level security based on hierarchy based security for an organization.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS:

Tools: /Methods: MS - DOS, Unix, Linux, Windows NT, Windows 7 Informatica Power Center 8.6/9.1/ 9.5.1/9.6.1, Informatica Developer 9.5.1/9.6.1, Informatica Analyst 9.5.1/9.6.1 SQL*Loader, Oracle 9i/11g, IBM DB2, Teradata, SQL Server 2005 SQL Developer 2000, SQL*Plus, TOAD Erwin 4.0, MS-VISIO, Informatica MDM SQL, PL/SQL, UNIX Shell Scripting, KORN Shell Scripting OBIEE - Oracle Business Intelligence 10.1.3.X, Oracle BI Publisher, MS Word HTML,XML, TortiseSVN, CVS

PROFESSIONAL EXPERIENCE:

Senior Informatica and IDQ Developer

Confidential, Chattanooga, TN

Responsibilities:

• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, and monitoring capabilities of IDQ 9.6.1
• Created re-usable rules in Informatica Developer for name cleansing, address cleansing, phone number validation and SSN validation
• Worked with data analysts on creating mapping specifications in Informatica Analyst.
• Created mappings in Informatica analyst using rules created in developer
• Involved in Creating new tables/dictionaries for look-ups
• Worked with source DBA and Integration CoE on possible patterns for Change Data Capture
• Created Logical Data Objects in Informatica developer to integrate data from multiple sources into standardized view
• Worked extensively with transformation like Case Converter, Look up, Sorter, parser, Labeler, Merger, Expession and Standardizer while creating cleansing rules in Informatica Developer
• Exported all the rules and mapping from Informatica developer to power center
• Created complex mappings using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, source qualifier transformation, Unconnected stored procedure, Transaction commit control and Sequence generator in Powercenter
• Involved in Real time data load from SQL Server into DB2 staging
• Implemented change data capture on source data to target tables using control table logic
• Implemented error handling logic for all Change Data Capture mappings
• Troubleshoot problems by checking Sessions and Error Logs
• Involved in performance tuning of the process at mapping, session and database level.
• Copies data files from windows to LINUX and vice versa
• Execute the test cases for the code changes
• Prepared the code migration document and worked with release team in Migrating the code from Development to Test and Production environments
• Wrote complex SQL scripts to improve the performance as the volume of the data was heavy
• Scheduled and ran Workflows for Extraction, Loading processes and monitored the Workflows using Workflow Monitor
• Deployed ETL components code into multiple environments as per the approval received

Environment: Informatica Developer 9.6.1,Informatica Analyst 9.6.1,Informatica Power Center 9.6.1/9.5.1, SQL Server 2012, Terada SQL Assistant, IBM DB2, Linux

Senior Informatica Developer

Confidential, Allen, TX

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Teradata, Oracle, flat files and loading into sales force application
• Involved in Real time data load from AS400 DB2 into SQL Server staging
• Created various tables in SQL Server 2012 management studio and extracted data from SQL server to load into Dynamics
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, source qualifier transformation, Unconnected stored procedure, Transaction commit control and Sequence generator
• Implemented change data capture(CDC) on Teradata to update data in Sales force and Dynamics target tables using control table logic
• Created Reusable components like reusable Transformations (Expression, Aggregator, Sequence, Joiner, Router, Lookups, Rank, Filter), Mapplets and Work lets for using them across the projects
• Merged few mappings wherever possible to minimize the maintenance, optimize the ETL system and to reduce space occupancy on sales force application
• Created Informatica mappings with PL/SQL Procedures / Functions/triggers to build business rules to load data
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables
• Scheduled and ran Workflows for Extraction, Loading processes and monitored the Workflows using Workflow Monitor
• Did Performance tuning and Optimization of mappings for better performance and efficiency
• Good exposure to Teradata database and involved in using FastLoad, MultiLoad, Fast Export and TPump to load into/extract data out of Teradata staging
• Modified /Created parameter files in development, test and production environments using UNIX
• Copies data files from windows to UNIX and vice versa.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting
• Implemented error handling logic for all CDC mappings
• Helped the QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Provided production support for Informatica daily loading process using Informatica 9.5
• Execute the test cases for the code changes

Environment: Informatica Power Center 9.5/9.5.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Teradata 14.0, Oracle Developer, TOAD, Oracle 11g, SQL Server 2012, T-SQL, TOAD,UNIX

Senior Informatica Developer

Confidential, Concord, CA

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required Sources and Targets
• Analyzed business requirements to build a Data Mart for various business processes conformed to the business rules
• Analyzed the Functional Specs provided by the Data Architect
• Designed Technical specification document based on the FSD
• Created Mapping Design document based on FSD
• Extensively used Informatica for extracting, transforming, loading databases from Oracle, flat files and DB2
• Created PL/SQL Procedures and Functions for scrubbing the data
• Developed Transformation logic and designed various complex Mappings in the Designer
• Designed and developed various mappings in Mapping Designer, sessions & workflows in Workflow Manager to extract data from flat files, Oracle and DB2 sources and load to Oracle.
• Created, launched & scheduled sessions. Configured email notification
• Implemented the best practices for the creation of Mappings, sessions, Workflows and performance optimization.
• Implemented Pipeline partitioning to improve session performance.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data
• Wrote Queries, Procedures and Functions that are used as part of different application modules
• Performed Data Quality Analysis to determine cleansing requirements
• Created scripts to update the parameter files to establish delta extraction
• Wrote various shell scripts for pre-processing of data and scheduling of jobs
• Wrote Unix Shell Scripts for Informatica Pre-Session, Post-Session to schedule the Infa jobs (work flows)
• Prepared Test Data and loaded it for Testing, Error handling and Analysis
• Involved in preparing ETL design documents and Unit Test Plans for Mappings.
• Prepared the code migration document and worked with release team in Migrating the code (Informatica Objects, Unix Scripts) from Development to Test and Production environments
• Involved in answering the change request as part of the interaction testing
• Deployed ETL components code into multiple environments as per the approval received
• Provided Production Support by executing the sessions, diagnose problems and fix the mappings for changes in business logic.

Environment: Informatica Power Center 9.5, Oracle 11g, Toad for Oracle, SQL, PL/SQL, Windows 7

ETL/Informatica Developer

Confidential, NY

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Involved in gathering the business requirements from Business Analyst.
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the AR data and developed the code to extract the data for the AR module and implemented in the informatica.
• Developed the strategy for the incremental loads.
• Worked on various tasks like Session, E-Mail task, Command task, etc.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Created and used various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target table
• Developed Informatica mappings, re-usable Sessions and Mapplets for data load to data warehouse.
• Worked on slowly changing dimension Type1 and Type2.
• Used the Dynamic look up to implement the CDC.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, Update Strategy, Joiner and stored procedure transformations.
• Involved in performance tuning of the process at mapping, session and database level.
• Used parameter files and variables to design ETL process.
• Performed Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Fixed issues in Test, QA and Production.
• Developed Fast Load and Multiload Scripts in Teradata.
• Prepared the Low Level documents/mapping documents for the tasks assigned to me.
• Mode code from DEV to TEST to PROD using deployment groups.

Environment: Informatica Power Center 9.0.1, Oracle 11g, MS-SQL server, TOW and other legacy systems, TOAD, HP Quality Center, Autosys, MS Office Suite

ETL/Informatica Developer

Confidential, Brea, CO

Responsibilities:

• Implemented ETL Informatica designs and processes for loading data from the sources to target warehouse.
• Designed mappings from scratch and also did performance tuning of the mappings that were previously implemented and were having bottleneck.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager. Worked on Designer Tools like Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Used Java Transformation to converting customer’s contract duration to year-wise duration.
• Developed Re usable Transformations and Mapplets.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using Oracle Database Utility i.e. Data Pump Import and Export.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Used Informatica MDMfor cleansing Supplier & Customer data.
• Wrote SQL scripts to verify row counts and validate the data.
• Extensive experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Wrote UNIX shell scripting.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Experience with Oracle's Business Intelligence Tools i.e. OBIEE
• Used UNIX Shell Scripts to automate daily and weekly runs and execute post session commands
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• UsedWorkflow ManagerforCreating, Validating, Testing and runningthe sequential and concurrentWorkletsand Sessions and scheduling them to run at specified time.
• Designing data refresh strategy to resolve daily data reconciliation between BI and the warehouse that may result due to frequent delay in feed to the warehouse system or data adjustments in the warehouse.
• Responsible for performing peer review of mappings and workflows.

Environment: Informatica Power Center 8.6, OBIEE11g Oracle 11g, Informatica MDM, SQL, PL/SQL, WinSCP, UNIX Scripting, SQL Developer and Windows XP.

ETL/Informatica Developer

Confidential

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer, which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using Informatica Power center 8.6
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL Server 2005, DB2, Flat files, MS Excel, SQL, PL/SQL, TOAD, UNIX, Business Objects 5.1.

ETL Developer

Confidential

Responsibilities:

• Based on the client requirements identifying the appropriate data sources for loading Datawarehouse. Created detailed design documents based on mapping sheet.
• Created Informatica mapping to insert, delete and update data from the dimension tables.
• Involved in creation of ETL Technical Design and Process Documents for the Fact and Dimension Loads. Developed ETL Mappings using InformaticaPowerCenter involving extraction and loading of data from relational databases like MS SQL Server and Oracle.
• Developed complex Functions, packages, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Compressed data files by removing empty database pages and updating index statistics.
• Created Mapplets to load Session Control Tables used for updating Mapping Parameters and Variables in Parameter Files. ·
• Implemented stored procedures and functions, as per requirements, in PL/SQL. ·
• Was actively involved in the Migration process of ETL Mappings, Workflows and Sessions.
• Involved in unit and integration testing of mappings in ETL Test environments. · Performed Debugging procedures and Performance Tuning on bottlenecks encountered.
• Worked very closely with the Oracle to improve the performance of the stored procedures.

Environment: Informatica 6.1/6.2, PL/SQL, MS Access, Oracle 8i, DB2, Windows 2000, UNIX