Job Description

Title:

ETL Developer.

Experience:

5 years\xe2\x80\x99 experience in ETL Development.

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) \xe2\x80\x93 Intermediate / Advance
Oracle \xe2\x80\x93 PL/SQL, SQL Loader
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.

Tentacle Technologies