Deskripsi pekerjaan Data Engineer (ETL) PT. Citta Parama Guna
BACKGROUND
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. d in SSIS, and Informatica as well.
JOB 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
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 on 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.
Qualifications
- Minimum 3 years of ETL experience with SSIS and Informatica
- Experience with SSIS AND INFORMATICA
- Background in Banking, Insurance, Financial Services a plus
- Computer Science or Engineering Background
