SUMMARY

• 11 plus years of experience in solving business needs by modeling data warehouse for business intelligence environments using Star and Snow Flake Schema methodology for faster and effective Querying and managing large volumes of data.
• Extensive experience in Informatica Power Center, Informatica MDM, Informatica DVO, Informatica Metadata Manager and Power Exchange.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Experience in Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Implemented Power Exchange CDC Mechanism for Oracle DB and MS SQL Server 2008 r2 Sources.
• Participated in the requirement gathering/ solution architecture for MDM initiatives.
• Having good understanding of Master Data Management (MDM) architectures and business processes
• Experience using Data modeling tools like ERWIN 7.x, Visio. Knowledge in designing and developing Data marts, Data warehouse using dimensional models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in Physical & logical data modeling.
• Worked on Data Cleansing tools like IDQ, PL/SQL coding and Unix/Perl shell scripting for address cleansing, profiling and segmentation of customer data.
• Extensive experience as Informatica Administrator in 8.x and 9.x.
• Expertise in design and development of mappings to handle all types of slowly changing dimensions SCD type 1, type2, type3 and type6.
• Experience using Business Intelligence tools like Business Objects XI R2R1/6.5/6.0, and Brio.
• Experience in transforming data from various types of sources like flat files, Oracle, Teradata, SQL server and XML documents.
• Experience using APIs (Application programming interface) via Informatica Developer Platform (IDP) that allows third parties to build on and extend the PowerCenter platform to connect to new data sources (Like SAP, IBM web servers) and adds custom transformation and functions to the Power Center server.
• Good knowledge in developing complex mappings, mapplets and reusable transformations.
• Experience in CDC techniques in oracle to extract the incremental changes from source systems.
• Working experience in Oracle 11g/10g/9i, PL/SQL Server 2008 R2 and Teradata V12/V13.
• Through knowledge in Teradata architecture, extensively worked on BTEQ, MLOAD, FLOAD, FEXPORT, SQL Assistant to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Experience in Performance tuning of sources, targets, mappings, sessions and sql queries. Worked with Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL *Loader. Extensive Expertise with error handling and Batch processing.
• Strong knowledge of Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall, Agile, and Scrum methodology including Requirement analysis, Design, Development, Testing, Support and Implementation. Provided End User Training and Support.
• Experience with TOAD, SQL Developer and SQL Navigator, Teradata SQL Assistant, SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas. Experienced in Shell scripting and PL/SQL procedures.
• Good experience in preparing Functional Specification Document (FSD) and Detail Design Document (DDD).
• Expertise in performing Unit and Integration testing (UTC).
• Good experience in JIRA tool on agile process.
• Experience in creating tasks, tickets and assign storey points in JIRA tool.
• Good awareness on UNIX Commands and DWH concepts.
• Worked with Autosys in scheduling daily loads, weekly loads, and monthly loads.
• Implemented Integration layer as Data Vault Technique.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Mentors and assists lower level senior developers, business analysts and developers.
• Worked in 24/7 production support of ETL and BI applications for large insurance data warehouses for monitoring, troubleshooting, resolving issues, generating SLA reports. Also worked on administrative tasks of Business Objects XI R2 and Informatica.
• Excellent communication and interpersonal skills, very good team player and self-starter with ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica Power center, Inforamtica Data Quality(IDQ), WhereScape Red, Kalido and Adaptive Warehouse.

MDM Tools: Informatica MDM.

Languages: PL/SQL, UNIX Shell Scripting, Perl Scripting

Database: Oracle, Teradata and SQL Server

Dev. Tools: PL/SQL Developer, Toad, Quality center/Test Director, Jira, WINSCP for Unix.

Operating Systems: UNIX (Aix 5.3), Linux, MS Windows (XP, 2000, NT, 98)

Data Modeling Tool: ERWIN, MS Visio

Scheduling Tools: Autosys, Informatica and DAC.

OLAP Tools: BO and Brio.

Version control: SVN, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Ontario, CA

Informatica Architect/Senior ETL/MDM Developer

Responsibilities:

• Installed Informatica PowerCenter/PowerExchange/Metadata Manager
• Working on Informatica MDM tool.
• Experience in Installing Informatica MDM HUB server/Cleanse Server.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Participated in requirement gathering/solution architecture for MDM initiatives.
• Working on Informatica PowerExchange tool to capture real time transactions to ODS tables with SQL server and Oracle databases.
• Working on 24*7 support for Informatica CDC jobs and PowerCenter jobs.
• Worked on Agile, and Scrum methodology for project execution.
• Strong working experience in Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall, Agile, and Scrum methodology including Requirement analysis, Design, Development, Testing, Support and Implementation.
• Prepared Technical Specification documents (TSD).
• Developing a high level road map for the data quality improvement initiative, aligning data governance deliverables with strategic objectives.
• Finding RCA for production failures and change requests.
• Established best practice and standard for ETL process documents.
• Developed Logical and Physical data models, created the (ER) Entity Relationship diagrams.
• Designed and developed ETL mappings using Informatica Power Center, designed to extract data from Flat files, Excel and transforming it according to the business transformation rule.
• Mentors and assists business analysts and developers.
• Coordinated with the DBA Team, Source systems and offshore for Different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and in identified the bugs, new requirement changes and Data Quality Issue.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.
• Create Dimensional Model (Logical and Physical Model).
• Implemented Auditing and Logging Mechanism.
• Interact with the Subject matter experts and Business users.
• Implemented Power Exchange CDC Mechanism for Oracle DB and MS SQL Server 2008 r2 Sources.
• Configured Listener and Logger and Created Change Registrations.
• Setting up Environment to pull data from various sources.
• Automated the Informatica real time workflows to overcome failures.
• Responsible for preparing ETL Design and Specification for developing Workflow.
• Responsible for Creating Users and Assigning roles.
• Responsible for Migrating code from one environment to other Environments.
• Created Inbound and Outbound Integration's between EBS and other source systems (Oracle EBS, Manhattan, ShotScope, E80 and Logility).

Environment: Informatica PowerCenter 9.x, Informatica PowerExchange 9.x, SQL Server, Oracle, Linux, SVN.

Confidential, Miami, FL

Senior ETL Developer/ Informatica MDM developer

Responsibilities:

• Gathered requirements from business analysts and designed and prepared Functional Specification (FSD) and Detail Design Documents (DDD).
• Worked on Agile, and Scrum methodology for project execution.
• Established best practice and standard for ETL process documents.
• Good understanding on WhareScape RED jobs and involved in migration project.
• Converted WhareScape RED jobs into Informatica PowerCenter mappings.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Performance tuning and optimizing the existing mappings.
• Implemented Integration layer as Data Vault Technique.
• Expertise in Agile process by taking responsible for sprint planning, creating user stories, creating tasks and leading scrum meetings.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Extensively utilized MLOAD, FASTLOAD in Informatica to load data to Teradata.
• Upgraded on informatica 9.0.1 to 9.5.1 version.
• Experience in creating Teradata SET and MULTISET tables, creating views, Indexes, collecting stats on the tables for improving query performances.
• Prepared technical specifications for the development of Informatica (ETL) process to load data into various target tables.
• Finding RCA for production failures and change requests.
• Good experience as Informatica Administrator in 9.x version.
• Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Generated different transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup, Unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Designed the sessions, workflow to execute the mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running the sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning the sessions.
• Involved in data cleansing using IDQ and SQL.
• Participated in error handling and troubleshooting using various log files.
• Wide experience in SDLC and in handling large volume of data.
• Good experience in creating procedures, functions, triggers and cursors using PL/SQL.
• Good experience in SQL server and Teradata V12/V13.
• Improved performance by using Explain plan, creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Handled production support for the monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience with shell scripting and UNIX operating system architecture.
• Environment: Informatica 9.x, SQL Server, Teradata, Windows 2007, SVN.

Confidential, Simsbury, CT

Senior ETL Developer

Responsibilities:

• Gathered requirements from business analysts and designed and prepared Functional Specification (FSD) and Detail Design Documents (DDD).
• Worked on Informatica tool including Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Extensively utilized MLOAD, FASTLOAD in Informatica to load data to Teradata.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Experience in creating Teradata SET and MULTISET tables, creating views, Indexes, collecting stats on the tables for improving query performances.
• Experience in Oracle CDC Technique implementation to extract data from source systems.
• Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.
• Good experience as Informatica Administrator in 8.x version.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Finding RCA for production failures and change requests.
• Created mappings using Mapping Designer to load the data from various sources.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Designed the sessions, workflow to execute the mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running the sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning the sessions.
• Participated in error handling and troubleshooting using various log files.
• Wide experience in SDLC and in handling large volume of data.
• Good experience in creating procedures, functions, triggers and packages using PL/SQL.
• Outstanding experience in Oracle 11g/10g/9i and Teradata V12.
• Improved performance by using Explain plan, creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Handled production support for the monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience with shell scripting and UNIX operating system architecture.

Environment: Informatica V8.x 9.x UNIX, Toad 9.0.1.8, Oracle 11g/10g, Teradata V12, CDC, XML, Flat Files, Autosys, SVN, Shell Scripting, Windows 2000 XP.

Confidential

Senior ETL Developer

Responsibilities:

• Performed business analysis and requirements gathering from high-end users and managers.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specifications to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Handle slowly changing dimension (Types 1, 2, 3) based on the business requirements.
• Implemented best practices such as Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created various mappings using the transformations, reusable transformations and mapplets.
• Used mapping parameters and variables.
• Worked broadly on fixing invalid mappings, testing of stored procedures and functions, unit and integration testing of Informatica sessions and target data.
• Good practical experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions..
• Experienced in scheduling tools like Autosys.
• Good experience in Oracle 11g/10g/9i.
• Responsible in doing data cleansing and data mining.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• PVCS used as version control tool.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, TOAD PL/SQL, Flat files, XML, Oracle 11g/10g, UNIX, PVCS.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of project, including requirement gathering, design, Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Expert in designing ETL architecture, data warehouse builder development guidelines and database standards document.
• Used Informatica for extracting data from heterogeneous source systems.
• Extensively used the components of the Informatica PowerCenter(Source Analyzer, Datawarehouse Designer, Mapping Designer, Mapplet, Transformation, Repository Manager, Workflow Manager, Workflow Monitor)
• Created a repository using Repository Manager. Created folders and users and assigned proper privileges. Managing the repository.
• Formed mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Connected Lookup, Unconnected Lookup, Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Designed and developed complex mappings using various transformations in Designer to load data from Oracle DB.
• Developed mappings, mapplets using Informatica Designer to integrate data from various sources like Oracle, flat files and loaded into target including Teradata, Oracle.
• Created reusable mapplets, transformations and mappings using Informatica Designer.
• Focused on fixed and de-limited flat files, also worked with direct and indirect flat files.
• Implemented sessions, workflows monitored the workflows.
• Identified and troubleshot bottlenecks at various levels like SQL logic, Mappings, and Sessions to enhance the performance.
• Design and development of SQL and stored procedures/functions in Oracle 10g.
• Tuned mappings to achieve faster data loads to the Datawarehouse.
• Used Informatica Debugger to debug the mapping and created breakpoints as needed in order to provide error free mapping.
• Experience in using Automation Scheduling third party tools like Autosys.
• Performed Unit Testing and Integration Testing of mappings and workflows.
• Analyzed performance measures to fit the reporting needs of the company.
• PVCS used as version control tool.

Environment: Informatica Power Center 7.x, Oracle 10g, Flat files, MS Access, PL/SQL, PVCS.