PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in system analysis, design, development of software applications and experience in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses and data mart.
• Design, develop and implement data models with quality and integrity at the top of mind to support our products
• Develop software utilizing open source technologies to interface distributed and relational data solutions.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Expertise in Master Data Management Concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in data warehousing and modeling techniques and procedures
• Experience in Data Warehouse Engineer for all ETL and Data Warehouse systems and databases for VIP. Provide analysis, design, development, review, validation and code review for all Informatica and Oracle project.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
• Develop, optimize, and tune Informatica in support of application in an Oracle enterprise database environment
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Strong knowledge and Experience in using Informatica Power Center ETL tool, Data quality management and Data quality check methodology, Business Experience .
• Experience in using Informatica Power Center 9.5/9.1/8.5/7.1 .
• Hands on experience in TPT,MLOAD, FLOAD and FASTEXPORT
• Good knowledge of object - oriented programming.
• Experience in Teradata, Data Integration and Data Modeling.
• Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic
• Extensive database experience and highly skilled in SQL, Oracle, MS SQL Server, DB2, Sybase, Mainframe Files, Flat Files, MS Access.
• Skilled in SQL, Oracle SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant, development of Stored procedures, Triggers, PL/SQL packages.
• Proven ability to work efficiently in both independent & collaborative environments with Excellent interpersonal and communication skills.
• Innovative thinking and strong problem solving and analytical capabilities
• Strong understanding of Software Development Life Cycle as well as Software Testing Life Cycle.
• Responsible for defect tracking, defect reporting and defect reproducing.
• Knowledge in Full Life Cycle development of Data Warehousing.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter5.x/6.x/7.x/8.x/9.x/10.1 Power Connects and Informatica Cloud

OLAP/DSS Tools: Business Objects 6.0

Database Modeling: Erwin 4.0/4.1

Databases: Oracle7.x/8.x/9.x/10g,SQLServer 7.0/2000/2003, Multi-Dimensional (OLAP), SFDC, DB2, Teradata 13.1.

Languages: SQL, PL/SQL

DB Tools: SQL* Plus, SQL* Loader, SQL*Forms

OS: MS-DOS 6.1, MS-WINDOWS 95/98/XP,UNIX,LINUX

PROFESSIONAL EXPERIENCE:

Confidential - New York City, NY

Sr. Informatica ETL Developer

Responsibilities:

• Involved in Designing and developing multi-dimensional model (Star Schema) using Erwin.
• Scheduling meetings with the business users to gather the business analysis reporting requirements.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Worked with Master Data Management (MDM) team to load data from external source systems to MDM hub.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Developed Mappings and reusable Transformations and Mapplets.
• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud
• Extensively worked with Informatica Transformations and also Override SQL using Oracle Functions.
• Informatica Server Manager used to create database connections, sessions, and batches to run the mappings.
• Various Performance and Tuning techniques used to improve the load.
• Involved in writing of Triggers, Functions, and Packages.
• Convert specifications to programs and data mapping in an ETL Informatica Cloud environment
• Provide High Level and Low Level Architecture Solution/Design as needed
• Dig deep into complex T-SQL Query and Stored Procedure to identify items that could be converted to Informatica Cloud ISD
• Develop reusable integration components, transformation, logging processes.
• Support system and user acceptance testing activities, including issue resolution.
• Responsible for to provide production support and resolve issues.

Environment: Oracle9i, Informatica Cloud, T SQL, MDM,Stored Procedure, Informatica Power center 9.1/9.5/10.1, SQL loader, UNIX Shell Scripting .

Confidential - Santa Clara, CA

Sr. Informatica ETL Developer

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle. Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Worked closely with project management and assisted in ensuring timely and effective implementation.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements
• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into teradata and DB2 databases.

Environment: Informatica Power center 9.1/9.5-HotFix 4, Oracle, Teradata 13.1, UNIX, Windows NT.

Confidential - Owings mills, MD

Sr. Informatica ETL Developer

Responsibilities:

• Extracted data from various data sources such as Flat file, DB2 and transformed and loaded into targets using Informatica.
• Development of mappings, sessions and workflows for relational, application and flat file sources and targets.
• Extensive use of various ETL transformations like Router, Filter, Joiner, Aggregator, Lookup, Update Strategy, Sequence Generator, Sorter and Stored procedure.
• Performance tuning for mapping and executing/scheduling workflows using workflow manager and workflow monitor.
• Requirements gathering, data analysis, MDM data modeling with ER/Studio 9.6 conceptual, logical, physical
• Designing a data governance policy and procedures.
• MDM PIM Product Master, CDI Customer Master architecture design and implementation.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several Mapplets and worklets for reusability.
• Developed unit test cases and did unit testing for all the developed mappings.
• Provided support for slowly changing dimensions in data marts
• Implemented data profiling and quality check in Data Manager
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 9.5, Oracle, Oracle Golden Gate CDC, Teradata 13.1, MDM 11.0, UNIX

Confidential - New York, NY

Informatica ETL Developer

Responsibilities:

• Configured Informatica Repository Manager to manage all the repositories of various applications. Created users, user groups, security access controls.
• Planned and designed the flow process of the data stored in the repository, in the form of metadata.
• Designed and constructed the Star Schema. Wrote procedures, functions in PL/SQL.
• Designed and created mappings using Mapping Designer.
• Worked extensively on performance tuning by making changes to SQL in Source Analyzer.
• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Designed and developed catalogs by creating links between the Fact table and the Dimension table to form a Star Schema.
• Used TOAD to FTP file moving processes to and from source systems.
• Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Doctor Informatica Power Center applications
• All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing
• Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
• Wrote shell scripts to join or concat target files, to delete or remove one or more such files if not needed after joining, and etc.
• Monitored the production loads and fixed them, when necessary.
• Involved in the Performance Tuning of Informatica servers and other legacy databases.

Environment: Informatica 7.1/8.6, Oracle 9i/10g, PL/SQL, MDM 11.0, UNIX Shell Scripting, TOAD 8.5.

Confidential

Informatica ETL Developer

Responsibilities:

• Solely involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Client Specifications, Development and Deployment of the Application.
• Developed web pages and validated these pages using ASP.NET and C#.
• ASP.NET web application and .NET components hosted in Windows 2000.
• Modified existing mappings and developed new ETL Mappings, Reusable and Non-Reusable Sessions, and Workflows using Informatica PowerCenter 8.6.
• Worked extensively with Star Schema Dimensional model, Flat Files source feeds in extraction of data from source systems.
• Worked with most of the transformations such as Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, etc.
• Designed and developed ETL Mappings to extract data from flat files, Oracle database to load the data into Teradata database.
• Experience in Performance Tuning of Informatica (sources, targets, mappings and sessions) .
• Performed end-to-end Unit Testing of ETL mappings and created Unit Test Cases report.
• Studied the handbook of standards and documented standards for Informatica code development.

Environment: Informatica PowerCenter 9.1, Oracle 10g, Flat Files, Nexus Query Chameleon, Teradata, SQL Developer, SQL Assistant, UNIX.

Confidential

Informatica ETL Developer

Responsibilities:

• Extensively involved in business requirements gathering.
• Involved in design sessions to translate user requirements to technical specs.
• Designed and developed complex Informatica mappings in conjuction with Unix scripts to load source data into Data Warehouse by applying business logic.
• Used most of the informatica provided functionalities (Transformations: Expression, Aggregator, Filter, Router, Sorter, Lookup, Stored procedure, Normalizer etc.…. other objects like Mapplets, Pre-Sql, Post-Sql, Pre-Session, Post-Session) to create complex process to meet the business requirements.
• Built complex processes to load inconsistent data from flat files.
• Designed and Developed complex process for reporting on all source files received from various vendors.
• Developed complex regexp in informatica to validate email address.
• Automated existing Informatica workflows to run every day in UNIX.
• Worked extensively with Netezza procedures & SQL.
• Created and executed queries on repository to report on the Informatica objects.

Environment: Informatica Power Center 9.1.0, DB2, Netezza 5.0/6.0, Oracle10g/11g, AIX, WinSQL Professional