ETL Developer

at  SAKSOFT PTE LIMITED

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

• 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 schedul