SUMMARY

• Around 4 years of experience in the IT industry with skills in analysis, design, development and implementation of various projects using Object Oriented and Multidimensional Analysis, Design, Development and Implementation Methodologies.
• 2 plus years of experience in Data warehousing, Data Architecture &Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.x/8.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer and Mapping Designer), MDM, Power Connect, Power Exchange OLTP, OLAP, Data Reports, AutoSys, Control M.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, VSAM, IBM DB2 UDB, Excel, Oracle, Sybase, MS SQL Server, Teradata and Netezza.
• Experience in Business Intelligence tools like Business Objects 4.x, Web Intelligence 2.5, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Object Universe Developer, Business Objects Set Analyzer 2.0, Business Objects Reporting and Oracle OBIEE 10g 10.1.3.4.1/11 g.
• 3 years of experience using Oracle 11g/10g SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 UDB 8.0, Teradata 13, MS Access 2000, Windows 95/98/2000/XP, Win NT 4.0.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, web services, SQL, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Key generation etc.
• Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings.
• Experienced in loader utilities including SQL Loader and Teradata TPump, Fast Load and MultiLoad. Experienced in PL/SQL scripts and extensively used SQL concept. Experienced in UNIX shell scripting and VI Editor Usage.
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
• Extensively involved in creating test scripts, collaborating with users on test scripts in HPQC. Involved in testing reporting applications and back end via HPQC.
• Team player who can work on aggressive timelines and deliver projects on time per the requirements.
• Dedicated professional with strong technical, analytical, oral, problem solving, written skills and a committed team player, always involving in performance tuning of Informatica mappings and sessions.

TECHNICAL SKILLS

ETL: Informatica Power Center 8.x/9.x, & Informatica Data Explorer (IDE).

Scheduling Tools: AutoSys, ControlM

Reporting Tools: Business Objects 4.0, OBIEE 10g (10.1.3.4.1 )/11g

Databases: Netezza 7.1, Oracle11g/10g, MS SQL Server 2005, IBM DB2 UDB 8.0/7.0, Teradata

Operating Systems: Windows 07/XP/Vista/95/98, UNIX

Programming: SQL, PL/SQL, Matlab, HTML, XML, DHTML

Other Tools: SQL*Loader, SQL*Plus, TOAD v11.X/v12.0, Oracle SQL Developer, MS Visio

Scripting Languages: UNIX Shell Scripting

Methodologies: E - R Modeling, Star Schema, Snowflake Schema

Data Modeling Tool: Erwin 9.x

PROFESSIONAL EXPERIENCE

Confidential - Piscataway, NJ

Informatica Developer

Responsibilities:

• Requirement Gathering and Data Analysis of all supporting systems. Designed Informatica mappings and data flows.
• Understand Business Requirements and translate into Technical Specifications.
• Implemented ABC (Audit Balance & Control) metrics to capture record counts, session and workflow stats into database tables.
• Used MDM to perform match and merge rules to create golden records for the clients.
• Developed Informatica processes to facilitate Daily, Weekly and monthly loading of data.
• Maintained staging area between source and target, performed all cleansing operations, aggregations etc.
• Developed complex mappings using Lookup, SQL, Stored Procedure, and Filter while always striving to achieve the best performance.
• Used Debugger wizard to troubleshoot data and error conditions.
• Reviewed multiple data source systems, performed data profiling using IDE/IDQ and recommended data acquisition and transformation strategy.
• Developed an ETL strategy to integrate disparate legacy sources to eliminate redundancy and create a single view of the Customer data for accurate business analysis.
• Using Informatica Power Center created mappings, sessions and workflows to load data from multiple Source databases and flat files into target Oracle.
• Used Parameters, Variables and Parameter Files for various Database Relational Connections to eliminate migration issues.
• Extensively worked on all the transformations like Filter, SQL, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Used different transformations for Extraction/Transformation, data cleansing and loading data into staging areas and Presentation Tables.
• Implemented Slowly Changing Dimensions Type1, Type 2.
• Worked with various look-up caches.
• Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.
• Worked with connected and unconnected look-up for implementing complex logic.
• Designing ETL strategy for both Initial and Incremental & CDC Loads.
• Developed unit test cases and ensured that the results are right before moving to QA and Production.
• Worked with QA team on daily basis to follow up on the bugs and made sure the code is bug free before migrating to Production.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, Netezza 7.1, PL/SQL, UNIX, Shell Scripting, XML, Erwin r9.5.2/9.6, TOAD v12.0.

Confidential

Jr ETL Developer

Responsibilities:

• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files to Oracle.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• Worked extensively onSQL, PL/SQLand UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Designed and developed the fact/dimension entities.
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs.
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Worked on new data model to form the single security master for all the Data Marts and retrofit the existing and new securities in the FACT tables.
• Designed and developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked as a fully contributing team member with independent planning & execution responsibilities.

Environment: Informatica Power center 8x, Netezza 7.1, Oracle 10g, SQL, PLSQL, OracleSQLDeveloper, HP Quality center, MS Office, Oracle OBIEE 10g 10.1.3.4.1/11 g, and Linux.

Confidential

Jr Informatica Developer

Responsibilities:

• Translated business requirements into data warehouse design.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin
• Used Star Schema approach for designing of Data Warehouse.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle, SQL Server, MS-Access and Loaded data into Oracle database using Informatica.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 9.5.1/9.1.1 , Business Objects, UNIX, SQL, PL/SQL, TOAD v11.6/v12.0, Oracle 11g/10g.