Advanced Data Engineer. (KSO3BY)

Responsibilities:

• Conduct meeting with users or business analyst to understand the data requirements and perform database design based on data understanding and requirements with consideration for performance
• Work with business domain experts, business analyst, and application developers to identify data that is relevant for analysis
• Develop and test SQL stored procedures and functions for ETL processing
• Own end-to-end data ETL process framework from source systems to result output and data exchange with peripheral systems, with process alignment to company policies
• Develop reusable for Data wrangling which improved processes
• Develop batch processing with large volume data sets
• Evaluate business needs and objectives
• Select and integrate appropriate tools and frameworks required to provide requested capabilities
• Design and develop BI (report) solutions
• Maintain data dictionary, relationship and its interpretation
• Analyze problem and find resolution, as well as work closely with administrators to monitor performance and advise any necessary infrastructure changes
• Provide day to day support for Oracle OFSAA Applications
• Keep abreast of new developments in the big data ecosystem and learn new technologies

Job Qualification Qualifications:

Required Skills

• Bachelor's / Master degree in Computer Engineer, Computer Science, Information Technology, Mathematics, Statistics and/or related fields
• 5+ years of experience using PL-SQL
• 5+ years of experience in database design, data integration, data pipeline development, big data, business intelligence (reporting) applications
• Working knowledge of data warehouse, data models, performance tuning, Hadoop, RDBMS, preferably Oracle database

Financial application & skills

• Advantage skills
• Knowledge of Linux, shell, script, Java, Cloud technologies
• Experience in reporting tools, preferably OBIEE
• Banking & finance business experience, understand Oracle OFSAA is a big plus
• Knowledge of Oracle database administration and performance tuning

Competencies

• Strong skills in critical thinking and analysis
• Effectively work independently and handle multiple priorities
• Good team player
• Good written and verbal communication skills in English and Thai.
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
• Willing to support off-hours at times