DESCRIPTION
Company with a multinational environment based in Olomouc, Czech Republic, providing complete services in the field of development, integration and support of information systems to client's group with presence in Europe, Middle East, Asia, Latin America and Africa. Its employees have access to the latest technologies and tools, such as Microsoft Azure, Sharepoint, Sitecore, IFS, JDA, Software AG webMethods, censhare, Oracle etc. so they can enjoy designing and developing applications.
RESPONSIBILITIES
- Development of the data warehouse
- Proposing architecture of the new modules
- Design of the ETL processes
- Developing and amending stored Oracle procedures/functions/transformations
- Writing Oracle PL/SQL and SQL code to implement business logic
- Participation in phases of data warehouse development lifecycle
- Gathering the requirement by collaborating with business unit liaisons to understand and develop business and functional requirements
- Performs technical analyses for development of new features
- Testing, implementation and support
- Performance tuning of the data warehouse
- Monitoring database performance and tuning SQL queries in a cooperation with DB administrators
- Identifying and resolving scalability and data quality issues
- Ad-hoc analysis and data extractions
- Maintains the knowledge base and follows documentation process rules
REQUIREMENTS
- Technical skills – must have
Ability to write software code in database environments:
Oracle Database
- PL/SQL proven knowledge is essential
- Data warehousing and ETL principles
- Experience with RDBMS performance tuning, partitioning and indexing strategies, materialized views management
- ETL knowledge
- Deep understanding of Data warehousing ETL principles
- Experience of work with huge volumes of data
- Expertise in ETL processes design and implementation, data lifecycle management
- Technical skills – desirable
- Experience of working on large projects / large and complex systems.
- Oracle DBA experience Knowledge of Microsoft SQL Server and -Microsoft Azure technologies
- Hadoop and Big Data experience
- Experience with IBM Cognos BI or other business intelligence tools
- Experience with Data Science (Predictive Analytics, Machine learning, R)
- Knowledge of Agile and iterative methodologies like SCRUM, KANBAN
- Experience of work with Source code control (CVS, SVN, TFS)
- Experience with any ETL tool
- Education
- At least 5 years of experience in IT
- At least 3 years of experience working with Oracle Database
- English written, spoken level B1
WE OFFER
- Competitive salary
- Annual bonus connected to company performance
- Relocation package (if coming to Olomouc from abroad)
- Lunch fully paid, office refreshment
- Strong work/life balance, flexible working hours
- 5 weeks paid holiday
- Client's products for free
- Company mobile phone tariff with contribution (available to family members)
- Employee referral program
- Company team-building activities
- Onsite training about client's business, system architecture & technologies
- Position in an international environment with informal friendly atmosphere
- Opportunity for short-term assignment abroad
- Work in attractive UNESCO listed historical town, enjoying active outdoor life style in quiet environment IT
