Position: Python Developer with strong PostgreSQL experience
Company: Catware
Experience required: 3y
Category: Python
English level: upper
Published: 2021-09-01T00:00:00+03:00

**Integration project work details**

 - Source: Veeva Vault. Using Python (pandas), SQL and other methods, adapt an essentially dynamic ELT code base to create and update tables in a destination PostgreSQL DB.
 - The dynamic code base exists already but has a somewhat different purpose
 - The Fallback Solution name originates from the fact that the main API is Mulesoft (REST) but certain integration counterparts are only compatible with SQL. Hence we need a presentation layer based on SQL to present the Veeva data.


**Profile we're looking for**

 - PostgreSQL developer 
 - Python 
 - Mulesoft API knowledge would be an advantage


Required competencies:

 - Strong Python data structures understanding (under the hood all the metadata juggling is all python lists/dicts etc)
 - Strong both design and hands-on (as the developer has to see the pipeline working end to end and not just for one object type)
 - Hands on with Postgres
 - Object Oriented Programming (OOPs) - the metadata management code can be complex so better to implement it with OOPs to simplify (that's how its done in the EDC pipeline)