SUMMARY

• Having 8+ years of experience in development, maintenance, support and enhancement in Informatica Power Center,InformaticaData Quality (IDQ) and Informatica MDM.
• Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
• Extensive experience in Extraction, Transformation and Loading of Data into Enterprise Data Warehouse using Informatica Power Center 9.x, 8.x,7.x versions.
• Strong experience in Designing the Workflows, Mappings, creation of Sessions and scheduling them using Informatica PowerCenter 9.x, 8.x, 7.x versions.
• Extracted the data from the SAP source systems SAP BW and SAP ECC and loaded the data into ODS tables.
• Varied experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy, Normalizer and more.
• Experience in Debugging sessions and mappings, Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment.
• Experience in Implementing the Informatica MDM (Master Data Management) process for Customer and Product Master Data Implementation.
• Extensive experience in Informatica Data Quality(IDQ).
• Implemented Exception Handling Mappings by using Data Quality, Data Profiling, Data cleansing and data validation by using IDQ..
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, SAP Source Systems, XML Files) to load into Data Warehouse/Datamart targets.
• Knowledge inmainframe (COBOL,JCL,SQL,DB2,VSAM,FILE - AID,TSO/ISPF,CA7(Scheduler Tool), ENDEVOR,XPIDETOR,SPUFI,IBM UTILITIES).
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Worked with DBMS like Oracle 9i/10g/11g, MS SQL Server.
• Experience in Database development skills using Oracle PL/SQL to write stored procedures, functions, packages and triggers.
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data Warehousing and Business Intelligence.
• Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Excellent interpersonal and communication skills, customer skills, documentation skills and desire to work in dynamic and challenging environments.
• Work exceptionally well in a team or in an individual environment (self starter).
• Ability to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETLTools: InformaticaPower Center 9.X/8.X/7.X, Power Exchange, Informatica MDM, Informatica DVO, Address Doctor, Informatica Data Quality(IDQ).

Databases: Oracle 9i/10g/11g, DB2, SQL Server 2005/2008,Teradata

Reporting Tools: Cognos, OBIEE

Data Access Tools: TOAD, SQL Navigator, Oracle,Teradata, SQL Developer

Programming Languages: COBOL, JCL, SQL, PL/SQL, Unix Shell scripting

Version Control Tools: Sub Version, SharePoint

Scheduling Tools: Autosys, Robot, Informatica Job Scheduler,CA7

Operating Systems: MS DOS, Win 98/2000/XP/7/8, UNIX, Linux

Other Tools: SAP BW 7.3, Salesforce, Win SCP, Putty, JIRA, HP ALM, HP Quality Control

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

Senior Developer

Responsibilities:

• Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment and provided production support.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
• Implemented the Change data capture(CDC) using the Informatica Power Exchange.
• Extracted the data from SAP ECC and BW system’s and loaded the data into ODS tables.
• Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing tablespaces and partitioning schemes.
• Scheduled the Workflows using the Job Scheduler Skybot.
• Responsible for identifying the missed records in different stages from source to target and resolving the issues.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Worked with InformaticaData Quality (IDQ) toolkit, Analysis, data cleansing.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.
• Installing and Configuring of Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications.
• Created Landing tables, Staging tables, BO tables, Mappings, transformations for the MDM development.
• Setting Trust configuration and Validation Rules, Created Match Rules and Merge Settings for MDM process.
• Configured the data flow Land, Stage, Load, Tokenize, Match, Consolidate and Created Query and Packages in HUB..
• Created Informatica Data Director (IDD) UserExits to perform server side validations.
• Deployed UserExits using IDD configurations.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 11g, Informatica Data Quality(IDQ), SAP BW 7.3, SAP ECC 6.0, Toad, Skybot, PL/SQL (Stored Procedures, Triggers, Packages), Informatica MDM,HP ALM, Address Doctor, Informatica Data Quality(IDQ).

Confidential

Senior Developer

Responsibilities:

• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions.
• Analyzed source data and gathered requirements from the business users.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Coordinating with source system owners, day-to-day ETL progress monitoring, and maintenance.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Migration, maintenance and support for Informatica interfaces/projects
• Extensively involved in performance tuning for Informatica and Database side.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Created Reference Mappings by implementing SCD (Type1 and 2).
• Extensively involved in writing SQL queries, creating PL/SQL functions, procedures and packages.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Created mapping documentation for all the existing mappings and tuning of these mappings.
• Used Mapping Parameters and Variables, Reusable Transformations.
• Involved in creating Pre and Post Session SQL statements.
• Scheduled the Workflows using the Job Scheduler Autosys.
• Used Sub version tools to maintain the different version of the Informatica Code and documents.
• Worked with InformaticaData Quality (IDQ) toolkit, Analysis, data cleansing.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.

Environment: Informatica PowerCenter 8.6, Power Exchange, Sub Version, Oracle 10g, SQL, HP Quality Control, Autosys, Unix Shell Scripting, Windows NT, Toad, Flat Files, Address Doctor, Informatica Data Quality(IDQ).

Confidential

Informatica Developer

Responsibilities:

• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart
• Worked on the analysis, design and development to ensure the successful implementation of the data loading processes.
• Set up connection parameters for the source and target using Relational Connections and to hold the path for source and target.
• Involved in analysis and performance of mappings/sessions. Increased performance by tuning the transformations and discussing database issues with the DBA.
• Worked with Data Extraction from Relational DBMS and Flat Files.
• Developed Mappings using Active Transformations such as Aggregator, Filter, Joiner, Router, Sorter, and Union Transformations.
• Also used Passive Transformations such as Expression, Lookup, and Sequence Generator in various mappings.
• Created and used reusable Transformations for easier maintenance of the data.
• Integrated data cleansing processes within the Mappings. Performed debugging of Mappings using the Debugger for failed Mappings.
• Created Workflows and Sessions to carry out loading process into the target.
• Created and used Workflows using different Tasks like Session, Command and Timer.
• Worked with Workflow and Session Log files to troubleshoot the encountered errors.

Environment: Informatica Power Center 8.1, Oracle 10g, Teradata,TOAD, Unix shell scripting.

Confidential

Informatica Developer

Responsibilities:

• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Worked with Data Extraction from Relational DBMS and Flat Files.
• Developed Mappings using Active Transformations such as Aggregator, Filter, Joiner, Router, Sorter, and Union Transformations.
• Also used Passive Transformations such as Expression, Lookup, and Sequence Generator in various mappings.
• Created and used reusable Transformations for easier maintenance of the data.
• Integrated data cleansing processes within the Mappings. Performed debugging of Mappings using the Debugger for failed Mappings.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Testing and maintaining of Informatica Mappings.
• Involved in Integration test cycles.
• Created tables, views, synonyms and sequences. Used SQL Loader for data loading.
• Optimized queries using rule based & cost based approach.

Environment: Informatica Power Center 7.2, Oracle 9i/10g, SQL/PLSQL, TOAD and UNIX.