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