Design and implement ETL processes in support of business analytics and reporting; Support and improve production data integration system and environment; Design and develop enterprise and departmental Business Intelligence and data warehousing solutions; Create source-to-target mapping specifications for ETL development; Follow established coding standards, perform code reviews and improve standards to assure compliance; Collaborate with project leads, business analysts, end users and third-party contacts to design, implement and test data warehouse applications; Develop and perform unit, system, performance and regression testing on ETL mappings.
Experience in multiple database platforms, including SQL Server, Oracle and DB2; Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI); Strong analytical skills to troubleshoot issues and identify resolutions; Available for off-business hours implementation and support; 8+ years of data-related experience; Bachelor’s degree in IT or related major; Hands-on experience in writing complex T-SQL and database performance tuning; Microsoft Certification in Azure Data Solutions is preferred; Excellent knowledge of relational data modeling (ERD), SQL and data warehousing; Experience working with offshore resources is desired; 10+ years of experience in designing and implementing data warehouses, at least 4 years with Cloud data warehouses; A Bachelor s Degree in a technology area of study, preferably in Computer Science, MIS or Analytics; Experience with Informatica Cloud application integration (ICRT) tool is desired; 8+ years of hands-on ETL development experience using Informatica integration tools, PowerCenter and Informatica Cloud; Excellent knowledge of relational Datamodelling (ERD), SQL and data warehousing.
Konsultan
http://www.adidata.co.id/
622153660016
20-50
monday - friday
Formal
Medical
Indonesian
Gedung Graha Kencana 7th floor, Jl. Raya Pejuangan No. 88, Jakarta 11530. Indonesia