Data Management Master

PRAJWALA R

Informatica MDM Developer

E-mail: ****************@*****.*** Phone: +1-267-***-****

OBJECTIVE

Around 7 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, testing of applications using Master data Management, Data Warehousing concepts and Business Intelligence tools.

Dedicated professional with a history of meeting company goals utilizing consistent and organized practices.

Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.

Experience in Master Data Management, Data Quality, and Team Handling.

Team player with good interpersonal skills, presentation, and strong communication skills.

ACADEMIC CREDENTIALS

Bachelor of Technology from J.N.T. University (2013), Anantapur, India.

Key Area of Expertise

MDM Tools: Informatica MDM 10.4, Reltio MDM SaaS

Certification: Reltio MDM SaaS Technical Consultant Foundation Certification and Intermediate Level Certification

ETL Tools: Informatica Power centre

Programming Languages: SQL, PLSQL

Operating Systems: Windows-XP, Windows 7

Database: Oracle19c, Microsoft SQL Server

Scripting: UNIX Shell Scripting

Migration Tools: GitHub, Jenkins, UCD

Scheduling Tools: Autosys, Control M

Agile Tools: Jira, Rally

PROFESSIONAL EXPERIENCE

Client: Travelers, Hartford CT August 2022- Till date

Role: Informatica MDM Developer

Technologies: Informatica MDM 10.4.1, Oracle 19c, Unix, Autosys, Mongo DB

Project Description:

The goal of the project was to keep gold copy Master entity information. For each entity, the system will receive data from a few different source systems. The MDM will cleanse the data and maintain a single copy of the master entity. The system also handles any exception activity that occurs while processing data from the source system, as well as any record ambiguity. Once created, this master data serves as a trusted view of business-critical data that can be managed and shared across the business to promote accurate reporting, reduce data errors, remove redundancy, and help workers make better-informed business decisions.

Responsibilities:

• Understanding the functional Requirements of the projects.

• MDM Hub configuration and development as per the requirement.

• Creating Relationships, Lookups, Configuring Stage Process, Mappings

• Creating Cleanse list, Configuring Load Process, executing load jobs.

• Configuring Match & Merge process as per business requirement.

• Involved in implementing the Land Process of loading the Product Data Set into Informatica MDM

from various source systems.

• Creating Landing, Staging, Lookup Tables and Base Objects as per the requirement.

• Creating Mappings with cleanse function and validating the records.

• Configuration of business rules configurations like trust settings, validation rules, match and

merge rules.

• Involved in process of identifying and configuring the Match paths, Match Columns and match

rules for Exact and Fuzzy the Match and Merge Process.

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

• Performed Data Steward Activities like manual Merge/Unmerge and updating data.

• Creating the put and display packages as per the business requirement.

• Creating MDM triggers to publish the records to downstream systems.

• Creating Business Entities for real time and near real time process.

• Configuring the Security Access Manager like creating Roles and Groups.

• Contributed to decommissioning projects by conducting comprehensive analysis and identifying data for deletion.

• Developed soft deletion insert scripts to facilitate the removal of identified data in a non-destructive manner.

• Created hard deletion scripts to systematically and permanently remove data from diverse sources, ensuring optimal storage utilization...

• Performing code migrations across environments using MDM change list manual migration and CI/CD process using GitHub and Jenkins pipelines

Client: GE Digital, Schenectady NY Mar 2019- June 2022

Role: ETL Informatica Developer

Technologies: Informatica PowerCenter, Oracle 19c, Unix, Autosys

Responsibilities:

•Worked with business analyst for requirement gathering, business analysis and testing and project- coordination, document analysis, business process descriptions, scenarios and workflow analysis.

•Design, Development and Enhancements of ETL Jobs using Informatica Power Center.

•Extensively worked on complex mappings which involved slowly changing dimensions

•Analyzed the existing mapping logic to determine the reusability of the code

•Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables

•ETL and Reporting performance tuning.

•Developed Unix Shell scripting and automations.

•Jobs and Job Streams design and scheduling using Autosys

•Impact analysis for new enhancements and changes.

Performing ETL and database code migrations across environments using deployment groups, Jenkins pipelines.

Client: TD Bank, Bostan MA Jan 2018- Feb 2019

Role: ETL Informatica Developer

Technologies: Informatica PowerCenter, Oracle 19c, Unix, Control M

Responsibilities:

•Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.

•Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.

•Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.

•Developed mapping to load Fact and Dimension tables for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.

•Coordinate and develop all documents related to ETL design and development.

•Used repository manager to create repository, user’s groups and managed users by setting up privileges and profile.

•Used debugger to debug the mapping and correct them.

•Performed Database tasks such as creating database objects (tables, views, procedures, functions).

•Responsible for debugging and performance tuning of targets, sources, mappings and sessions.

•Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.

•Optimized the source queries in order to control the temp space and added delay intervals depending upon the business requirement for performance

•Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.

PERSONAL INFORMATION

Gender : Female

Marital Status : Married

Visa Details : EAD

I hereby declare that all the above information given by me is true of my best knowledge.

Contact this candidate