ETL Developer

Saksoft logo

Saksoft

View Salaries, Reviews, and more  

Job Summary


Salary
S$7,000 - S$9,500 / Monthly

Job Type
-

Seniority
Senior

Years of Experience
At least 6 years

Tech Stacks
Python Hadoop SQL Bitbucket NoSQL Linux Hive Java Git UNIX Shell HBase HDFS Shell Script API Jenkins ETL

Job Description

Role: ETL Developer

Experience: 6 to 9 yrs

Key Skills: Linux, Shell Script, SQL, Python, Java development, Control M, Remedy, JIRA, Bitbucket, Jenkins, Artifactory, Aldon

Key Responsibilities:

• Participate in end-to-end projects for system implementation of MLS system

• Engage and collaborate with Architects, Security and Development Lead to ensure solution design complies with enterprise design principles, security, and control standards

• Liaise with application teams across group and countries build the enhancements according to the technical solution plan

• Coordinate with Technology Delivery Manager and System Analyst to plan technical deliverables and schedule, perform design and development works to meet project requirements, and produce technical documents

• Escalate issues that impacts project schedule on timely basis and propose workarounds/resolutions

• Perform data profiling, cleansing, transformation and validation to ensure data quality and integrity throughout the shell scripts and ETL pipelines

• Test, maintain and recommend software improvements to ensure strong functionality and optimization

• Create and maintain technical documentation, including ETL specifications, data mappings, data dictionary, process workflows, data ownership and error handling procedures

• Implement project change request and in accordance with deployment schedule

• Partner with Test Management teams to ensure completion of SIT, UAT, performance / load testing and application security testing with quality result

• Facilitate and provide technical and testing support before and after production deployment

• Collaborate with cross-functional teams, such as data scientists, analysts, and business users, to understand their data requirements and provide support as needed

• Work with production support team members to conduct root cause analysis of issues, review new and existing code and/or perform sanity testing and unit testing

• Liaise with other units across IT and Business in the organization

• Manage external vendors for project delivery within schedule

Key Requirements:

Must Have

• Bachelor's degree in computer science, information technology, or a related field

• At least 8 years of experience and knowledge in Control M, Unix Shell Scripting, and SQL

• At least 8 years of experience and knowledge in deployment process, create, manage and maintain CICD from source code repository, version control, code merge to deployment and housekeeping

• At least 6 years of experience in Hadoop, Hive, Hbase, HDFS and Data Engineering

• Experience in Bitbucket, Git, Jenkins, Artifactory and Aldon

• Experience in JIRA, Remedy and Incident Ticket management

• Ability to multitask effectively and handle large amounts of data

• Highly driven, pro-active and a strong team player

• Excellent interpersonal skills and written and verbal communication skills in English

Good to Have

• Experience in Python, Java, NoSQL

• Experience in System Interfaces (SFTP, FTP, Connect Direct, API, Rest)

• Experience in Confluence and SharePoint


Interview Questions of ETL Developer at Saksoft

Currently, there aren't any interview questions for this role at Saksoft shared by other job seekers.
View more interview questions of similar roles from other companies →
Unlock Your Interview Potential
The only end-to-end front end interview preparation platform by FAANG ex-interviewers and Staff Engineers.
Get hired at FAANG
Users now work at:

Achieve your dream job with our top-notch tools!

Resume Checker Illustration

Resume Checker

Our free resume checker analyzes the job description and identifies important keywords and skills missing from your resume in just a minute!

Check Now
Interview Preparation Illustration

AI InterviewPrep

Utilizing advanced AI, our tool generates tailored interview questions based on your industry, role, and experience. Practice and receive feedback on your answers in real time!

Check Now
Resume Builder Illustration

Resume Builder

Let us show you the differences between a bad, good, and great resume, and guide you in building a resume that helps you stand out to employers, ensuring you land your next position faster!

Check Now