ETL / Informatica MDM / IDQ consultant available on c2c

August 19, 2020

ETL / Informatica MDM / IDQ consultant available on c2c

Greetings of the day

Kindly find the details of my consultant available for your direct client requirement, on c2c. Kindly share the complete Job description at sadath@mutexsystems.com

Consultant"s info:-

Name: Aditi L

Total exp: 13+ years

Current location: Parsippany NJ

Relocation: Open

Visa: H1b

Availability: 2 weeks' notice

Aditi L

908-777-8045 /Sadath@mutexsystems.com

Summary:

� 12+ Years of IT experience and has portrayed skills in analysis, designing custom solutions, implementation, and development of Data warehouse using Informatica and troubleshooting and testing using ETL testing tools.

� Spearheaded client upgrade of Informatica MDM by designing, planning, and supervising all project tasks for successful execution.

� Liaised with multiple teams, such as infrastructure management, WebSphere, and database administration teams, to ensure smooth execution and comprehensive consideration of impact of projects.

� Advised project and client teams on technical aspects, including design and process for data extraction, data profiling, and data cleansing.

� Outlined and tested data migration specifications in Technical Specifications document, capturing mapping requirements and match and merge rules.

� Experience working on Informatica MDM. Design, develop, test and review & optimize Informatica MDM (Siperian).

� Worked with diversified technologies and performed variety of Management roles with hands on experience in technical and functional areas such as requirements capture & management, architecture & design oversight and end-to-end testing involving up to 10 internal & external applications in a release.

� Extensively worked in in the areas of Data & Application Integration, Data Management & Operations, Data Governance & MDM, Data warehousing & BI for various fortune 500 organizations.

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

� Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).

� Working on Informatica Data Quality, Analyst Tool to profile data, Cleanse data.

� Experience in configuring the MRS, CMS, AST and DIS services on Informatica Data Quality.

� Experience in scheduling batch jobs for IDQ workflows and mappings.

� Experience in Cleansing, Standardizing data Geo-coding the data on Informatica DQ and MDM tools.

� Experience in applying RULES in IDQ for Profiling, Match and Merge process.

� Championed successful upgrade of Informatica MDM Platform from version 9.1 to 10.4 by planning and overseeing team executing all phases of the project.

� Maintained project momentum by addressing issues from SIT and UAT; analysed business needs, downstream impact, and crafted workarounds to sufficiently remediate issues.

� Defined and helmed change management process to ensure new requests and changes from clients and client service managers were thoroughly vetted and appropriately incorporated into project.

� Verified accuracy of project outcomes by methodically reviewing issues surrounding erroneous and duplicative data and data integrity; recommended workarounds and fixes to improve accuracy.

� Experience in monitoring and scheduling jobs in Informatica Data Quality using batch scripts and windows task scheduler.

� 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 real time integration with different external application by using Inbound (SIF) and Outbound (message queue).

� Developed User Exits for implementing custom business rules.

� Hands on experience on designing IDD Application and experience in customizing IDD application through IDD config files.

� Work on Informatica analyst to profile data from source and provided drill-down results using scorecard in Informatica Data Quality to gather information from different systems and unify them to one global identifier using Informatica Master Data Management.

� Hands on experience in MDM advanced options like entity 360, Smart Search, Composite base objects, Platform Staging, Provisioning Tool and Elastic search

� Experience in migrating the code from one environment to another environment using repository manager workbench.

Technical Skillset:

Processes:	MDM, ETL, DW, BI, Analytics, Data Quality, Data Governance, Data Stewardship
ETL Tools:	Informatica MDM, IDQ, IICS, PowerCenter, AWS, Cognos, Toad, PL/SQL Developer
Languages:	SQL, UNIX Shell Scripting and UNIX
Technologies:	Oracle, SQL, PL/SQL, Teradata, Data Warehouse, Java, XML, HTML, Cloud platform
Platforms:	UNIX, MS DOS, Windows 9x/ME/2000/NT/XP/2003
Hardware:	IBM PC Clone (Pentium Core2Duo, Dual Core IV, III, II, I)