SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Telecommunication, Banking, Health care and Pharmaceutical.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Implemented various ETL solutions as per the business requirement using Informatica 9.x/8.x/7.x/6.x.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experienced in designing/developing complex mapping using Informatica transformations.
• Experience in developing strategies for Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica.
• Experienced in integration of various data sources like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, Teradata, XML files, DB2, Sybase, Mainframe COBOL sources into staging area and different target databases.
• Experienced in defining data quality, DataWarehouse, Data Migration and Data Integration, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Extensive Knowledge in creating SCD Type I, Type II mappings. Successfully managed operations on Informatica Enterprise Data Warehouse (EDW) including creation, designing, development, implementation, and testing.
• Experience in integration of various data source definitions like Oracle, Flat Files and XML.
• Experience in creation of S-T mapping with respective to the BRD and in creation of FSD for the developers.
• Experienced in debugging and performance tuning of sources, targets, mappings, and sessions in Informatica.
• Experience in Reporting tools like Business Objects XI R2/XI R3.
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Oracle, DB2, SQL server, VSAM, Sequential Files, Teradata, XML files and SAP) to targets persistent data stores.
• Managed Onsite-offshore model.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit and relationship management skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange, Metadata Manager, IDQ, IDE etc.

Languages: SQL, C, Java

Database: Oracle 11g/10g/9i, DB2, Teradata etc.

Business Intelligence: Business Objects XI R2/XI R3.

Tools: Toad 9.1, SQL Plus, Erwin, Quality Center.

Web Tools: XML, UNIX Shell Scripting

Operating Systems: Microsoft Windows XP/2000, UNIX

Miscellaneous: Rational Rose, Microsoft Office 2010, MS Project, and Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.
• Designed Mapping document, which is a guideline to ETL Coding.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure
• Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations.
• Used Slowly Changing Dimension Mappings of type II and I.
• Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to corporate mergers.
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet the OLAP needs.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Worked on DQ using Data profiling by initially assessing the data to understand its quality challenges.
• Extensively usedSQLandPL/SQLto write Stored Procedures, Functions, Packages and Triggers.
• Used PLSQL developer, TOAD to run SQL queries and validate the data.
• Worked on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
• Developed advanced reports using Report Studio - Using Tabular Objects, Sub reports, Cascading/customizing prompts and cross tabs, list, charts, Drill- through reports.
• Customized data by adding Calculations, Summaries and Functions.
• Experienced in writing complex reporting using sql performance tuning and providing operational support for OLTP and OLAP applications.

Environment: Informatica Power Center 9.5/9.1, Teradata V2R6, Oracle11g/10g, SQL Server 2008, TOAD, Erwin 7.5.2, Business Objects XI, Linux, Windows XP.

Confidential, McLean, VA

ETL Developer

Responsibilities:

• Involved in Requirement Gathering with the business team and in creating ETL design document and technical specifications document for the project. Worked exclusively on Informatica Power Center client tools - Repository Manager, Designer, WorkflowManager& Workflow Monitor.
• Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations)
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Created UNIX shell scripts to invoke the Informatica workflows & Oracle stored procedures
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Teradata using FASTLOAD, TPUMP and MLOAD based on requirements.
• Prompt in responding to business user queries and changes. Designed and Developed mappings in Informatica to load the data from Flat Files, Oracle and MS SQL Server sources.
• Developed several Mapplets by identifying the reusable logic used in various mappings.
• Responsible for developing and re-defining several complex mappings to process various feeds using Informatica transformations like Aggregator, Expression, Lookup, Router, SQL, Sorter and Update Strategy.
• Worked with UNIX shell scripting to implement SQL Loader process in loading flat files to Oracle with proper error logs and also to execute Informatica Workflows. Also, created lot of shell scripts to load various feeds from Flat files to Oracle.
• Troubleshoot and created automatic script/SQL generators.
• Worked on DQ using Data Standardization by business rules engine that ensures that data conforms to quality rules.
• Developed Teradata FLOAD and MLOAD for populating new and already existing Teradata tables.
• Designed Unit test document after the Informatica development and verified results before moving it to QA.
• Used Data warehouse application console (DAC) for deployment and manage data warehouse application that we have deployed.
• Created complex PL/SQL stored procedures and functions. Monitoring the ETL jobs and fixing the Bugs
• Executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it toDataWarehouse.

Environment: Informatica Power Center 9.5/8.6,Oracle 10g, DAC, PL/SQL, TOAD, SQL,UNIX, Erwin 7.1, WINDOWS XP.

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, XML files and Oracle (source) and loaded into Oracle (target).
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Created reusable Mapplets transformations to load data from operational data source to Data Warehouse and involved in Capacity Planning and Storage of data.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Used the Target Load Ordering with Stored Procedures to update database.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica 9.0.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, flat files, Erwin 7.1, Windows XP, Business objects xi, Power Exchange 8.6.1, UNIX.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Normalizer, Update strategy & stored procedure transformation.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Implementation of best practice integration methods based on Informatica framework.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to in corporate them as shortcuts, which would be used in several mappings.
• Scheduled several jobs using Autosys tool, changing job definition & handling scheduling issues.
• Developed processes for automation of loading data to multiple instances using worklets, parameter driven sessions for batch schedule of processes, verification and re-conciliation of data stored in several different source systems.
• Extensively used the capabilities of Power Center such as File List, pm cmd, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
• Worked on SCD Implementation in Data Stage. Created SCD type 1 and Type 2 ETL Informatica mapping using various transformations like Filter, Expression, Router, Update Strategy, Lookups etc.
• Involved in performance tuning the ETL processes. Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target data.
• Documented data conversion, integration, load and verification specifications.
• 24*7 Production Support to fix data quality issues and also supported ETL failures.
• Involved in Performance improvement Issues and also volume testing
• Job scheduling for On-Request Production Jobs

Environment: Informatica Power Center 8.6.1/9.1, Oracle 10g/11g, SQL Server 2008, UNIX, Autosys, TOAD, HP Quality Center, WINDOWS XP.

Confidential

Informatica Developer / Administrator

Responsibilities:

• Involved in design phase of logical and physical data model.
• Involved in designing STAR Schema for the business processes.
• Translated business requirements into Informatica mappings/workflows.
• Extract the data from Oracle, Flat files and loaded them into Data Warehouse.
• Use Source Analyzer and Warehouse designer to import the source and target database schemas.
• Worked on Mapping Designer to map the sources to the target.
• Use Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session logs.
• Interfaced with the support team.
• Defined, implemented and monitored requirements. Performed an upgrade of Informatica Power Center software. Provided technical support for the Informatica environment.
• Conducted research into Informatica related issues.
• Performed Back up/ Recovery of Informatica software.

Environment: Windows XP, Oracle 10g, Informatica Power Center 8.6

Confidential

ETL Consultant

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, DB2 & oracle and load them into Oracle & Teradata.
• Implemented Slowly Changing Dimensions (Type 1 &2).
• Worked on DQ team solving the issues related to Business users. Worked on Data Stage modules.
• Extensively used MLoad, Teradata tool to load the data from Flat Files, DB2 to Teradata.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup,
• Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data warehousing designer, Mapping
• Designer & Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Involved in different Team review meetings related to Data Stage.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Created dimensions and facts in the physical data model.
• Documented user requirements, translated requirements into system solutions and developed.

Environment: Informatica Power Center 8.1, Windows 2000 Server, Oracle 9i, Flat Files.