Data Engineer

Contractual : 6 months

Work Location: Makati

Work schedule: Dayshift | hybrid (atleast 3X a time onsite)

Salary Offer: Php87,000 basic plus 3K NTA)

Primary Technologies:MSSQL, PostgreSQL on Azure; SSIS, ADF, Python

Job Description: Data Engineer

Position Overview:We are seeking a skilled Data Engineer to join our team. The successful candidate will be responsible for data migration, data replication, and system implementation, ensuring high-quality data management and integration processes.

Key Responsibilities:

Data Migration:

• Perform data migration from one system to another, involving data matching, mapping, cleaning, and writing queries.
• Execute data loading and conduct post-load validation to ensure data integrity and accuracy.

Data Replication:

• Enable data replication from the target system to PostgreSQL on Azure.
• Convert source system data to CSV format and place it in S3
• Utilize Azure Data Factory (ADF) to pull data into PostgreSQL on Azure SQL.
• Run queries in PostgreSQL to generate reports and extracts as needed.

System Implementation:

• Participate in the implementation of new systems, utilizing a base Entity-Relationship Diagram (ERD) while customizing it based on specific business requirements.