SUMMARY

• 7years of IT experience with 5 years of Extensive experience in Master Data Management which includes Analysis, Design, Development and Implementation of EIM solutions using Informatica Master Data Management, Informatica Power Center, PL/SQL, Java .
• Strong background in creating Base objects, Staging tables, foreign key relationships, Mappings, lookups, queries, packages, query groups and custom cleanse functions in Informatica MDM.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Experience in all the phases of Data warehouse life cycle involving requirements gathering/analysis, design, development, validation & testing of Data warehouses using ETL, Data Modelling & Reporting tools.
• Worked on Informatica Identity Resolution product to upgrade from Informatica IIR 9.5 to 10.0
• Good working knowledge in querying Salesforce.com database using SOQL & SOSL queries using Force.com Explorer & Workbench.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Experience Informatica upgrade from V8.6.1 to 9.0.1, 9.1.0 and 9.6.1.
• Proficient in scripting with SQL, PLSQL, UNIX for automation, reporting purposes.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Developed UNIX scripts for dynamic generation of Files & for FTP/SFTP transmission.
• Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB Implementation which included implementing hierarchies, relationship types, packages and profiles by using hierarchies tool in model workbench.
• Proficient in Test execution and Bug tracking.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre - prod and production environments.
• Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, Confluence & HP-ALM to track the progress of projects.

TECHNICAL SKILLS

Software: Informatica 9/8.6 Power Center (Source Analyzer, Data warehouse, designer, Mapping Designer, Mapplets, Transformations). SQL, PL/SQL, HTML, XML, UNIX Shell Script, Putty, JCL, COBOL, DB2. Web Services, Java, JavaScript, CSS, HTML, XML, SOAP. MS Office, Eclipse IDE, Policy Admin System. TOAD, SQL Developer, PL/SQL, SQL, PL/SQL, UNIX Shell Scripts, JCL, REXX, Easytrieve. TOAD, SQL Developer, SQL Plus Application Servers Jboss, Web logic 10.3.5, Websphere 7.x,8.5.5.x,Packages MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio)

Database: Oracle 11g/10g, MS SQL Server MS Access 5.0, My SQL, DB2 9.0.

Data Modeling tools: Oracle Toad Data Modeler

Scheduling Tools: ESP Scheduler, Control - M

Operating Systems: Windows UNIX, IBM z/OS.

PROFESSIONAL EXPERIENCE

Informatica MDM Developer

Confidential

Responsibilities:

• We use Informatica 9.6.1 to load the data from Legacy tables to Netezza tables.
• Worked on TIBCO (Enterprise application integration (EAI) technologies) as middleware with SIF.
• Used the access protocols SOAP, to communicate with the MDM Hub. Worked on Data Integration using Informatica Power center Data Integration Platform.
• All the tasks had been assigned in the form of tickets and used JIRA to track them.
• Demonstrated hands-on experience of Informatica MDM including batch and real-time processing.
• Attended all the business requirement consist of all the data flow form source to target.
• Ability to Design, document data content, relationships, structure and flow, processes that manage, transform data, business rules that govern data and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data
• Used Hue version- 2.6.1-2 Web interface to query the data.
• Wrote complex SQL overrides to join heterogenous databases.
• Involved with team to upgrade Informatica MDM from 9.6 to 9.7 and 9.7 to 10.
• Worked on Writing and tuning complex SQL queries and shell scripts.
• Strongexpertiseininstallingandconfiguringthecore Informatica MDM components

Environment: Informatica 9.6.1, HUE-2.6.1-2, Aginity AMP, Hive, Oracle, Netezza, Autosys, JIRA. Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad

ETL/Informatica MDM developer

Confidential

Responsibilities:

• Prepared all the designing documents consist of Data flow from Source to Target by mapping all the columns, which are required for reporting purpose.
• Provided MDM Technical consultancy in resolving MDM technical architecture issues and functional issues in the existing MDM environment.
• Handled the complex mappings by modifying some of the core tables which consist of Pet Smart customer data and also the sales tables that are involved in Batch load.
• Automated the MDM operation jobs and resolving all the existing MDM batch process issues and bottlenecks.
• Designed and developed new solutions in the existing MDM environment with new match rules and trust settings modifications to optimize reports.
• Involved in Creating hub design document for Informatica MDM 9.7.1 for POC considering
• MDM Hub Configuration Development: Created BO, Stage and Landing tables, setting up relationships, Match Path configuration as per the data model.
• Automated the MDM operation jobs and resolving all the existing MDM batch process issues and bottlenecks.

Environment: Informatica 9.1/9.5, SQL Server, Oracle, Netezza, Tidal and JIRA.Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad

ETL/Informatica MDM Developer

Confidential

Responsibilities:

• ETL / Data Warehouse experience, preferably with SQL Server/TSQL.
• Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Doctor Informatica Power Center applications
• Excellent knowledge on Informatica Power Center development.
• Master Data Management MDM Data Integration concepts in large scale implementation environments
• Created various shell scripts using UNIX.
• Worked on SQL server, Oracle, Sybase databases.
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS
• Used UNIX scripts for scheduling and executing Informatica workflows.
• Worked on scheduler tools like Autosys and Control-M.
• Working with informatica MDM mappings, work flows and dataflows and interacting with hadoop hive.
• Created UNIX scripts for FTP and SFTP files to different servers.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.

Environment: Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad

Informatica Consultant

Confidential, Bentonville, AR

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica- Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Produced detailed MDM design specifications consistent with the high-level MDM design specifications.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Developed extensions and customizations to the services (SIF) tier of Informatica MDM Hub.
• Worked along with the Informatica professional to resolved Informatica upgrade issue.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing of data.
• Closely worked with Data Steward Team for designing, documenting and configuring InformaticaData Director for supporting management of MDM data.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

Environment: Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad

Informatica Developer

Confidential, Woonsocket, RI

Responsibilities:

• Involved in gathering requirements from end users and involved in modifying data according to the requirement.
• Worked with the end users to identify, create, and deliver reports according to requirements.
• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.
• Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
• Created Data models for data warehouse development.
• Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Worked with UNIX scripts for automation of ETL Jobs using Control-M Scheduler and Involved in migration/ conversion of ETL processes from development to production environment.
• Working experience using Push Down Optimization.
• Did performance tune of Informatica components for daily and monthly incremental loading.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad