Informatica Product Suites: Informatica Data Quality (Cloud and On-Prem) used for building data quality mappings/routines that helps in data cleansing and data standardization in most efficient manner.

oDevelopment efficient & highly tuned data cleansing routines
oShould be able to use all IDQ transformations including Address Doctors
oUnderstands IDQ architecture and performance techniques with industry standard coding practices
oShould be able to works with exposing data quality rules as webservices and consumed data from third party rest APIs
oShould be able to work with managed and unmanaged reference table
oUnderstands the code deployment & knows to automate it
oInformatica Analyst Used by Business/ Data analyst & data stewards to profile data, define rule specification and manage business glossary
oBuild profile on heterogenous data sources – Basic profiling, join data profiling
oBuild scorecards
oBuild reference tables
oBuild mapping and rule specificationso
Build and manage Reference data though reference tables
oAble to build and manage business glossary
oInformatica Data Management Cloud Data Integration and Cloud Application Integration services are used for data integration and ETL flows and this helps our program with large scale integration projects with minimum infrastructure
oDevelop efficient & highly tuned data transformation mappings
oDeploy and manage the secure agents
oUtilize parametrization features in CDI/CAI
oBuild, execute/schedule mapping tasks and task flows
oPerformance tuning through lookup and other coding best practices
oKnows SCD Types and its implementation in CDI/CAI
oRest API consumptions
oInformatica Reference 360 Informatica’s SaaS based product for reference data management
oBuild and implement code list
oBuild and implement cross walks
oAccess management on reference data
oIngest and export data in and out of Reference -360
•Informatica MDM Resource Kit
oInformatica Command Line Utilities
oInformatica OOB API
oInformatica Address Doctor
oApigee/Mulesoft/etc
•Informatica platform administration
•Informatica Patching/Upgrade utilities
•Process Scheduling Application: Rundeck / Control-M
oBuild Jobs for execution of IDQ/ MDM processes
oBuild Jobs for execution of Database processes
oBuild Jobs for execution of Shell programs on Linux
oBuild Workflow Jobs and Daily batch processes
oSetup Alerts/Notification/ Error handling Routines
oApplication Start/Stop Routines
 

Tools/ Utilities:
oLinux Shell Scripting
oBuild Shell Programs for process executions
oApplication cleanup actions
oSoapUI
oPostman
oCI/CD through Informatica Dev Ops Platform
oBuild Custom Operational Reports and Email Notifications
oOS Infrastructure Alerts
oApplication Start/Stop routines

Documentation:
oGIT – Global Information Tracker
▪Strong Documentation Skills
▪Follow change management policies
•Platform
oAzure
▪Fundamental
▪Cloud computing
•Databases
oOracle
▪Development
▪Project level administration
oSQL Server, MYSQL
oExposure to NOSQL DBs – Graph / Document Databases

Functional skills:
•Data Modeling
oLogical / Physical Modeling
•Data Integration
oBatch & Realtime Integration
oETL
•Master Data management
•Data Governance
▪Business Definition of Data Elements
▪Understand Governance Rules and Policies for Master Data Entity
▪Data Lineage
▪Data Element Definition
▪Relationships Definition
•Data Stewardship
▪Control Roles based Access to the master data
▪Implement approval / rejection process for create/Edit of master Data
▪Setup Business rules on Create/Edit of master data using IDD/E360 applications
▪Control Quality of Data as per defined Governance rules / Policies
▪Follow process for Manual Merges/ Unmerges
•Data Quality
•Match & Merge
•Cross Referencing
•BVT (Best Version of the Truth) and Survivorship Process
•Project management skills:
•Business Requirements Gathering
•Logical Design / Technical Design
•Estimation
•Team management (For Leads)
•Demo/Presentations

About Regal Rexnord