Senior Etl Engineer

2 weeks ago


Singapore Argyll Scott Full time

As a Senior ETL (Extract, Transform, Load) Engineer, you will play a crucial role in the development and maintenance of the organization's data infrastructure.

Your primary responsibility will be to ensure the smooth and efficient extraction, transformation, and loading of data from various sources into the designated data warehouse or database.

You will collaborate with cross-functional teams to understand data requirements, design ETL processes, and implement solutions that meet business needs.


Responsibilities:

  • Data Extraction and Transformation: Identify, extract, and transform data from diverse sources such as databases, APIs, flat files, and other structured/unstructured data formats.
  • ETL Development: Design, develop, and maintain ETL workflows using appropriate tools and technologies, ensuring data integrity, accuracy, and efficiency throughout the process.
  • Shell Scripting: Create and optimize shell scripts to support data processing and automation tasks related to ETL processes.
  • Database Management: Work extensively with Oracle databases, handling data manipulation, and optimizing performance for ETL operations.
  • SSIS Packages: Utilize SQL Server Integration Services (SSIS) to build and manage data integration solutions within the Microsoft SQL Server environment.
  • Performance Tuning: Analyze and optimize ETL processes to enhance performance, reduce processing time, and ensure scalability.
  • Data Quality and Cleansing: Implement data quality checks, data cleansing routines, and error handling mechanisms to maintain high data integrity.
  • Data Modeling: Collaborate with data architects and analysts to design data models that support efficient data retrieval and reporting.
  • Documentation: Create and maintain detailed technical documentation of ETL processes, workflows, and data mappings.
  • Troubleshooting and Support: Identify and resolve issues related to data extraction, transformation, or loading, and provide technical support to resolve any ETLrelated problems.
  • Security and Compliance: Ensure that data handling complies with relevant security and privacy standards and regulations.
  • Collaboration: Work closely with other members of the data engineering team, data analysts, business stakeholders, and IT teams to understand requirements and deliver data solutions effectively.

Requirements:

  • Proven experience as an ETL Engineer with a strong focus on data extraction, transformation, and loading processes.
  • Proficiency in designing and developing shell scripts for automation and data processing.
  • Expertise in Oracle databases and SQL, including data manipulation, performance tuning, and optimization.
  • Handson experience with SQL Server Integration Services (SSIS) packages.
  • Familiarity with data modeling concepts and best practices.
  • Experience in a banking environment is highly advantageous, particularly in understanding banking data structures and compliance requirements.
  • Strong problemsolving skills and the ability to troubleshoot complex data issues.
  • Excellent communication skills, both written and verbal, to interact effectively with technical and nontechnical stakeholders.
  • Detailoriented with a focus on data accuracy and integrity.
  • Bachelor's degree in Computer Science, Information Technology, or a related field. Advanced degrees or certifications in data engineering or database management are a plus.


This job description provides an overview of the typical responsibilities and requirements for a Senior ETL Engineer with experience in data extraction, transformation, and loading, as well as Oracle databases, SSIS packages, and the banking industry.

Argyll Scott Singapore Pte Ltd
EA License No. 16S8105
Koh Ching Wen (Xu Jingwen)

EA Reg No:
R1108631
  • Etl Dag Engineers

    2 weeks ago


    Singapore RESOURCE HUNT PTE. LTD. Full time

    ETL DAG Engineers - Onsite Prepare DAG Prepare Airflow based ETL Jobs Document architecture & technical design Analyze and implement Securities Services use case Implement required Securities for product data acquisitionBasic knowledge of Python, installing packages, and virtual environment.

  • Data Engineer(Etl)

    2 weeks ago


    Singapore NodeFlair Full time

    Job Summary:SalaryS$5,000 - S$6,500 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 7 yearsTech StacksETL Informatica Oracle play Teradata SSIS SAP Java MSSQL SQL C# PythonJob Responsiblities:Position Summary: ETL (Informatica), OAS Designer Responsible for ETL (Informatica), OAS Design, Development and data modelling capabilities to support EDW...

  • Etl Developer

    2 weeks ago


    Singapore NodeFlair Full time

    Job Summary:SalaryS$7,500 - S$9,500 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 6 yearsTech StacksETL Jenkins API Shell Script HDFS HBase Shell UNIX Git Java Hive Linux NoSQL Bitbucket SQL Hadoop PythonRole: ETL DeveloperExperience: 6 to 9 yrsKey Skills: Linux, Shell Script, SQL, Python, Java development, Control M, Remedy, JIRA, Bitbucket,...


  • Singapore Span Consultancy Pvt Ltd Full time

    kill Required: Senior level Talend ETL developments with hands on experience and strong knowledge on Talend ETL Tool (minimum 3 years+ above) Strong experience in advanced SQL programming Strong Talend job troubleshooting skills and finetuning jobs performanceJob Type: ContractBenefits: Health insuranceSchedule: Day shift Health insurance


  • Singapore Cognizant Technology Solutions Full time

    Cognizant is seeking an experienced ETL (SSIS/SQL) Developer to lead the implementation and execution of our ERP General Ledger (GL), Accounts Payable (AP), Asset Management (AM), and Billing modules. This full-time role based in Singapore has a favourable salary and the opportunity to explore flexible working arrangements.As an ETL (SSIS/SQL) Developer you...

  • Etl Lead Developer

    2 weeks ago


    Singapore Cognizant Full time

    Cognizant SingaporePosted 13 minutes ago Permanent Competitive ETL Lead Developer As the ETL Lead Developer, you will collaborate with crossfunctional teams, including data analysts, database administrators, software engineers, and business stakeholders, to understand requirements, implement solutions, and provide ongoing support. Your strong technical...


  • Singapore VUI SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description:ETL (Informatica), OBIEE Designer.To Perform ETL (Informatica),OBIEE Design & Development and data modelling capabilities to support EDW to deliver NHGPBI CR & Enhancements.Role and Responsibilities:Communication:Build strong relationships with Business Intelligence Analysts to understand business requirements and use...


  • Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you! Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful...


  • Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future...


  • Singapore NodeFlair Full time

    Job Summary:SalaryS$4,000 - S$8,500 / MonthlyJob TypeSeniorityMidYears of ExperienceAt least 3 yearsTech StacksETL Informatica Oracle Teradata SSIS SAP MSSQL SQLPOSITION GENERAL DUTIES AND TASKS:Minimum 3 years of experience in design, develop, deploy, and maintenance of BI solutionsEquipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server...

  • Senior Data Engineer

    2 weeks ago


    Singapore NodeFlair Full time

    Job Summary:SalaryS$7,000 - S$10,000 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 7 yearsTech StacksHANA ETL Snowflake AWS Data Extraction Analytics Teradata CI R RedShift Java Scala PythonThe Data and AI teams at TE are part of the TE Information Solutions (TEIS) Organization and Corporate Technology and are responsible for driving organic...

  • ETL Developer

    1 month ago


    Singapore D L RESOURCES PTE LTD Full time

    Roles & ResponsibilitiesKey Skills:Linux, Shell Script, SQL, Python, Java development, Control M, Remedy, JIRA, Bitbucket, Jenkins, Artifactory, Aldon, Open Source ETL DevelopmentAs an ETL Developer, the objective is to design, develop, and maintain efficient and scalable ETL processes to support data cleaning, integration, transformation, and loading...

  • Senior Data Engineer

    2 weeks ago


    Singapore NodeFlair Full time

    Job Summary:SalaryS$6,000 - S$7,700 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 2 yearsTech StacksStrategy HANA ETL AWS Oracle Analytics Google Cloud SAP MSSQL Hive SQL PythonDuties and Responsibilities Set up data infrastructure, data pipelines, integrate source system data with data lakes and data mining models into data pipelines. Design,...


  • Singapore NodeFlair Full time

    Job Summary:SalaryS$7,000 - S$8,500 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 7 yearsTech StacksETL Analytics Talend Cloudera Hive Impala Spark SQL PostgreSQL Hadoop Python Using the Talend ETL toolset, to create new and maintain existing ETL jobs. Design and implement ETL for extracting and transforming data from diverse sources, such as:...


  • Singapore NTT SINGAPORE PTE. LTD. Full time

    Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mapping Responsible for build of data mappings, sessions and workflows to meet requirements. Responsible for development of job schedules that integrate the upstream and downstream systems (e.g. Control-M)...

  • Data Engineer

    2 weeks ago


    Singapore INFOCEPTS PTE. LTD. Full time

    **What is a Data Engineer?The role of a data engineer can be defined as someone who has the knowledge and skills to design and build systems for collecting, storing and analyzing data at scale.Roles and Responsibilities: Drive the maintenance of data engineering pipelines Implement data engineering pipelines as per business needs and technical specifications...

  • Data Engineer

    2 weeks ago


    Singapore NodeFlair Full time

    Job Summary:SalaryS$4,000 - S$7,000 / MonthlyJob TypeSeniorityMidYears of ExperienceAt least 5 yearsTech StacksETL Analytics Hive Impala Spark kafka SQL Hadoop PythonRequirement 5+ years of relevant experience in data engineering/analytics space Expertise in SQL and data analysis and strong handson expertise with at least one programming language: Python....

  • Data Engineer

    2 weeks ago


    Singapore INFOCEPTS PTE. LTD. Full time

    Roles & ResponsibilitiesInfoCepts is a global leader of end-to-end data & analytics solutions with nearly 20 years of experience, also named as Gartner's 2020, 2021 and 2022 customers' choice for Data & Analytics providers. We continue to grow rapidly year over year, now employing more than 1,200 people in offices across the globe. As we have grown, we have...


  • Singapore Land Transport Authority Full time

    What the role is SENIOR / EXECUTIVE DATA ENGINEER / DATA ENGINEERWhat you will be working on You will be part of a team of data engineers deriving business insights from large and realtime datasets for strategic planning and operational efficiency. You will also be responsible for the team's projects to identify and explore suitable technologies, strategies...

  • Data Engineer

    2 weeks ago


    Singapore TIKTOK PTE. LTD. Full time

    **ResponsibilitiesAbout TikTokTeam IntroductionThe mission of the Data Platform Singapore Business Partnering (DPSG BP) team is to empower the TikTok Business with data. Our goal is to build a Data Warehouse that can cater to batch and streaming data, Data Products that provide useful information to build efficient data metrics & dashboards which will be...