Understand & Interpret upstream and downstream data flow, do data profiling, data
mapping and Check Data Quality from Source to Target.
Perform impact analysis of new systems, new interfaces & integration. Work on
impact analysis to reference data (domain/dimension; data elements/properties; base
members/data sets; hierarchies) to ensure compliance with Data Governance
principles.Manage critical relationships with consultants and vendors, internal end
users, and business leaders.
Implement high-quality solutions by translating business requirements into integration
specifications, working with ETL developers to oversee the implementation of ETL
Responsible to develop ETL architectural and design patterns, considerations,
solution options, and impact
Design, develop, and implementation ETL solutions using Informatica tool
Identification and analysis of data issues impacting financial services organizations
Assist with the development and enforcement of integration standards using
knowledge of the current data environment, regulatory issues and industry trends to
identify and implement leading industry data practices.
Ability to conduct discovery, perform root cause analysis, and make recommendations
for the remediation of data quality issues
Facilitation and definition of reporting and analytics business requirements
Provide post-production batch support.
Conduct unit test, SIT, and provide UAT support.
Hands-on experience on:
Informatica PowerCenter 9.6.1 / Oracle ODI tool
SQL Query (Oracle / Teradata) – Intermediate / Advance
Hadoop HDFS / Hive
Ideal to have but not pre-requisite:
Unix AIX basic command & shell scripts
ASG-ZENA (Job scheduler)