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.
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
- BI Tools like MicroStrategy, Power BI, Tableau
- Programming skills like Python, Scala, or Java for custom ETL and automation
- Good to know Cloud Platforms like AWS (Glue, Redshift, S3, Lambda), Azure (Data Factory, Synapse), or GCP (Dataflow, BigQuery)
- Data Visualization/Reporting like Tableau, Power BI, Looker
- Workflow Orchestration like Apache Airflow, Control-M, or similar schedulers
- API Integration like REST/SOAP APIs for ingesting or pushing data
- Very good verbal and written communication skills
- Hands-on experience in API testing & developing automation test script for mobile or tablet devices using Appium.
- Good understanding of Linux operating system and hands on work experience in Linux operating system is desirable
- Ability to identify new testing techniques and tools.
- 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
- Upgrade of tools to latest version for maximum business impact
- Tools Usability Tracking & Reporting
Benefits
- Competitive salary and benefits to support your mental, physical, financial and social wellbeing.
- Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations.
- Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days), along with 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.
- Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.
