Software Engineer - Philippines, Pilipinas - Digital Room

Paglalarawan

Primary Duties and Responsibilities:

• Design, build, test and diagnose data ETLs and integrations (webservices, FTP, etc.) to facilitate data exchange between the third-party applications, relational databases, analytics platforms, the company's data warehouse and data lakes
• Utilize cloud computing technology (map reduce, containers, serverless code, etc.) to build scalable, resilient and fault-tolerant applications
• Collaborate with data architects and reporting analysts in the design, implementation and documentation of OLAP and OLTP data structures
• Extract data from external data sources via API (ex. Google Feeds, Facebook, etc.)

Skills:

• Programming Languages: Python (required), NodeJS/TypeScript (desired) and BASH/Shell (desired)
• Design and optimization of columnar warehouses (OLAP) warehouses (i.e. Redshift); Data Lake technologies including Lake Formation, Athena, Glue, Redshift Spectrum, Apache Hive
• Design and optimization of relational (OLTP) databases (i.e. RDS, Aurora)
• Scaling AWS ETLs using Elastic MapReduce (EMR), Lambda and Elastic Container Services (ECS), Database Migration Service (DMS)
• Monitoring and alerting of ETLs using CloudWatch metrics and alerts
• Change Detect Capture (CDC) data ingestion (i.e. binary log monitoring)

Education and Experience:

• Bachelor's degree in computer science or related field
• At least 3 years of working experience in development of scalable ETLs in the AWS stack using the technologies listed under Skills
• Detail and task-oriented with a strong work ethic and ability to work independently in a deadline driven environment
• Excellent oral and written communication skills