SUMMARY

• Informatica Certified MDM Hub and ETL Developer with 8 + years of IT experience in Design, Development, Implementation and Maintenance of EIM solutions using Informatica MDM Hub and Data warehouse applications as an ETL Lead Developer.
• Proficient in the development of solutions using Informatica MDM Hub.
• Experienced in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experienced in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups and packages
• Proficient in the development of solutions using Informatica (Siperian) MDM Hub
• Configured Informatica Data Director (IDD) for Data Governance to be used by the Business users, IT Managers and Data Stewards.
• Good knowledge in profiling data using Informatica Analyst tool.
• Address data cleansing using Informatica Address Doctor to discover deliverable personal and business addresses.
• Good understanding on Informatica Data Quality concepts like Cleansing, Standardization, Parsing.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 9.x/8.x.
• Strong Data warehousing ETL experience in Informatica power center client tools(Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange
• Good in data warehouse concepts/data warehouse architecture and best practices.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Worklet & Workflow Designer.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations and business rules.
• Good Knowledge in Control-M Enterprise Manager, Data warehouse Administrative console (OBIEE) and crontab schedulers.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Team player and self-starter, capable of working independently and motivate a team of professionals.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi domain Edition, Siperian Master Reference Management XU, IDD

Data warehousing Tools: Informatica Power Center 9.x/8.x,Power Exchange 9.x/8.x,Informatica Analyst, Informatica Data Quality 9.x,SAS,OBIEE 10.1.3.3.1 , Datawarehouse Administration Console.

Operating Systems: UNIX, LINUX, Windows NT/ 98/2000/2003

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/2005 Microsoft Access.

Programming: SQL, Batch scripts,C

Job Scheduling: Control-M Enterprise manager, Data warehouse Administration Console(OBIEE), crontab, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, MD

Informatica MDM Hub Consultant

Responsibilities:

• Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Analyzed the CSIS source systems for erroneous, duplicate, and integrity issues related to the data.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Worked with various developer modules like profiling, standardization and matching.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Integration of Data quality mapplets with power center mappings.
• Prepared Data Quality standardization & cleansing rules in IDQ using the facts discovered from profile results.
• Performed Data Quality Checks, Cleansed the incoming data feeds as and profiled the source systems data as per business rules using IDQ.

Environment: Informatica MDM 9.7.0, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor 5, IDD, Windows server 2003, Unix.

Confidential, Atlanta, GA

Informatica MDM Hub Consultant

Responsibilities:

• Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs.
• Configured and installed Informatica MDM Hub server, Cleanse, resource kit, and Address Doctor
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for Dealer, Dealer Group, OEM, AD-Agency, Rental Car Company, Nameplate, Worker subject areas in IDD data tab.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM 9.1.0, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor 5, IDD, Windows server 2003, Unix.

Confidential, Woonsocket, RI

ETL Lead Developer

Responsibilities:

• Gathering the Information from Source systems, Business documents and prepares the Data Conversion and migration technical design documents.
• Involved with business users to get Business requirements and analysis of the source systems data.
• Extensively worked with off-shore team members in Developing ETL-Informatica coding.
• Created Technical mapping design documents and field-field level mapping spread sheet documents.
• Prepared and reviews the Technical design documents.
• Working with clients on Design, Development and walkthroughs.
• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Created Informatica Mappings, Sessions and Workflows as per technical design specifications.
• Creating Informatica mappings with transformations like Source Qualifier, Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator, etc.
• Worked with Different data transformations like Aggregate, Data conversion, Derived Columns, Union All, Sort, and Merge joins, look up etc.
• Perform data population tests against target system to ensure accuracy and quality of data.
• Perform UNIT testing on deliverables and documenting.
• Identifying source data quality issues and resolves discrepancies.
• Tuning the ETL-Informatica code in Mapping level and session level.
• Migrating the all UNIX shell scripts, Parameter files, and Env files thru SVN Version to various Environments.
• Order the Control-M jobs from Desktop to Enterprise Manager and automated the ETL Jobs.
• Migrating the ETL- Workflows, Mappings and sessions to QA and Production environment.

Environment: Informatica 9.0.1,Informatica Power Exchange, Oracle 10g, PL/SQL,TOAD,SVN Tortoise, Control-M Desktop/Enterprise Manager, MS Visio 2003.

Confidential, Woonsocket, RI

ETL Lead Developer

Responsibilities:

• Gathering the Information from Source systems, Business documents and prepares the Data Conversion and migration technical design documents.
• Involved with business users to get Business requirements and analysis of the source systems data.
• Extensively worked with off-shore team members in Developing ETL-Informatica coding.
• Created high level and low level mapping design documents and field-field level mapping spread sheet documents.
• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Created Informatica Mappings, Sessions and Workflows as per technical design specifications.
• Creating Informatica mappings with transformations like Source Qualifier, Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator, etc.
• Worked with Different data transformations like Aggregate, Data conversion, Derived Columns, Union All, Sort, and Merge joins, look up etc.
• Perform data population tests against target system to ensure accuracy and quality of data.
• Perform UNIT testing on deliverables and documenting.
• Identifying source data quality issues and resolves discrepancies.
• Tuning the ETL-Informatica code in Mapping level and session level.
• Implementing Error Handling functionality and Auto E-Mail notifications.
• Migrating the all UNIX shell scripts, Parameter files, and Env files thru SVN Version to various Environments.
• Order the Control-M jobs from Desktop to Enterprise Manager and automated the ETL Jobs.
• Migrating the ETL- Workflows, Mappings and sessions to QA and Production environment.

Environment: Informatica 9.x,Informatica Power Exchange, Oracle 10g database, PL/SQL,TOAD,SVN Tortoise, Control-M Desktop/Enterprise Manager, MS Visio 2003.

Confidential, Woonsocket, RI

ETL Lead Developer

Responsibilities:

• Involved in data discovery sessions with business users to get Business requirements and analysis of the source systems data.
• Extensively worked with off-shore team members in Developing ETL-Informatica coding.
• Created high level and low level mapping design documents and field-field level mapping spread sheet documents.
• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Created Informatica mappings with transformations like Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator, etc.
• Created the mappings, sessions and workflows as per design documents.
• Tuning the ETL-Informatica code in Mapping level, and session level.
• Involved in migrated the dev objects from Dev Repository to Test repository.
• Created Unit test case documents and prepared the Unit test logs.
• Migrated the all Unix shell scripts, Parameter files, and Env files thru SVN Tortoise Sub version to different environments.
• Order the Control-M jobs from Desktop to Enterprise Manager and automated the ETL Jobs.
• Involving in Production support rotation basis (24*7).
• Involving in Status Reporting to the Customer and Management

Environment: Informatica 8.6,Informatica ILM tool, Informatica Power exchange, IBM UNIX, Windows XP, Control-M Desktop/Enterprise Manager, MS Visio 2003.

Confidential, Woonsocket, RI

ETL Module Leader

Responsibilities:

• Business requirements gathering and analysis of the source systems data.
• Completed documentation in relation to detailed work plans, mapping documents and high-level, low level design documents.
• Coordinate with On-shore team and developed the ETL - Informatica Mappings.
• Involved in Logical Data Modeling and Physical Data Modeling.
• Monitoring Production system jobs and controlling online and Batch jobs.
• Attending the calls with Business and other technical groups to resolve the production issues.
• Developed the ETL - Informatica Mappings and workflows.
• Worked on the transformations like Lookup, Aggregator, Expression, Filter, Router, Update Strategy, and Sequence Generator.
• Created and ran pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in Designer.
• Developed the Unix shell Scripts to start the Informatica Workflows.
• Create the Control-M jobs to automate the ETL process.
• Tuning the ETL-Informatica code in Mapping level, and session level.
• Prepare the Unit test case documents and done the Unit testing.
• Involved in Integration testing and system testing.
• Migrated the all UNIX shell scripts, Parameter files, and Env files thru Svn Subversion to different environments.
• Order the Control-M jobs from Desktop to Enterprise Manager and automated the ETL Jobs.
• Migrated the ETL- Workflows, Mappings and sessions to test server.
• Involved in re-view of ETL - Code, design documents and Mapping documents.
• Involved in production Support(24*7) for the DWH applications.

Environment: Informatica 8.1.1,8.1.6, Unix Sun OS 5,Oracle 10g database, Windows XP, Serena Changeman Version Management Workstation, CONTROL-M/Enterprise Manager, MS Visio 2003.

Confidential

ETL Module Leader

Responsibilities:

• Requirement gathering, impact analysis, design, estimation & planning of CRs and bug fixes.
• Created / Updated the ETL Technical Documentations on Clients Repository share points Portals.
• Review of the design specs, ETL mappings, DAC configuration.
• Solving of adhoc requests, responding to the queries from the CCCP users.
• Attending regular meetings with the client to discuss the status of critical support issues.
• Resolved the most critical issues related to data security which stabilized the CCCP reporting application.
• Creation of report mockups, OBI reports, prompts, filters, pages & dashboards and unit testing of reports.
• Used the OBI Admin Tool for addition of new columns to the facts & dimensions to be displayed in the subject area in OBI Answers.
• Migrating ETL mappings, RPD & Webcat from DEV to IT, QA & PROD environments.
• Ensure compliance to timesheets and generate project related reports using IPMS.
• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Successfully moved the Sessions and Batches from the Development environment to Production environment.
• Involved in modify the Batch scheduling Job files, Parameter files.

Environment: Oracle 10g database, Informatica Power Center 8.1.6, Data warehouse Administration Console, Oracle Business Intelligence 10.1.3, UNIX, TOAD, MS-Excel 2003.

Confidential

ETL Developer

Responsibilities:

• Preparing System Design Documents for the jobs based on the Data Model.
• Development / Construction of ETL jobs according to the system design document.
• Creating sequences to schedule the data stage jobs
• Creating jobs for Data Standardization and cleansing through DS Quality stage (Parallel Edition).
• Take care of the batch related to ETL part of DWH and Production support during Turnover duration to Support team.
• Implementing in phases, new applications driven by business requirements, integrating it with the existing applications and also the development of new enhancements.
• Unit/Integration/System Testing of the components and document the test results.
• Resolve production issues, troubleshooting and providing permanent fixes.
• Created the Unit Test Plans and did Unit Testing, Prepare the Unit Test logs.

Environment: IBM-Ascential Data stage Server Version 7.5.1, IBM Ascential Data stage Parallel Edition Version 8.0 (Quality Stage), Teradata 6.0, Oracle 10g, Micro strategy 8.0.1.

Confidential

Production Support Executive

Responsibilities:

• Handled several planned/ unplanned downtime
• Created several workarounds during application issues and when core business functionality is affected.
• Identified performance bottlenecks and provided performance tuning of various Informatica sessions.
• Solving of adhoc requests, responding to the queries from SWA users.
• Monitoring the Remedy ticketing tool.
• Monitoring the Informatica jobs through Informatica monitor.
• Resolving the user queries within the SLA limit.
• Prepared several Standard operational procedures to make the application stabilized.

Environment: SAS, Informatica 8.1.1, UNIX Sun Solaris 10, Oracle 9i database, TOAD, SAS Enterprise Guide.

Confidential

Production Support Executive

Responsibilities:

• Handled several planned/ unplanned downtime
• Created several workarounds during application issues and when core business functionality is affected.
• Identified performance bottlenecks and provided performance tuning of various Informatica sessions.
• Solving of adhoc requests, responding to the queries from SWA users.
• Monitoring the Remedy ticketing tool.
• Monitoring the Informatica jobs through Informatica monitor.
• Resolving the user queries within the SLA limit.
• Prepared several Standard operational procedures to make the application stabilized.

Environment: SAS, Informatica 7.1.4, UNIX Sun Solaris 10, Oracle 9i database, TOAD, SAS Enterprise Guide.