ETL Engineer

2 days ago

Anson, Singapore FLINTEX CONSULTING PTE. LTD. Full time $90,000 - $120,000 per year

Objectives of this position:

The objective of the position is to manage the extract/transform/load processes ensuring the data availability.

Responsibilities:

The holder of the position is mainly responsible for the following areas in coordination with his / her superior:


•Design, create, modify extract/transform/load (ETL) pipelines in Azure Data Fac-tory ensuring efficient data flow from source to destination.


•Ensure data accuracy and data integrity throughout the ETL processes via data validation, cleansing, deduplication, and error handling to ensure reliable and us-able data being ingested.


•Monitor the ETL processes and optimize ETL pipelines for speed and efficiency, addressing bottlenecks, and ensuring the ETL system can handle the volume, ve-locity, and variety of data.


•Participate in data modeling, designing of the data structures and schema in the data warehouse to optimize query performance and align with business needs.


•Work closely with different departments and IT team to under-stand data requirements and deliver the data infrastructure that supports business goals.


•Provide technical support for ETL systems, troubleshooting issues and ensuring the continuous availability and reliability of data flows.


•Ensure proper documentation of data sources, ETL processes and data architecture.

Requirements:

3 to 5 years of data engineering in Snowflake

3 to 5 years in upstream / downstream Retail industry and/or Supply Chain / Manufacturing domain

Sound Understanding of data quality principles and data governance best practices

Proficiency in data analytics languages like Python, Java, Scala, etc.

Knowledge of big data technologies like Hadoop, Spark and distributed computing frameworks to manage large scale data processing.

Proficient in using version control systems like Git for managing code and configurations.

SnowPro Core Certification and SnowPro Advanced Certification will be advantage

  • ETL Engineer

    2 days ago

    Anson, Singapore FLINTEX CONSULTING PTE. LTD. Full time $90,000 - $120,000 per year

    Objectives of this position: The objective of the position is to manage the extract/transform/load processes ensuring the data availability. Responsibilities: The holder of the position is mainly responsible for the following areas in coordination with his / her superior: •Design, create, modify extract/transform/load (sETL) pipelines in Azure Data...

  • Data Engineer

    2 days ago

    Anson, Singapore FLINTEX CONSULTING PTE. LTD. Full time $90,000 - $120,000 per year

    ResponsibilityThe holder of the position is mainly responsible for the following areas in coordination with his / her superior: Design and build the DWH database models (star schema). Manage the semantic model in Oracle Analytics Cloud to provide a unified view of our organization's data. Manage application roles and access rights for end users including...

  • Senior Software Engineer

    2 days ago

    Anson Road, Singapore Flintex Consulting Pte Ltd Full time

    The activities required to be performed shall include the following: Requirements gathering; Design, development and maintenance of the software; Preparation and submission of deliverables throughout the software development lifecycles such as Business Rules, Software Requirement Specifications, Software Architecture Document, Design Specification,...

  • Back-end - SQL Server (Support)

    2 days ago

    Anson, Singapore Flintex Consulting Pte Ltd Full time $80,000 - $120,000 per year

    **Back-End - SQL Server **Responsibilities** - Designing database tables - Creating views, functions and stored procedures - Creating task schedules for use in automation - Creating SSIS projects for ETL (Extract, Transform, Load), - Creating reports in SSRS - Optimize and maintain legacy systems - Modify databases according to requests and perform...

  • Senior Software Engineer

    3 days ago

    Anson Road, Singapore Flintex Consulting Pte Ltd Full time

    **Responsibilities**: - Working with a back office development team, you will be responsible for the design and delivery of the software solution for a high volume and performance intensive back office of a Automatic Fare Collection (AFC) system. The activities required to be performed shall include the following: - Requirements gathering; - Design,...

  • Back-end - SQL Server (Support)

    2 days ago

    Anson Road, Singapore Flintex Consulting Pte Ltd Full time

    **Back-End - SQL Server **Responsibilities** - Designing database tables - Creating views, functions and stored procedures - Creating task schedules for use in automation - Creating SSIS projects for ETL (Extract, Transform, Load), - Creating reports in SSRS - Optimize and maintain legacy systems - Modify databases according to requests and perform tests -...

  • Database Administrator

    1 day ago

    Anson Road, Singapore Flintex Consulting Pte Ltd Full time

    **Database Administrator (DBA)** This is a DB2 / Oracle Server DBA role largely responsible for providing operational database services to the organization. We are looking to fill a need to have a highly competent and highly motivated individual in this role. This is a production / test / development DBA role, as such it will require a commitment on your...

  • Database Administrator

    2 days ago

    Anson Road, Singapore Flintex Consulting Pte Ltd Full time

    **Database Administrator (DBA)** This is a DB2 / Oracle Server DBA role largely responsible for providing operational database services to the organization. We are looking to fill a need to have a highly competent and highly motivated individual in this role. This is a production / test / development DBA role, as such it will require a commitment on your...