Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9tywluc3rhes1hc2lhl2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

ETL Lead Developer

ETL Lead Developer

Job Title: ETL Lead Developer
Contract Type: Perm
Location: Hong Kong
Industry:
Reference: 1684
Contact Name: Mary Delfin
Job Published: May 28, 2020 16:37

Job Description

Our client, a leading Global insurance company, is seeking a seasoned and experienced ETL Lead, who will be responsible to manage a team of Junior ETL Developers in the technical design and implementation of multiple ETL’s, taking place due to an extremely large transformation due to new major changes to Financial regulatory processes. The role will require the management and delivery of multiple data oriented projects across a large and lengthy roadmap across the APAC Region.  

 

Responsibilities of the Role:

 

  • Analyse and interpret all complex data across all target systems and analyse and provide resolutions to all data issues. Coordinate with data analysts to validate all requirements.

  • Use SSIS to design and implement multiple ETL’s across the programme.

  • Work closely with the various functional teams in analysing the business and the various functional requirements needed.

  • Develop all data warehouse models and prepare reports for all meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.

  • Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.

  • Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

 

Required Skills for the Role:

 

  • Graduate qualifications in computer science, engineering or equivalent mandatory. 

  • At least 10 years of experience in an Enterprise IT environment, with proven experience in developing ETL frameworks/platforms, using SSIS and SQL Server databases.

  • Knowledge in Microsoft Azure services and components, e.g. Data Lake, ADF, etc. is highly advantageous. 

  • Must have a good understanding of Database Designs and Data Models.

  • Excellent command in spoken and written English is a must have.

If interested, please send your most updated cv in word format to mary@mainstayasia.com with ETL Lead in the subject line.