Design and develop the ETL and ELT environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This role requires deep understanding of the overall data warehouse architecture.

Requirements

Core Responsibilities

• Capture ETL Requirements
• Design, develop, test, support processes for extracting, transforming and loading data from source systems to DWH and Data Marts
• Design the processes to meet service level agreements for data timeliness and frequency
• Analyze and optimization current solutions, physical model optimization, query tuning
• Mentoring junior members of the team in data integration development best practices
• Analyze and improve query and solution performance, optimize physical model
• Developing project deliverable documentation
• Utilize effectively Online Data Processing Tools

Core Competencies:

• Performance Excellence
• Collab. & Creating Synergy
• Agility & Resilience
• People Centricity

Technical Competencies

• Knowledge of any enterprise relational database (Teradata, Oracle, IBM)
• Professional Knowledge of Two of industrial ETL tool (Informatica, DataStage, ODI, SAS DI or others)
• Strong SQL and Shell scripting
• Experience in implementing ETL solutions for large, enterprise-grade customers
• Experience in implementing ETL solutions in Hadoop environment is an advantage
• Knowledge of MPP system – Teradata, is an advantage
• Any ETL tools, DB certified is an advantage
• Experience Unix/Linus OS

Domain Expertise

• Bachelor’s degree in computer science is preferred
• Master/ Certificate preferred
• Banking experience preferred