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
