Software Engineer Lead

ETL Developer _4 to 6 Years

Job Description

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 designs.

. 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.

Functional

Skills . Banking domain experience.

Technical Skills Hands-on experience on:

. Informatica PowerCenter 9.6.1

. Oracle Data Integrator (ODI)

. SQL Query (Teradata / Hadoop) - Intermediate / Advance

. Oracle - PL/SQL, SQLLoader

. Hadoop HDFS

Ideal to have but not pre-requisite:

. Unix AIX basic command & shell scripts

. Teradata (TPT)

. ASG-ZENA (Job scheduler)

. IBM DataStage ETL Tool

. JAVA

Full time