Job description for Data Warehouse at PT Vertex Nexlink Solusi
Data Warehouse min 3 tahun
"Minimum qualifications
• Fluent in English communication.
• Minimum 3 years of experience as a Data Warehouse Developer or ETL Developer.
• Experience in learning, developing, and maintaining legacy Data Warehouse is a plus.
• Capability to develop complex logic in Oracle SQL and PL/SQL with focus on handling data.
• Having knowledge and experience in ETL process.
• Knowledge on business processes and requirements which DWH supports.
• Awareness of data governance principles and practices to ensure data quality, compliance, and consistency.
• Knowledge and experience in Oracle Golden Gate.
• Able to work in Agile mode.
• Analytical thinking
• Strong tooling skills such as:
o PL/SQL Developer
o Apache Nifi
o Gitlab
o TortoiseSVN or similar versioning tools
• Analysing DWH related requirements and creating documentation for development.
• Providing ER diagram of modelled DWH area.
• Creating test scripts based on expected business logic.
• Developing, testing, documenting and deploying database changes running on premise on Oracle DB.
• Participating in issue solving. Identify the problem, fix the immediate impact and investigate the root cause.
• Providing refactoring suggestions i.e able to decide if a data belongs to DWH or Data Mart, normalization, etc.
Minimum qualifications
• Fluent in English communication.
• Minimum 3 years of experience as a Data Warehouse Developer or ETL Developer.
• Experience in learning, developing, and maintaining legacy Data Warehouse is a plus.
• Capability to develop complex logic in Oracle SQL and PL/SQL with focus on handling data.
• Having knowledge and experience in ETL process.
• Knowledge on business processes and requirements which DWH supports.
• Awareness of data governance principles and practices to ensure data quality, compliance, and consistency.
• Knowledge and experience in Oracle Golden Gate.
• Able to work in Agile mode.
• Analytical thinking
• Strong tooling skills such as:
o PL/SQL Developer
o Apache Nifi
o Gitlab
o TortoiseSVN or similar versioning tools"
