Senior ETL Engineer: SQL, Python & Data Warehousing

Questronix Corporation; Pasig; On-site; PHP 892,800 - 1,116,000; Full time

Job summary

A technology solutions company in Metro Manila is seeking an experienced Data Engineer. You will develop SQL queries and handle various data formats to meet business needs. The ideal candidate has over 5 years in data engineering, strong SQL and Python skills, and experience with ETL tools. Join us to lead projects in a collaborative environment.

Qualifications

• 5+ years of experience in data engineering or similar roles.
• Proficiency in SQL and relational databases.
• Strong programming skills in Python.
• Experience with ETL tools and data pipeline frameworks.

Responsibilities

• Develop ANSI SQL queries and handle semi-structured data formats.
• Utilize querying tools for distributed systems.
• Transform data to meet business needs.
• Lead cross-functional teams on projects.

Skills

SQL proficiency

Python programming skills

ETL tools experience

Data warehousing knowledge

Stakeholder management

Education

Bachelor's degree in Computer Science or related field

Tools

Apache Airflow

Talend

Informatica

Job description

Job Description:

• Being able to understand and develop ANSI SQL queries;
• Being aware of handling other semi-structured data formats – JSON, XMLs, HTMLs etc;
• Being comfortable in querying tools for distributed systems such as Hive, Impala and other SQL clients (RDBMS, Python, Scala etc.);
• Being comfortable in handling transforming data to suite business needs;
• Being able to handle tools for data transformation and/or ETL through tool-based and code-based development – ex. Informatica or Talend for tool based / Spark or MapReduce framework in Python or Scala/Java for code-based development;
• Having a background on data warehousing and reporting technologies

Qualifications:

• 5+ years of experience in data engineering or a similar role.
• Bachelor's degree in computer science, Information Technology, or a related field.
• Proficiency in SQL and experience with relational databases.
• Strong programming skills in Python.
• Experience with ETL tools and data pipeline frameworks (e.g., Apache Airflow, Talend, Informatica).
• Knowledge of data warehousing solutions like Snowflake or Redshift.
• Good communication and stakeholder management skills
• Root cause analysis
• Business requirements gathering
• Capable of leading cross functional teams in order to deliver projects and initiatives