SUMMARY

• Around 7 + years of work experience in IT Industry, expertise in Developing DW/BI applications and Master Data Management applications.
• Around 4+ years of Professional experience in Designing Developing Informatica MDM solutions
• 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 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
• Expertisein 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
• 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 9.7 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

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.
• 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.
• Helped the 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
• 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.
• 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 & optimizingETLprocesses 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 InformaticaPower Center 10.1, 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and TransformationDeveloper),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 usingInformaticaPower Center 10.1 Designer.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizingETLprocesses 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 onETLworkflows 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 InformaticaPower 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

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts.
• Reviewing the data model andETLflow with Modelers & Architects.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development ofInformaticaMappings as per the requirement in STM to load data into the Data warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling ofInformaticasessions for testing automation of loads.
• Performance tuning of long running jobs inInformatica.
• Updating ofETLSpecification, 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 andInformaticasessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• UsedInformaticaPower 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 fromInformatica8.6 toInformatica8.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 intoInformatica MDM
• Worked on data cleansing and standardization using the cleanse functions in

Environment: InformaticaPower Center 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and TransformationDeveloper),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 usingInformaticaPower Center Designer.
• Developed number of ComplexInformaticaMappings, 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 ofInformaticaSessions, Batches and the Target Data.
• Worked on Create, backup, restore forInformaticaRepositories.
• Setup and maintainETLadministration best practices and procedures.
• Maintain all necessary updates and/or patches for theETLenvironments.
• Monitor and tuneETLrepository and system for performance improvements
• Performed root cause analysis, performance monitoring and application related issues
• Handled user access/ security role requests for newdevelopersand 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 andInformaticaSessions/ Batches.

Environment: InformaticaPower 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 withETLArchitects, 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 preparation of documentation forETLusingInformaticastandards, 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: InformaticaPower Center 8.6.1/9.1.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Windows NT.