Data Engineer (ETL)

PT Lawencon Internasional; Jakarta Utara; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A rapidly growing IT company in South Jakarta is seeking a Data Engineer to enhance its team. The ideal candidate should have a diploma in Information Technology and be proficient in ETL tools like Oracle Data Integrator and IBM DataStage. Responsibilities include analyzing data quality, developing data warehouse models, and collaborating with developers to implement ETL processes. Join us if you are passionate about advancing your career in Information Technology.

Qualifications

• Familiarity with banking workflows is preferred.
• Must have completed a final project, internship, or training related to programming for Junior level.
• Minimum 3 years of experience for Middle level.
• Minimum 5 years of experience with significant responsibilities for Senior level.

Responsibilities

• Provides testing data and its documentation.
• Ensures the quality and accuracy of data.
• Analyze and interpret complex data and provide resolutions.
• Perform tests and validate all data flows according to business requirements.
• Develop data warehouse models and prepare reports for metadata integration.
• Collaborate with developers and business users to gather required data.
• Develop and perform tests on all ETL codes for system data.

Skills

Proficient in ETL tools

Data warehousing

Big Data

Problem analysis

Designing workflows

Education

Diploma in Information Technology

Tools

Oracle Data Integrator (ODI)

IBM DataStage

Talend

Pentaho

Job description

Minimum of a Diploma (D3) in Information Technology

Experience

• Junior: Fresh graduates are welcome. Must have completed a final project, internship, or training related to programming.
• Middle: Minimum 3 years of experience as a Data Engineer or in an equivalent role in a similar industry.
• Senior: Minimum 5 years of experience as a Data Engineer or in an equivalent role with significant responsibilities and project ownership.

Industry Knowledge

Familiarity with general banking workflows or prior IT experience in the banking industry is preferred.

Core Competencies

• Proficient in ETL tools and understanding of databases
• Able to analyze problems and read code
• Able to design workflows using flowcharts
• Senior level: Demonstrated leadership, technical decision-making, and strong problem-solving abilities.

Technical Skillset

• ETL Tools: Oracle Data Integrator (ODI), IBM DataStage, Talend, Pentaho
• Data Management: Data Warehousing, Big Data

Responsibilities

• 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

We are a rapid-growth and highly innovative IT company based in South Jakarta. We are looking for talented and motivated candidates to be part of our team. Our employees are youthfully enthusiastic and highly passionate about advancement in Information Technology. Thus, we invite you to further develop your professional expertise and join us in our path to become the chosen software provider in business enterprise application. Contact us immediately.

South Jakarta, Jakarta, ID