Data Engineer

Salary 84000 - 96000 SGD
Number of positions to fill : 1
Reference number : 8723

Employment terms
Permanent
Length of employment
permanent
Employment date
2018-09-20
Location
singapore
Education
degree
Years exp required
5

Description



We are hiring for the position of Data Engineer role with one of the leading client based out in Singapore.

Job Responsibilities

  • Designs and creates information store / data warehouse and all related extraction, transformation
  • Develops logical and physical data flow models for ETL applications. Translates data access, transformation and movement requirements into functional requirements and mapping designs
  • Plans and conducts ETL unit and development tests; monitors results and takes corrective action, when necessary
  • Plans, coordinates and implements security measures to safeguard data in information store / datawarehouse against accidental or unauthorized damage, modification or disclosure
  • Create SSIS packages based on mapping document
  • Unit test & optimize SSIS package according to business needs
  • Document technical details of ETL project in Excel & word documents
  • Code maintenance in TFS (Branching/Merging)
  • Minimum 5 yrs. exp. working on MSBI Stack (SSAS, SSIS, SSRS)
  • Minimum 5 yrs. exp. working on SQL Server, DB2, Oracle databases
  • Working knowledge of modeling tools (Erwin, Embarcadero, EA Sparx etc.) in addition to hands-on experience with business intelligence tools
  • MS SQL Server 2008 R2 - FastTrack Data Warehouse
  • Databases - DB2, SQL Server, Oracle (Must be able to write complex queries against these DBs)
  • SQL Server Integration Services (Writing efficient SSIS packages)
  • Any data replication tool (preferred: MS SQL Server, DT Share)
  • Writing complex & efficient Stored Procedures, Views, Functions in MS SQL Server
  • Optimizing complex SQL queries for optimum performanceSetting up schedule jobs using Windows Scheduler or SQL Agent



Interested, please send over your resume to recruitment at aryansearch dot com / andy@aryansearch.com or call at 65 67087429 Ext 202 for a confidential discussion.

Apply Now

* fields are required.

Back to jobs list

Powered by