Data Engineer
Malaysia
Job Type
Full Time
About Us
Our client, which is one of the largest Malaysian Commercial Banks is looking for experienced ETL developers to assist with the migration of the data. The ideal candidates will have significant ETL development experience and good knowledge of SSIS and Informatica.
About the Role
Building/interpreting design documents
Building/interpreting mapping documents
Building/completing test documents
Participate in technical design reviews and code reviews
Understand and adhere to ETL best practices
Develop and troubleshoot Informatica code
Writes advanced SQL including some query tuning
Qualification
Minimum 3-5 years of ETL experience with SSIS and Informatica
Experience with databases (Oracle, Teradata) migrations
B.S. in Computer Science, Information Systems, or equivalent
Background in Banking, Insurance, and Financial Services is a plus
Malaysian Citizens, PR, Foreigners with EP
Requirements
Experience designing and building complete ETL (moving and transforming data) in either of these technologies : SSIS/Informatica
Writes advanced SQL including some query tuning
Experience in the identification of data quality
Some database design experience and knowledge of data models is helpful
To be proficient in designing efficient and robust ETL workflow
Utilise ad-hoc techniques to perform on-the-fly analysis of data
Proficient in how to deploy to and debug a production environment
Experience with real time and batch data ingestion frameworks
Experience with API development and use of JSON/XML/Hypermedia data formats
Prefer Data management or data modeling experience within Big Data (Hive/Impala/Hbase)
Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW
Python Programming experience
Hands experience with open source software platforms Linux
Agile development processes experiences a plus
Strong leadership, interpersonal, influence, negotiation, and written and verbal communication skills required