SUMMARY

• 10+ years of work experience in IT Industry, expertise in ETL using Informatica Powercenter, Developing DW/BI applications and Master Data Management applications, Data Governance Applications and Data Quality.
• Formulated technical specifications and prepared data models.
• Provided technical support during delivery of MDM components
• Participated in integration of MDM Hub and data warehouses.
• Prepared and executed data cleansing and reconciliation strategies.
• Suggested and implemented best practices for MDM Hub development.
• Designed and developed workflows for maintenance of master data.
• Created data quality rules and prepared project estimations.
• Provided technical support and guidance to team members.
• Skillful in mapping client's requirements, conducting business analysis, translation of complex business concepts/strategies into deliverable product requirements, custom designing solutions for applications and troubleshooting for complex application related problems
• Created reusable ETL components and maintenance of ETL mappings. Performance Tuning, Performance Testing and Optimization of existing processes.
• 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 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.
• Experience in SQL, PL/SQL and Oracle 12c/11g/10g, SQL Server 2012/2008/2000 Triggers, Views, Indexes and query optimization.
• Experience in Informatica Intelligent cloud services (IICS)
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, COBAL/VSAM Files, JSON, XML(Files) 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
• Defining Data Governance strategy, formulating Data Governance council, Data Quality Assessments, providing assistance in identifying. Evaluating designing systems, procedures to meet strategic data transformational and business requirements.
• Publishing the data using BES to downstream systems and using of data model and customizing according to business requirements.
• 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 working SIF framework, REST API protocols using SOAP/POST MAN.
• 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.

TECHNICAL SKILLS

MDM Packages: Informatica MDM Multi Domain Edition 10.x, Provisioning Tool, Informatica Data Director (IDD), JBoss Server

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

IDQ Packages: Informatica Developer 10.1 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, San Francisco, CA

ETL/MDM Architect/Developer

Responsibilities:

• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Formulated data governance rules and master data requirements.
• Implemented data architecture guidelines and MDM quality standards.
• Designed and developed service level agreements for MDM processes.
• Participated in requirements analysis and designing of MDM projects.
• Prepared and maintained MDM blueprints and technical processes.
• Provided assistance in designing of MDM application systems with MDM tools.
• Conducted SME reviews relating to performance of MDM engagements.
• Created data governance frameworks and analyzed data integration requirements.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data into staging area.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Experience with Informatica MDM Hub configurations, Data Modelling& Data Mappings (Landing, staging and Base Objects).
• Develop Informatica MDM Hub platform solutions using data profiling, data mappings, data validation, hierarchy management, match and merge rules (business rules) to the front-end user experiences.
• 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.
• Subject matter expert for critical data within various business domains.
• Work with a set of stakeholders to identify the data required to operate an area of the business.
• Accountable for defining and managing data governance standards for data quality and metadata
• Participated in identifying key data elements, governance over data lineage, technical metadata.
• Identify Trusted Source, Business owner & Operational owner for each of the KDE, Define business definition, Business rules.
• 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.
• 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.
• Worked in IICS mappings and Job.

Environment: Informatica MDM Multi Domain Edition 10.x SQL Developer, SQL Developer, PowerCenter 10.x, IICS, IDQ, Oracle 10g, Windows 2000, Linux, and UNIX.

Confidential, San Ramon, CA

Sr ETL/MDM Developer/ Architect

Responsibilities:

• Experience with Informatica MDM Hub configurations, Data Modelling& Data Mappings (Landing, staging and Base Objects).
• Informatica MDM Configuration which includes IDD, Tokenization, Hierarchy Manager, Migration, match and merge process.
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyse and understand the ETL workflows developed
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Metadata Manager), Power Exchange, Power Connect as ETL tool on Oracle Databases.
• Designs and plans testing and reporting for the impact assessment of additional functionality
• Closely working with Data Steward to maintain the Data Quality after the Merge Process.
• Cleansing the Duplicate record in Customer Master with cost Efficient.
• Worked closely with SMEs, Program Manager, Project Sponsors, and Solution Architects to design solutions for gaps
• Operation Support for around 21 source system (Batch and Real Time).
• Data Analysis to maintain the quality of the data.
• Involved in the production support and monitoring the batch load.
• Peer Review the Deliverables and make sure that on time delivery with quality.
• Worked with BES using Provisioning Tool

Environment: Informatica MDM Multi Domain Edition 10.x InformaticaPower Center 10.x (Source Analyzer, Mappl1t Designer, Mapping Designer and TransformationDeveloper), SQL, Oracle 10g, Provisioning Tool Linux, and UNIX.

Confidential

Informatica Developer/MDM Developer

Responsibilities:

• Collaborated closely with Business Analyst to understand the business data flow and in gathering requirements
• 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.
• 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.
• 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
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• 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 UNIX Shell 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.
• Experience with 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, Unix Scripting, Windows, TOAD, Autosys, CVS.