รายละเอียดตำแหน่งงาน / คำบรรยายลักษณะงาน :
Responsibilities:
? Gathers business requirement and translating them to technical specifications
? Create SSIS Packages to load data from various sources to SQL Server Database by performing different kinds of transformations using SQL Server Integration Services (SSIS)
? Create SSIS jobs and responsible for ETL job schedule to run daily. Solve the issues associated with ETL Data Warehouse Failure
? Implement Error Handling and Logging for packages using SSIS
? Implement the logical and physical design of the data warehouse
? Perform Performance Tuning of Code using execution plan and SQL profiler to improve performance on tables
? Continually reviews/analyzes data loaded into the data warehouse for accuracy and provides solutions for enhancing data accuracy and data processing performance
ชาย/หญิง Minimum 5 years? experience of SQL development and report writing experience, ETL development with SSIS experience, data warehouse design and data integration
Experience working with SSAS creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
Good knowledge in Data warehousing architecture and design
Ability to learn and apply new technologies and keeps current with best practices
Strong SQL coding experience with performance optimization experience for data queries.
Experience working with Power BI, QlikSense or other reporting tools is a plus