The ETL Design and Development will be responsible for CCIB DCDA BI Reporting projects on-premises & on-cloud with good technical knowledge on big data and Tools. Good exposure in problem solving & stakeholder management skills. This role will report into the Lead for ETL Reporting and product development team in CCIB DCDA.
Requirements
- 8 to 12 years Experience of working in data analytical ETL Design & Development projects
- Expertise in tools like Informatica, Talend, SSIS, DataStage, and custom Python-based ETL frameworks
- Must know Programming skills like ETL using Hadoop, Python, SQL, Shell scripting, PySpark, Scoop, Scala
- SQL Expertise in writing complex queries, performance tuning, query optimization
- Data Modelling of Star/Snowflake schema, slowly changing dimensions, normalization/denormalization
- Expertise in the Big Data Ecosystem like Hive, Spark, HDFS, or working knowledge of Hadoop-based environments
- Soft Skills like Strong communication and stakeholder management
- Very good verbal and written communication skills
- Good understanding of Linux operating system and hands on work experience in Linux operating system is desirable
- Excellent problem-solving skills
- Excellent team player and exhibit a positive attitude
- Strong collaboration, oral and written skills
- Good exposure to migration from MSTR to working with data accelerations tools like Dremio/Exasol or Data processing tools like DataIku
Benefits
- Core bank funding for retirement savings
- Medical and life insurance
- Flexible and voluntary benefits
- Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days)
- Minimum global standards for annual and public holiday, which is combined to 30 days minimum
- Flexible working options based around home and office locations, with flexible working patterns
- Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits
- A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning
