25 June 2021
Our client within the leading IT consulting industry is looking for a Technical Support Specialist ETL to be part of their Application Maintenance Support Team.
- Degree holder majoring in Business, IT, Computer Science or equivalent;
- Minimum 1 year of experience working with SSRS,SSAS,SSIS and ETL / Data warehouse;
- Good experience with BI Data Warehouse solution implementation using MS SQL Server 2008/ 2008 R2;
- Handled complex data warehouse structures;
- Prior experience in MS SQL, ETL data processing, e.g. Informatica, SSIS, etc., and Dashboard / reporting, e.g. Cognos, SSRS, Qlik;
- Knowledge in using ETL tools to extract data from multiple data sources;
- Ability to provide production support for the existing applications on 24/7 basis when required;
- Excellent communication and coordination skills, and able to work well with cross-organizational teams;
- Strong analytical & problem solving skills.
- MSBI ( SSIS, SSRS, and SSAS ) Certification.
- Act as a technical specialist for reports and data warehouse track;
- Manage daily and monthly processing and maintenance of Data Warehouse and SSAS;
- Provide production support for the existing Cognos reports, dashboards and be a part of application maintenance support team;
- Responsible for application testing and closure of application defects;
- Create, enhance and maintain Framework Manager models to support business requirements;
- Design and develop Cognos BI 10.2.1 reports using Report Studio and work space advance;
- Design, implement and administer Cognos securities;
- Provide resolution to issues and problems reported;
- Perform service requests and ensure the SLAs are achieved;