ETL Developer
Posted Updated
Summary
ETL Developer in Bangkok building ETL/ELT data pipelines with Microsoft SQL Server, SSIS, and Talend, including .NET/C# components, advanced T-SQL tuning, and data warehouse design (staging, ODS, marts), while helping migrate data workloads to AWS.
- Developing ETL & ELT processes to support key business data flows using Microsoft SQL Server and Microsoft SQL Server Integration Service (SSIS) or Talend tool.
- Developing .NET, C# inside SSIS component as required.
- Be able to consolidate and transform data application from data center to AWS could.
- Be able to code languages (e.g. AWS CloudFormation, Jaya, Python, DevOps, other tools).
- Developing advanced T-SQL to manipulate data with very good performance.
- Tuning, debugging & solving of complex T-SQL, SSIS data transformation (ETL and Talend ETL tool.
- Support all technical issues related to the development from the team.
- Designing and Developing multi-dimensional data models to store key business data and enable BI reporting and high order analytics in Microsoft SQL Server
- Designing Staging Areas, ODS Areas, Data Warehouses and Data Marts
- Administering BI ETL/ELT & Staging Area Systems and Providing/Delegating support as required for these Systems.
- Engagement with business to understand the business drivers
- Work with source system developers to enable efficient, robust and scalable data flows
- Work with key business personnel to deliver objectives
- Able to coordinate with functional team and/or customers to understand current processes and capabilities
- Coordinating solution designs incorporating input from Supply Chain Team Solutions team in accordance with agreed engagement processes and methodologies
- Coordinating the preparation of relevant documentation and manage associated peer review processes