Data Engineer (ETL Developer)

Collaborates with Scrum Master, Delivery Manager, Development Manager, Business Analyst, System Analyst, Developer and users to produce software design.

Provides data design documentation, includes but not limited to Functional Specification Document (FSD), Technical Specification Document (TSD), Epic, User Story, Data Dictionary, and Data Mapping Document.

Processes, designs, and presents data in ways to help people, businesses, and organizations make better decisions.

Provides testing data and its documentation.

Ensures the quality and accuracy of data.

Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.

Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

Develop all data warehouse models and prepare reports for all meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.

Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.

Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.

Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

Job Requirement:

Bachelor Degree from reputable University with education background from Computer Science / Information Technology, Science & Technology, Business Studies / Management or equivalent.

Have in total at least 2-5 years’ experience as Data Analyst or Data Engineer in banking industry.

Familiar with the following banking products: CASA, Loan, Deposit Account, Credit Card, Bancassurance.

Preferable have at least 2 years’ experience in operates ETL Tools such as Talend or Microsoft SSIS or IBM DataStage.

Have a good understanding on Query SQL (Postgresql/SQL Server/Oracle).

Have experiences in ETL Talend - Greenplum Database (plus).

Have a good understanding on Programming Concept, especially Python.

Understand ETL Concept, Automation Scheduling, & Data Pipelines internal.

At least 2 years experience of using Cloudera Hadoop Big Data, Apache Airflow, Apache Spark & Microsoft SQL Server, Apache Druid, Kafka, Apache Superset.

Have experiences in agile project delivery.

Understand data mapping / data journey, and carry out impact analysis on changes related to data mapping / data journey.

Have a good understanding of data modelling and big data stacks.

Excellent communication and interpersonal skills (A good problem-solving attitude).

Have a good command in English and Bahasa (actively).