You will be responsible for data integration, data mashing from multiple systems, warehouses to the centralized Heroku Postgres database
Additionally you will conduct development of new Postgres queries, functions, procedures in PL, pgSQL in order to expose data to Salesforce Cloud Platform (json input/output)
In your daily task there will also be a place for reports preparations with the aim to show specific relations between data sets from multiple systems and give important insight to business
Administration of Postgres database, tuning and monitoring its performance will also be part of your common duties
Finally you will be accountable for new data structures creation for current andnew data sets coming to Centralized Postgres Database
Must have
Postgres – exceptional experience especially in optimization of complex queries or complex
PL/pgSQL code, must have SQL skills, knowledge about postgres DB tuning and Postgres DB performance optimization
Experience in data integrations across multiple systems, platforms with usage of ETL/ELT tolls (like Informatica, Oracle Data Integrator, Xplenty, Talend, Pentaho, anything else) – important is to have at least one so it can easily adapt to other with help
Nice to have
Good Knowledge of JSON
Experience in working in SOA (Service oriented architecture) environment
Experience with Oracle (PL/SQL mainly)
Our offer
Possibility to attend internal and external training
Relocation package (4500 PLN total value), paid in three installments (1500 PLN per month)
Referral bonus (2000 PLN total value)
Benefits: Extended medical care (over 2000 medical facilities in Poland, 80 in Kraków) for you and your family; Multisport Benefit card; life insurance
Remote work option
High standard facilities, kitchen or easy access to food-courts or restaurants; comfortable location, easy access by public transport, parking for bicycles
This recruitment is carried out on an external website. After clicking the button above, you will be redirected to the recruiter page where you can continue the recruitment process.