Responsibilities / Job Description :
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
Workplace :
Type Business :
Insurance
Job Type :
Full Time
Job Group : computer - it - programer
Work At (Location) : Bangkok
Area :
Bang RakApply MS SSIS Developer , Bangkok - Job | Apply Company Jobs Thailand at JOBSIAM.COM :- MS SSIS Developer บริษัท นวกิจประกันภัย จำกัด (มหาชน) Job, JobBangkok MS SSIS Developer,Bangkok Job MS SSIS Developer, Apply MS SSIS Developer บริษัท นวกิจประกันภัย จำกัด (มหาชน)
Salary :
Qualifications :
Male/Female
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