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 wif 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 teh 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 teh 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) dat allows third parties to build on and extend teh PowerCenter platform to connect to new data sources (Like SAP, IBM web servers) and adds custom transformation and functions to teh Power Center server.
• Good noledge in developing complex mappings, mapplets and reusable transformations.
• Experience in CDC techniques in oracle to extract teh incremental changes from source systems.
• Working experience in Oracle 11g/10g/9i, PL/SQL Server 2008 R2 and Teradata V12/V13.
• Through noledge 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 wif Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL *Loader. Extensive Expertise wif error handling and Batch processing.
• Strong noledge of Software Development Life Cycle (SDLC) wif 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 wif 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 wif 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 wif 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 wif MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Design, document and configure teh 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 wif 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) wif 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 teh data quality improvement initiative, aligning data governance deliverables wif 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 teh (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 teh business transformation rule.
• Mentors and assists business analysts and developers.
• Coordinated wif teh 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 teh bugs, new requirement changes and Data Quality Issue.
• Prepared Test preparation and execution plans for different entities and executed teh testing wif team and Involved in Integration testing.
• Create Dimensional Model (Logical and Physical Model).
• Implemented Auditing and Logging Mechanism.
• Interact wif teh 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 teh 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:

• Gatheird 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 wif MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Design, document and configure teh Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Performance tuning and optimizing teh 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 teh tables for improving query performances.
• Prepared technical specifications for teh 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 teh Designer for data load and data cleansing.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Generated different transformations for loading teh 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 teh sessions, workflow to execute teh mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running teh sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning teh 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 teh monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience wif shell scripting and UNIX operating system architecture.
• Environment: Informatica 9.x, SQL Server, Teradata, Windows 2007, SVN.

Confidential, Simsbury, CT

Senior ETL Developer

Responsibilities:

• Gatheird 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 teh 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 teh 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 teh 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 teh sessions, workflow to execute teh mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running teh sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning teh 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 teh monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience wif 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 teh 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 teh data warehousing data marts in Star join schema.
• Handle slowly changing dimension (Types 1, 2, 3) based on teh business requirements.
• Implemented best practices such as Memory cache for static and dynamic cache for teh better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created various mappings using teh 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 teh components of teh 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 teh repository.
• Formed mappings using Mapping Designer to load teh 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 wif direct and indirect flat files.
• Implemented sessions, workflows monitored teh workflows.
• Identified and troubleshot bottlenecks at various levels like SQL logic, Mappings, and Sessions to enhance teh performance.
• Design and development of SQL and stored procedures/functions in Oracle 10g.
• Tuned mappings to achieve faster data loads to teh Datawarehouse.
• Used Informatica Debugger to debug teh 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 teh reporting needs of teh company.
• PVCS used as version control tool.

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