Resume

Sign in

Etl Developer Access Manager

Location:
Mason, OH
Posted:
May 29, 2021

Contact this candidate

Resume:

ASHOK

Email: adms0v@r.postjobfree.com

Phone: 971-***-****

Professional Summary:

Overall 8 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of MDM & Data Warehouse Applications.

Extensive experience in Informatica MDM/Power Center/IDQ and data integration experience in developing MDM & ETL mappings.

Have clear understanding of MDM Party Data Model & Data Warehousing and BI concepts with emphasis on MDM/ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Experience in creating High Level Design and Detailed Design in the Design phase.

Extensively worked on the MDM/ETL mappings, analysis and documentation of the requirements.

Experience working on Informatica MDM to design, develop, test, review & optimize Informatica MDM.

Working with core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD &Data Modeling.

Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.

Knowledge in creation and maintenance of entity objects, hierarchies, entity types, relationship objects.

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.

Extensive Experience in working with Entity Framework 360/Customer 360, Provisioning Tool.

Strong experience in designing & developing the Workflows in Informatica Active Vos.

Experience in Working MDM Environments mounted on Amazon web services (AWS) & Microsoft Azure cloud Platforms.

Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.

Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations.

Experience in working with Informatica Analyst tool for creating profiles, Rules and scorecards to inspect the results & share to Business users for Initial Analysis.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, Java, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.

Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.

Involved in Unit testing, System testing to check whether the data loads into target are accurate.

Extensive database experience in SQL Server, Oracle, XML Files, Flat Files, MS Access.

Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.

Education Qualifications:

Masters: M.S. in Computer Technology, Eastern Illinois University, USA. (2014-2015)

Bachelors: JNTUH, Hyderabad, India. (2008 – 2012)

Technical skills:

MDM/ETL Tools

Informatica 10.4/10.3/10.2/10.1/9.6/9.1 Source Analyzer, Mapping Designer, Workflow Monitor, Workflow Manager, Data Cleansing, Data Quality, Repository, Metadata, Data Mart, OLAP, OLTP, IDQ, MDM, E360/C360, Provisioning Tool, Active VOS, SQL Server.

Databases

Oracle 11g, MSSQL Server 2018/2017/2008/2005

Operating Systems

MS Windows 2010/2008/2007, UNIX

Programming Languages

SQL, Java, PL/SQL, T-SQL, UNIX Shell Scripting

Job scheduling

Shell Scripting, Control-M, Custom Job Schedular

Other Tools

Toad, SQL Developer

Professional Experience:

Archer Daniel Midland (ADM), Erlanger, Kentucky Aug’19-Tilldate

Sr. Informatica MDM Developer

Responsibilities:

Interacted with ADM NPD Team Business executives in gathering requirements and translated Business Requirements into MDM’s Technical Requirement Specifications.

Involved in complete life cycle of MDM Party, Place & Item domains implementations on Informatica MDM 10.1 and 10.3/10.4.

Integrated ADM data from different sources such as IBM, AGRIS, JDE, Maximo to create a Customer Master Data to get Best version of truth as Golden record.

Worked on Data governance, Data quality and MDM Architecture Team to analyze large volume of Bulk Data.

Implemented MDM Party domains for Customer & Supplier Business Entities to master data.

Created landing tables, staging tables, configured Base objects and mappings in Party, Item & Place Domain for MDM 10.1 & 10.3/10.4.

Created various Match rules in Place Domain using Exact & Fuzzy match rules set based on Business Needs by analyzing the data & Configured Merge rules (Auto merge and Manual merge).

Running the MDM Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Group and Batch Viewers.

Analyzed the background tables such as Stage tables (RAW table, REJ Table, PRL table, OPRL table), Base tables (MTCH table, HIST, DRTY, HMRG, XREF table, HXREF table).

Performed Match/Merge and ran match jobs to check the effectiveness of MDM process on data.

Analyzed the ADM business data and defined the Match and Merge rules and Trust Scores for MDM Hub.

Created the roles in Security Access Manager/SAM and enabled the create, update, execute commands for the newly created child business entities like Supplemental capacity for the parent supplemental.

Worked on IDD, Entity 360 & Customer 360 for Party & Place domain Implementations to create the Subject areas & Business Entities for respective environments.

Created IDQ Rules to use cleansing functions in MDM HUB to validations in MDM E360 & Customer 360 Place Domain for MDM Optimization project.

Configured MDM E360/C360 using Provisioning tool and created Business Entities to add the Child Entities to parent.

Analyzed MDM HUB Cleanse_Server & CMX_Server logs for any issues pertaining to MDM or IDD/E360.

Published the records to downstream SOA applications with the help of Message queue(MQ). Also, configured SOA Call in AVOS Workflows for real time data to push to downstream applications.

Worked on the Active Vos Console such as Processes monitoring, Tasks monitoring and Server monitoring.

Developed BPEL files in Active VOS Designer, Deployed .BPR files into the Active Vos server in party 10.1 Domain.

Developed Auto Approval Workflow in Active VOS Designer for Auto Approval record processing from E360/C360 Screens.

Extensively used Repository manager for validating, promoting, importing and exporting repositories from Development environment to QA environments.

Develop test scenarios for unit and integration testing & generate the test data as per the test cases.

Preparation of test cases and code review document, debugging the defects identified and fixing them.

Environment: Informatica MDM 10.3, IDQ 10.2, Informatica Active VOS 9.2, Java, SIF, Soap UI, Informatica Power center 10.3, Informatica E360, Informatica Customer 360, IDD, AWS Cloud, Azure Cloud, Oracle 11g, UNIX, SQL* PLUS, TOAD, MS Excel.

Cargill, Hopkins, Minneapolis Oct’18-July’19

Sr. Informatica MDM Architect/Lead Developer

Responsibilities:

Worked with business analysts to concise the business requirements to produce effective technology solutions.

Analyzing, designing, developing ETL strategies and processes, writing ETL specifications, Informatica development, and mentoring other (CDP) team members.

Participated in the development and implementation of CAN Data Lake Project using Informatica power center and data quality that reduced the cost and time of implementation and development.

Worked on Informatica MDM HUB 10.1 for the Cargill Animal Nutrition data to get the golden records from different Cargill data sources.

Worked on Informatica Cloud where all the data from different sources load into Staging tables of MDM.

Involved in implementing the staging process of loading the Customer Ship_To & Sub-Ship_To Data Set into Data Marts from various source systems.

Developed complex mappings in Informatica MDM HUB to load the data from various sources such as Axapta, NIS, TC1 & M3.

Participated in the development and implementation of MDM CAN Data Lake project using Informatica data quality that reduced the cost and time of implementation and development.

Implemented Informatica MDM, IDQ and mounted on AWS cloud.

Identified Golden Record (BVT) for Customer Data by analyzing the CAN data and duplicate records coming from different source systems such as TC1,NIS,M3 & Axapta.

Responsible for MDM Hub development including Mappings, cleanse Functions (Landing, staging and Base Objects), data validation, match and merge rules, queries and packages.

Designed data governance and data quality process for the subject areas in MDM Applications.

Worked with Informatica Data Quality (IDQ) for data cleansing, exception handling and monitoring capabilities of IDQ.

Created profiling, mappings in IDQ to perform the tasks such as cleansing the data and populate that into staging tables of MDM.

Involved in implementing the staging Process of loading the customer Ship_To & Sub_Ship_To Data Set into Informatica MDM from various source systems.

Created JAVA User Exits to customize the Hub functionality.

Experienced in Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer.

Experience in configuring the Match and Merge Rules in the MDM Hub by defining properties for Fuzzy and Exact match, Creating path components and Match Rule Set.

Configured Soap based SIF API calls by using Soap UI for performing multiple tasks like truncating staging, Base Object party tables in Informatica MDM Hub.

Worked on Active VOS Designer in Development environment for the Approval levels.

Deployed the .BPER files to AVOS console & Migrated to QA/UAT/PROD after UAT Testing.

Publishing Data to downstream applications using Message Queues to notify external applications on data change in MDM Hub Base Objects.

Work closely with Informatica Support to resolve the issues identified in Informatica MDM tool.

Worked on IDD UI configuring subject areas for Customer Domain that assisted to search and edit master records that enabled client with their Nutrition sales process transformation.

Involved in the UAT testing of CAN Data Lake in Party Base Objects.

Created STM Document, Unit Test Case Document, Technical Design Document and Data Validation document.

Environment: Informatica MDM 10.1, IDQ 10.1, Informatica Cloud, Informatica Active VOS 9.2, Java, AWS Cloud, IDD, SIF, Soap UI, Oracle 11g, UNIX, SQL* PLUS, TOAD, MS Excel .

La Care, Los Angeles, California Apr'18-Sep’18

Sr. Informatica MDM Consultant

Responsibilities:

Interacted with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.

Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration.

Configured MDM Party Base Object Tables in schema and relationship tables in hierarchies according to party data-model.

Configured Landing Tables, Staging Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.

Defined Trust and validation rules before loading the data into the base tables.

Involved in Executing the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Batch Group Jobs.

Analyzed the data from all the source systems and designed Match Rules, Validation Rules and Trust Scores.

Identify Golden Record (BVT/SSR) analyzing the data and duplicate records coming from different source systems.

Using AWS Cloud Watch performed Monitoring, customized metrics and file logging.

Experience in migrating MDM Mappings into AWS Glue or Athena based ETL processes.

Performed Installation, deployed and upgraded AWS Cloud- based servers and services in accordance with TPM project guidelines.

Configured Match & Merge Rules (Exact and Fuzzy) for consolidation process, Validation Rules and Trust scores respective of BO tables.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.

Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.

Configured Hierarchies (Entities/ Entity Objects/ Hierarchies/ Relationship Objects/ HM Profiles) to define the hierarchy data of the corresponding data-model in IDD.

Created IDD/ HM Queries, Packages (PUT & Display) and Search Queries (Custom Queries).

Created IDD application and Subject Areas, along with Business entities.

Configured IDD for client usage on web application. Clients can access the master record and update the information directly in base object.

Creating JAVA User Exits (PostLoad, PostMerge and PostUnMerge) to customize the Hub functionality.

Configured JMS Message Queue in the MDM hub Console.

Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.

Design and development test scenarios for unit and integration testing, as well as positive and negative testing and generating the test data as per test cases.

Preparation of test cases and code review document, debugging the defects identified and fixing them.

Environment: Informatica Power Center 10.2, Informatica MDM 10.2, AWS Cloud, IDD, SIF, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel .

Spectrum Health, Grand Rapids, Michigan Apr'17-Apr'18

Sr. Informatica ETL/MDM Developer

Responsibilities:

Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.

Design and developed end-to-end ETL/MDM process from various source systems to Staging area, from staging to Data Marts.

Worked on Welltock & HICN projects using Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.

Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Java, Expression, Router, Joiner, Normalizer, Aggregator Sequence Generator and Address validator.

Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.

Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.

Extensively created Re-usable Transformations and Mapplets to standardized Business logic.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Responsibilities include creating the sessions and scheduling the sessions.

Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

GDW data is sourced to load the data into party Base objects using MDM business rules.

Analyze the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.

Identify (Golden Record/Best version of the Truth/ Single source of truth) by analyzing the data coming from various source systems.

Provided support on AWS application provisioning and maintenance tasks, AMI upgrades.

Involved in creating the entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).

Define Trust and validation rules before loading the data into the base tables.

Publish the Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.

Worked on match/merge and ran match rules to check the effectiveness of MDM process on data.

Implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.

Involved in defining and configuring the schema, staging tables, landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.

Define the Trust Score Validation rules, Match rules and Merge settings.

Develop and maintain the master and translation entities in the MDM Hub and publish the data into ERP s for supporting the ongoing business support.

Prepared SQL Queries to validate the data in both source and target databases.

Actively participated in Scrum Meetings.

Designed and developed the ETL processes using Informatica to load data from Oracle, Flat files and XML files to target Oracle Data warehouse.

Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.

Created partitioned tables, indexes for manageability and scalability of the application.

Leveraged workflow manager for session management, database connection management and scheduling of jobs.

Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.

Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.

Created control-M jobs and scheduled them.

Created Test cases and Test Plans for unit testing.

Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.

Documented and presented the production/support documents for the components developed, when handling over the application to the product support team.

Environment: Informatica Power Center 10.1, Informatica MDM 10, AWS, IDD, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel.

Truven Health Analytics, Ann Arbor, Michigan Jan'16-April'17

Sr. Informatica MDM Developer

Responsibilities:

Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.

Worked on Informatica MDM & Power Center Tools like MDM HUB Console, designer, workflow manager, workflow monitor and repository manager.

Parsed high-level design specification to simple ETL coding and mapping standards.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

Involved in Informatica MDM where data Cleansing, De-duplication and Address corrections were performed.

Define the Trust and Validation rules and setting up the match/merge rule sets to get the golden master records.

Involved in implementing the Land Process of loading the Incoming Data Set into Informatica MDM from various source systems.

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.

Implement Informatica MDM including data profiling configuration specification and coding match rules tuning migration.

Define and build best practices regarding creating business rules within the Informatica MDM solution.

Worked extensively to develop customized MDM services.

Maintained MDM jobs and Master Data sequences, Build test scripts for unit testing of customized MDM code.

Worked on data cleansing using the cleanse functions in Informatica MDM.

Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.

Implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child.

Rolled out new MDM Hub for portals in conjunction with user interface on IDD application.

Worked on Data Quality checks for data feeds and performance tuning.

Worked on data analysis to find the data duplication and existed data pattern using a data profiling tool.

Involved in developer testing, unit testing and helped the testing team for data integrity and consistency.

Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.

Supported during QA/UAT/PROD deployments and bug fixes.

Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.

Environment: Informatica MDM 9.6, Informatica Power Center 9.6, IDD, Oracle 11g, UNIX, PL/SQL, IDQ, SQL* PLUS, TOAD, MS Excel.

GE Health Care, Hyderabad India May 2012 to Jun 2014

ETL Developer

Responsibilities:

Involved in creating Technical Specification Document (TSD) for the project.

Used Informatica for loading the historical data from various tables for different departments.

Involved in the development of Data Mart and populating the data marts using Informatica.

Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.

Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.

Developed sessions using Server Manager and improved the performance details.

Created reusable transformations called mapplets and used them in mappings in case of reuse of the transformations in different mappings.

Created transformations like Aggregate, Expression, Filter, Sequence Generator, Joiner, and Stored procedure transformations.

Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.

Designed and coded maps, which extracted data from existing, source systems into the data warehouse.

Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.

Environment: Oracle RDBMS 9i, Informatica, JAVA, SQL*Plus Reports, SQL*Loader, XML, Toad.



Contact this candidate