ETL Developer

Found in: Talent HK C2 - 2 weeks ago

Hong Kong, Hong Kong SAR China John Clements Consulting Inc. Full time

JOHN CLEMENTS CONSULTANTS, INC.

Since its inception in 1974, John Clements Consultants, Inc. has grown into one of the largest consulting firms in the Philippines today, with a leadership position in the local market and a strengthening presence in the international scene, notably in Asia, the Middle East, and the US. While it has grown in size and business interests, locally and internationally, and prospects of the further expansion remain on the horizon, the John Clements Consultants Group has maintained its focus on its core competencies: recruitment and training.


The Role

We are seeking a skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for managing and optimizing data workflows within the AWS Console. Your primary focus will be on creating, modifying, and deleting objects/tables in S3 buckets, executing Glue Jobs scripts for ETL processes, and utilizing the Glue Data Catalog for ETL operations.


Your responsibilities will include:

  • Create, modify, and delete objects/tables in S3 buckets, including the raw, clean, curated zones, and the consumption layer (Redshift Cluster).
  • Develop and execute Glue Jobs scripts for Extract, Transform, Load (ETL) processes, ensuring efficient data transformation across the entire dataset in the Data Lake.
  • Determine appropriate actions, such as tokenization, to be applied in the raw zone for immediate data processing.
  • Set up dataset alarms to monitor the data pipeline and define notifications for missing data ingested.
  • Collaborate with stakeholders to determine data transformation requirements for selected datasets within the Data Lake.
  • Apply data standardization techniques in the clean zone to ensure consistent and reliable data quality.
  • Create snapshots in the clean zone to capture data at specific points in time for analysis and auditing purposes.
  • Design and develop data models in the curated zone, optimizing data structures for efficient access and retrieval.
  • Define tables/objects in the curated zone to support Salesforce usage, ensuring data integrity and compatibility.
  • Identify and create tables/objects in the curated zone and the consumption layer (Redshift Cluster) for Tableau standard access.
  • Determine tables/objects to be included in Redshift Spectrum for Tableau advanced access, enabling advanced data exploration and analysis.

Ideal Profile

  • Bachelor’s degree in computer science, information technology, or a related field.
  • Minimum of 3 years’ relevant work experience.
  • Strong proficiency in working with the AWS Console, including S3, Glue, and Redshift services.
  • Experience with ETL processes, scripting, and data transformation techniques.
  • Familiarity with Glue Data Catalog and its usage in ETL workflows.
  • Solid understanding of data lakes, data modeling, and database concepts.
  • Ability to collaborate effectively with cross-functional teams and stakeholders.
  • Strong problem-solving and analytical skills.
  • Excellent communication and documentation skills.
  • Attention to detail and a commitment to delivering high-quality results.
  • Willing to travel and be deployed to client/affiliate off-shore (Hong Kong office).

What's on Offer?

  • Leadership Role
  • Great work environment
  • Attractive salary & benefits

  • ETL Developer

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Snaphunt Full time

    The OfferLeadership RoleGreat work environmentAttractive salary & benefitsThe JobOur client is seeking a skilled Data Engineer to join their team. As a Data Engineer, you will be responsible for managing and optimizing data workflows within the AWS Console. Your primary focus will be on creating, modifying, and deleting objects/tables in S3 buckets,...

  • Informatica Developer

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Unison Consulting Pte Ltd Full time

    Design, develop, and implement complex ETL processes using Informatica PowerCenter. Create and maintain high-quality, efficient, and scalable ETL mappings, workflows, and sessions. Collaborate with business analysts and data architects to understand data requirements. Perform data profiling and analysis to ensure accurate mapping of source system data to...

  • Application Developer

    Found in: Talent HK C2 - 2 weeks ago

    Hong Kong, Hong Kong SAR China China Investment Information Services Limited Full time

    Job Responsibilities Responsible for development of Web-based and interactive applications Responsible for development and maintenance of database and ETL jobs Being a member of development team to deliver solutions Work with headquarter application support team to provide production support and system release deployment  Perform on-going...

  • MS SQL Developer

    Found in: Talent HK C2 - 2 weeks ago

    Hong Kong, Hong Kong SAR China Unison Consulting Pte Ltd Full time

    We are searching for an experienced Senior MS SQL Developer with a minimum of 5 years of hands-on experience in MS SQL Server database development, along with proficiency in SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services). As a Senior MS SQL Developer, you will be a key member of our development team, responsible for...

  • Webmethod Developer

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Nityo Infotech Full time

    ETL Developer Experience Required 5 - 8 Years Industry Type IT Employment Type Permanent Location Hong Kong

  • Java and Web Developer

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Sirius Partners Full time

    Job DescriptionOur client a top financial institution is currently seeking Java and Web Developers to support their technology team. Roles and Responsibilities:• Support and maintain Finance, Compliance, and Credit Risk applications.• Participate in system implementation projects and ensure proper documentation following the Software Development Life...

  • Senior Database

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Unison Consulting Pte Ltd Full time

    1,Create and maintain optimal Database / DWH / Datamart architecture, which may include: Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Informatica, SQL and related technologies. Identify, design and implement internal process improvements. Automating manual processes....

  • Java and Web Developer

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Sirius Partners Full time

    Our client a top financial institution is currently seeking Java and Web Developers to support their technology team. Roles and Responsibilities:• Support and maintain Finance, Compliance, and Credit Risk applications.• Participate in system implementation projects and ensure proper documentation following the Software Development Life Cycle (SDLC)...

  • Java and Web Developer

    Found in: Talent HK C2 - 2 days ago

    Hong Kong, Hong Kong SAR China Sirius Partners Full time

    Job DescriptionJob Description Our client a top financial institution is currently seeking Java and Web Developers to support their technology team.Roles and Responsibilities:• Support and maintain Finance, Compliance, and Credit Risk applications.• Participate in system implementation projects and ensure proper documentation following the Software...

  • Technical Manager(application Development)

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Nityo Infotech Full time

    •Knowledge in Data Warehouse/Data Lake/Big Data technology•Hands-on experience Oracle, SQL Server, Linux•Knowledge in various visualization and analytics tools such as Alteryx, Tableau•Knowledge in various data governance tools such as ETL, data quality/cleansing,master/meta data management such as Informatica, Talend•Knowledge in messaging...

  • Data Engineer with Python

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Unison Consulting Pte Ltd Full time

    Develop and implement data pipelines for ingesting and collecting data from various sources into a centralized data platform. Develop and maintain ETL jobs using AWS Glue services to process and transform data at scale. Optimize and troubleshoot AWS Glue jobs for performance and reliability. Utilize Python and PySpark to efficiently handle large volumes of...

  • eMPF Team Deployment

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China Frankasia Search Limited Full time

    Job DescriptionWe are looking for highly skilled and motivated Data Engineers to work on the largest financial project in Hong Kong. As a Data Engineer, you will play a key role in managing and coordinating activities for the ETL processes to perform data migration. Your primary responsibility will be to ensure the successful migration of structured data...

  • eMPF Team Deployment

    Found in: Talent HK C2 - 7 days ago

    Hong Kong, Hong Kong SAR China Frankasia Search Limited Full time

    We are looking for highly skilled and motivated Data Engineers to work on the largest financial project in Hong Kong. As a Data Engineer, you will play a key role in managing and coordinating activities for the ETL processes to perform data migration. Your primary responsibility will be to ensure the successful migration of structured data within tight...

  • Data Engineer, Senior Consultant/Manager, Finance Consulting

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China KPMG China Full time

    KPMG China provides multidisciplinary services from audit and tax to advisory, with a strong focus on serving our clients' needs and their industries. Not only do we have an overriding commitment to provide the highest quality services for our clients, but we also strive to become a responsible corporate citizen that has a positive impact on our environment...

  • Data Specialist, Data and Analytics

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China West Kowloon Full time

    The West Kowloon Cultural District Authority welcomes exceptional talent with a passion to realise the vision and mission of making the West Kowloon Cultural District a prime local and international destination for arts, culture and entertainment.You will be responsible for:leading the data-driven / analytics-driven data model design and manage the data...

  • Data Engineer

    Found in: Talent HK C2 - 2 weeks ago

    Hong Kong, Hong Kong SAR China CLPS Full time

    Job Responsibilities: Develop & maintain the ETL batch to manipulate the model result data (live logging by Kafka) on Hadoop platform (HDFS), the data is semi-structured and huge (~5TB daily), combine analytical data set with the logging data for model training, investigation & monitoring purpose.Support, trouble-shooting & educate the users to access the...

  • Data Analytics Solutions Manager

    Found in: beBee jobs HK - 8 hours ago

    Hong Kong, Central and Western District, Hong Kong SAR China Randstad Hong Kong Full time

    about the company.My client is a well-known educational institution and they are currently seeking data manager to drive the transformation.about the job.Develop a data & Analytics IT solutions plan in collaboration with various stakeholders, including the architecture team, business users, and data providers.Establish data quality standards, implement...

  • Big data

    Found in: Talent HK C2 - 1 week ago

    Hong Kong, Hong Kong SAR China CLPS Full time

    Job Responsibilities: Evaluate and renew implemented big data architecture solutions to ensure their relevance and effectiveness in supporting business needs and growth.Design, develop and maintain data pipelines, with a focus on writing scalable, clean, and fault-tolerant code to handle disparate data sources, process large volume of structured /...

  • Assistant Manager, Finance Data and Reporting

    Found in: Talent HK C2 - 2 weeks ago

    Hong Kong, Hong Kong SAR China Sun Life Full time

    Job Description : Job Overview:   We are seeking a highly skilled and motivated Technical Specialist to join the Finance Department of our Life & Health (L&H) business and contribute to our ongoing finance transformation program. As a Manager, Finance Data and Reporting, you will play a crucial role in our finance transformation program by designing,...

  • Data Engineering Manager

    Found in: Talent HK C2 - 2 weeks ago

    Hong Kong, Hong Kong SAR China The Bank of East Asia Full time

    Responsibilities Responsible for Data Engineering of Data Lake and Data Warehouse; Manage all project related budgets and costs (internal and external) and verify the costs spent in project execution as budgeted; Build enterprise Big Data Analytics and AI blueprint and collaborate with business users across the organization to assess their needs and define...