Job Description
・Create, modify, and delete objects/tables in S3 buckets, including the raw, clean, curated zones, and the consumption layer (Redshift Cluster).・Develop and execute Glue Jobs scripts for Extract, Transform, Load (ETL) processes, ensuring efficient data transformation across the entire dataset in the Data Lake.・Determine appropriate actions, such as tokenization, to be applied in the raw zone for immediate data processing.・Set up dataset alarms to monitor the data pipeline and define notifications for missing data ingested.・Collaborate with stakeholders to determine data transformation requirements for selected datasets within the Data Lake.・Apply data standardization techniques in the clean zone to ensure consistent and reliable data quality.・Create snapshots in the clean zone to capture data at specific points in time for analysis and auditing purposes.・Design and develop data models in the curated zone, optimizing data structures for efficient access and retrieval.・Define tables/objects in the curated zone to support Salesforce usage, ensuring data integrity and compatibility.・Identify and create tables/objects in the curated zone and the consumption layer (Redshift Cluster) for Tableau standard access.・Determine tables/objects to be included in Redshift Spectrum for Tableau advanced access, enabling advanced data exploration and analysis.
Benefit
・REGARDLESS OF EMPLOYMENT STATUS
-HMO
-Medicine Allowance
-Group Life Insurances
-13th months payment
-SL:15 days
-VL:15 days
※Each employee will earn 1.25 days of VL and 1.25 days of SL after a month of service. However, a total of fifteen (15) days VL and fifteen (15) days SL will be made available to employees at the start of the year.
-Maternity Leave : 105 Calendar Days / 120 Calendar Days-Single Parent
-Bereavement Leave:3 days
-Daily Subsistence Allowance
-Transportation Allowance
-Japanese Language Allowance (For employees with N4-N1 JLPT Certification)
-Miscellaneous Benefits
※P 2,500.00 worth of flower arrangement or mass card and P 5,000.00 Financial Aid (given to employees who have lost an immediate family member)
・UPON REGULARIZATION
-Birthday Leave:1 day
-Calamity Leave:2 days
-Loyalty Incentive
※Cash incentive amounting to 1/12 of the total basic salary on the 3rd, 5th, 7th, 10th, 13th, 15th, 17th , 20th year of tenure.