LOCATION: Warszawa
At intive we believe that emerging digital technologies make life easier. Therefore with more than 1000 people on board we are helping forward-thinking enterprises to design and build smart applications, software solutions and turn ideas into digital reality all around the world.
To achieve best results we are constantly challenging assumptions and establish approaches following our company motto - never settle.
PL / SQL Developer
Ref. No.: PL/SQL/DEV/WAW/0419/PR
You are a good match if you:
- Have around 5 years of experience with Oracle Databases, PL/SQL, and ETL,
- Have solid knowledge and experience with SQL and PL/SQL
- Have solid knowledge and experience in building and maintaining Data Warehouse structures
- Have strong command and experience in data governance, data management, data structuring
- Have strong knowledge and experience with Oracle database (including DDL, DML, DCL, TCL, data modelling, query optimisation, database instance tuning).
- Have experience on ETL processing (preferably Informatica Powercenter), interfaces designing and development, integration).
- Have experience with requirements specification and business analysis.
- Are able to work in a SCRUM team and focus on delivery
You get extra points for:
- Different types of interfaces (file transfer, queues, WebServices) knowledge
- Processes designing and processes to systems’ components mapping experience
- MS SQL database knowledge and experience
- Java/.NET programming
- BI, BA, and Big Data concepts knowledge
You will be responsible for:
- Requirements analysis together with business.
- Facilitating the formulation of requirements by providing optimal data models, advising in data requirements specification, advising in systems architecture and designing, etc.
- Designing and developing database structures based on the requirements.
- Designing and developing the most optimal data flows among systems.
- Assuring architectural consistency of the data models and interfaces across the systems
- Supporting the reporting team in aligning data models and interfaces to the team’s needs, support reports optimisation.
- Supporting testing, test automation and data quality improvement process.
- Supporting existing and new queries optimisation.
- Supporting database performance improvement.
- Supporting knowledge transfer and knowledge transfer documentation.