SUMMARY:

• Around 6+ years of work experience in IT Industry, expertise in Developing DW/BI applications and Master Data Management applications.
• Experience in Base Object, Match Path, and Match columns, Match Rule, logic of Fuzzy match and exact match and Creating and enhancing Trust Rules
• Experience in create an Operational Reference Store (ORS) and configure in MDM Hub Master Database.
• Experience in Installing and Configuring of Informatica MDM Hub Console and Data Director
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules,
• Merge properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server.
• Experience in SQL, PL/SQL and Oracle 12c/11g/10g, SQL Server 2012/2008/2000 Triggers, Views, Indexes and query optimization.
• 2+ years of Professional experience in the space of Informatica ETL in Power Center 10.x,9.x
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, COBAL/VSAM Files, XML(Files),JMS and MSMQ to load into Data Warehouse/Data mart targets
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Extensive experience in Extraction, Transformation and Loading of Data into Enterprise Data Warehouse using Informatica Power Center 10.1,9.x,8.x,7.x versions.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets and reusable transformations
• Worked with DBMS like Oracle 10g, MS SQL Server.
• Experience in Database development skills using Oracle PL/SQL to write stored procedures, functions, packages and triggers.
• Experience in Data Extraction, Data Profiling, Data Cleansing, Data Standardization, Data De-Duplication using Informatica mappings.
• Experience in creating Data Quality dashboards for Data Quality monitoring
• Expertise in Data Quality validation, Data Profiling and Data analysis in Enterprise Data Warehouse environment.
• Experience in Profiling the Data from the current Source systems and identify Data Quality rules for cleansing and standardization.
• Experience in Implementing the Data Quality solution with the appropriate DQ Rules, Metrics and projects.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Having Sound Knowledge of concepts of Data Quality and Information Management and Informatica Active VOS, Root Installation.
• Experience in supporting the business and IT to deliver the ongoing data quality and data governance activities.
• Experience in communicating all the levels within organization to support Data Quality Projects.
• Work exceptionally well in a team or in an individual environment (self-starter) and Ability to learn new technologies and tools quickly.
• Excellent interpersonal and communication skills, customer skills, documentation skills and desire to work in dynamic and challenging environments.

TECHNICAL SKILLS:

MDM Packages: Informatica MDM Multi Domain Edition 10.2 Informatica Data Director (IDD), JBoss Server

ETL Tools: Informatica Power Center 10.1/9.6.1/9.5.1/8.6.1 Informatica MDM

IDQ Packages: Informatica Developer 9.5 and Informatica Analyst

Databases: Oracle 9i/10g, 11g/12c SQL Server 2014, 2012, 2008, 2005

Tools: and Utilities: TOAD 10.1, Text pad, Word Pad, SQL Developer 4.0.3

Environment: Windows 7/XP/2000, UNIX, Windows Server 2003, 2008/Linux

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio, Java Eclipse

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT, Dimensions, Relational Modeling, Physical, Logical Data Modeling, and ER Diagram

PROFESSIONAL EXPERIENCE:

Confidential, LosAngeles,CA

MDM Developer

Responsibilities:

• Designed and created ORS, User Creation, Informatica MDM Database Configuration
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Implemented full fledged IDD and user exists done unit testing.
• Experienced with creation of new ORS in the DEV,QA,PROD Environments.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Experienced in writing test cases for user exists according to the database user exists.
• Involved in testing team for data integrity and consistency.
• 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.
• Worked on Cloud Address doctor IDQ Library utilized latest cloud address doctor functions in mappings.
• Implemented EBF,HF1 implementation in different environments

Environment: Informatica MDM Multi Domain Edition 10.x SQL Developer, TOAD,CA Work Automation, ESP Scheduler Weblogic 12C server, Oracle 10g, DB2, Windows 2000, Linux, and UNIX.

Confidential, Jersey City, NJ

MDM Developer

Responsibilities:

• 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.
• Used latest version of Address Doctor cloud in the mappings and creating IDQ library cleanse functions and utilized DEV,QA,PROD Environments.
• Used ESP scheduler to monitor the jobs daily and helped ETL Support team on daily activities.
• Conducted Knowledge transfer sessions about the project to the team and managed the project by providing reviews on it.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse.
• Established and oversight of data governance, data standards and release policies.
• Worked on Dimensional Data Modeling creating New Models and updates of existing models
• Involved in Analysis by querying to tweak performance of code and output
• Involved in design of double mile stoning of the data in all data marts, which help bank users to provide the data in different snapshots.
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• Worked with Composite tool to provide different data services and web services to other development team.

Environment: Informatica MDM Multi Domain Edition 10.x Informatica Power Center 10.1, 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer),SQL, JBose server, Oracle 10g, DB2, Windows 2000, Linux, and UNIX.

Informatica Developer/MDM

Confidential, Raleigh, NC

Responsibilities:

• Collaborated closely with Business Analyst to understand the business data flow and in gathering requirements
• Configured and installed Informatica MDM Hub server, cleanse server, and Address Doctor5 in Development, QA, Pre-prod and Prod Environments.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, lookups, queries, packages, query groups and custom functions.
• 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.
• Set up match/merge and run match rules to check the effectiveness of MDM process on data.
• 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 Organization, Individual and Products in IDD data tab.
• Implemented the approval process for subject areas in IDD, according to business rules and requirements
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked with different sources such as SQL, Flat files and XML sources.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Involved in business and Architecture discussions.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 10.1 Designer.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse.
• Established and oversight of data governance, data standards and release policies.
• Worked on Dimensional Data Modeling creating New Models and updates of existing models
• Involved in Analysis by querying to tweak performance of code and output
• Involved in design of double mile stoning of the data in all data marts, which help bank users to provide the data in different snapshots.
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• Worked with Composite tool to provide different data services and web services to other development team.
• Worked on ETL workflows to update the new data marts with data from old data marts.
• Defined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities. created JILL scripts for scheduling the jobs run on daily basis and weekly basis. used slack for communication and JIRA for tracking of Ticket status.
• Done UAT testing before moving the code to production
• Developed Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages.
• Runned different kinds of depended jobs in Autosys.

Environment: Informatica MDM 9.x Informatica Power Center 9.6.1/8.1.1 , Power Exchange, Oracle 10g, DB2, Flat Files, XML, Mainframe, PL/SQL, SQL*PLUS, Erwin 7.2, OBIEE, Unix Scripting, Windows NT, TOAD, Autosys, CVS.

Informatica Developer /MDM

Confidential - Chicago, IL

Roles & Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts.
• Reviewing the data model and ETL flow with Modelers & Architects.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development of Informatica Mappings as per the requirement in STM to load data into the Data warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling of Informatica sessions for testing automation of loads.
• Performance tuning of long running jobs in Informatica.
• Updating of ETL Specification, Test Case and Reporting Metadata Documents after testing in various environments (Development, QA and Production)
• Creating the functions and few rules for having a good data quality.
• Extracted the data from the Flat Files, Oracle and My Sql into staging area and populated in to data warehouse which is DB2.
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Migration & Testing of mappings, sessions, worklets and workflows from Informatica 8.6 to Informatica 8.6.1 and make sure all the environment is upgraded properly.
• Done UAT testing before moving the code to production
• Developed Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages.
• Runned different kinds of depended jobs in Autosys.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM
• Worked on data cleansing and standardization using the cleanse functions in

Environment: Informatica Power Center 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer),Informatica MDM 9.x, SQL, Autosys, XML, MS SQL, Oracle 10g, DB2, Windows 2000, Linux, and AIX UNIX

ETL Developer

Confidential

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Created ER Diagram representation including existing source systems by using Ervin Tool.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and
• Integration Testing of Informatica Sessions, Batches and the Target Data.
• Worked on Create, backup, restore for Informatica Repositories.
• Setup and maintain ETL administration best practices and procedures.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitor and tune ETL repository and system for performance improvements
• Performed root cause analysis, performance monitoring and application related issues
• Handled user access/ security role requests for new developers and projects
• Wrote Repository Queries in support of developments and Production statistics
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
• Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
• Developed schedules to automate the update processes and Informatica Sessions/ Batches.

Environment: Informatica Power Center 8/ 7.1, Oracle 9i, TOAD, SQL, PL/SQL, and UNIX

Jr. ETL Developer

Confidential

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.

Environment: Informatica Power Center 8.6.1/9.1.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Windows NT.