SUMMARY:

• About 7+ years of experience in IT in analysis, design, development of software applications, expertise in Data warehousing solutions using Informatica Power Center, Power Mart, building Data Marts and generating OLAP reports using Business Objects.
• 7 years of experience in ETL mechanisms using Informatica PowerMart&PowerCenter 9.1/8.x/7.x/6x
• 7 years of experience in RDBMS database systems using ORACLE 9i/10g/11g, SQL Server, DB2 in client/server environment.
• Extensive Experience on Oracle database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
• Expertise in maintaining data quality, data organization, metadata and data profiling.
• Experience in Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Connected to ERP applications like SAPR/3, Peoplesoft using PowerConnect
• Experience in using the Informatica command line utility pmcmd to schedule and control sessions and batches.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server etc.
• Proficient in using Informatica Server Manager to create and schedule sessions and batches.
• Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in UNIX shell scripting, automation of ETL processes using Cron tab.
• Extensively used various Performance Tuning techniques to improve the session performance.
• Created tables and views based on the layout sent by Clients.
• Created mapping documents and work flows and data dictionaries
• Strong Analytical skills, excellent communication and interpersonal skills and excellent attention to detail.

TECHNICAL SKILLS:

ETL ToolsInformatica: PowerCenter 9.1/8.6/8.5/8.1/7.1 (Workflow Manager, Workflow Monitor, Repository manager and Informatica Server).

Databases: Oracle 8.x/9i/10g/11g, DB2, MS SQL Server 2000, Sybase, Oracle Express.

Database Utilities: SQL Plus, Oracle DBA Studio, SQL Loader, ODBC, Toad, Erwin, PVCS, Designer 2000 and Discoverer 2000 and MSVisio.

Languages: and PackagesSQL, PL/SQL, Shell Scripting (Csh, Ksh, Bourne), Cobol

Operating Systems: Unix (Sun - Solaris, HP-UX, AIX), Windows 95/98/NT/2000/XP

Testing Tools: Mercury Test Director

Hardware: IBM 3090, IBM ES-9000, Z OS/1.8 IBM Compatibles

Scheduling Tools: Control-M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, NC

Informatica Developer

Responsibilities:

• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Creating and maintaining source-target mapping documents for ETL development team.
• Providing requirement specifications and guide the ETL team for development of the ETL jobs through Informatica ETL tool.
• Develop Mappings and Workflows to generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple Mapplets. Workflows, Tasks, database connections using Workflow Manager.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Prepared ETL mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment.
• Created test data/cases to verify accuracy and completeness of ETL process.
• Proficient with Tools/Utilities such as TOAD, SQL assistants.
• Involved in 24*7 production support for ETL job runs and reporting.
• Strong database experience with strong knowledge of writing complex SQL scripts as well as SQL tuning.
• Involved in Unit Testing, System Testing to check whether the data loads into target are accurate.
• Familiar with usage of tools like QC and JIRA for defect tracking.

Environment:Informatica Power Center 9.1, Unix, Oracle 11g, SQL Server 2005, COBOL, JCL, Flat Files, TOAD, Autosys, SQL Assistant 12.0, Business Objects, Korn Shells, MS Visio, Remedy, Kintana, Data Mover.

Confidential, CT

Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Prepared ETL mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment.
• Created test data/cases to verify accuracy and completeness of ETL process.
• Proficient with Tools/Utilities such as TOAD, SQL assistants.
• Worked on both waterfall model as well as Agile methodology projects.
• Familiar with usage of tools like QC and JIRA for defect tracking.
• Involved in 24*7 production support for ETL job runs and reporting.
• Strong database experience with strong knowledge of writing complex SQL scripts as well as SQL tuning.
• Involved in Unit Testing, System Testing to check whether the data loads into target are accurate.

Environment: Informatica Power Center 9.1, Informatica Power Connect for SAP R/3, Power Analyzer 4.0, ORACLE 9i, Oracle Apps 11.0/10.7, DB2 UDB, HP-UX, Windows NT/2000, TOAD 6.3.11, PVCS 6.7.10, Erwin.

Confidential, TX

Informatica Developer

Responsibilities:

• Designed and created an Autosys job plan to schedule processes.
• Created weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Implemented screen door process for cleaning flat files as per the business requirements.
• Executed Workflows and Sessions using Workflow Monitor.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin
• Extensively worked on Informatica client tools like Designer, Workflow Manager and workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Prepared ETL mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.6 Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: Informatica 9.0, Erwin 7.1, Oracle 11g, PL/SQL developer, SQL*PLUS, SQL, SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML.