In short
Builds async Python REST services with FastAPI and Pydantic, backed by PostgreSQL through a modern 2.0-style ORM, plus Dremio and Snowflake accessed via PyArrow/Arrow Flight. Day to day involves REST API design, Liquibase (Maven-based) schema migrations, and pytest testing with unittest.mock. On-site in Manila.
About the role
PostgreSQL(Dremio (via pyrow flight), Snowflake.
Skills required:
- 1. FastAPI - All service is async FASTAPI apps with pydantic models for request/response.
- 2. ORM for PostgreSQL - the project uses modern 2.0-style with mapped classes and relationship loading strategies.
- 3. Rest API Design, error handling with structured responses.
- 4. Database Migration - Liquibase with XML changesets, schema change go through maven-based Liquibase.
- 5. Pyarrow/ ArrowFlight and Testing pytest and mocking with unittest.mock
Requirements
- FastAPI — async FastAPI apps with Pydantic models for request/response
- ORM for PostgreSQL using modern 2.0-style mapped classes and relationship loading
- PostgreSQL, Dremio (via PyArrow Flight), Snowflake
- REST API design with error handling and structured responses
- Database migrations with Liquibase XML changesets via Maven-based Liquibase
- PyArrow / Arrow Flight
- Testing with pytest and mocking with unittest.mock