Senior Oracle ETL/BI Developer - 20454
Veritaz AB · Stockholm · 6 månader – upp till 12 månader · Deadline 2026-11-27
Veritaz AB is seeking a **Senior Oracle ETL/BI Developer** for a consulting assignment with a client. The position focuses on translating business requirements into scalable, high-performing data integration and business intelligence solutions within a complex enterprise IT landscape. Key responsibilities include designing, developing, and testing complex ETL processes using **custom-built code** rather than dedicated platforms, building dimensional data models, and writing advanced Oracle SQL using analytic functions and hierarchical queries. The consultant is also responsible for tuning database performance through partitioning, indexing, and query optimization, while managing code via Git and contributing to activities in Unix/Linux environments. Applicants must have senior-level experience in Oracle-based ETL and BI development alongside strong business analysis abilities. **Previous experience in subscription-based industries** with complex IT architectures—such as telecommunications, banking, or insurance—is required. Technical prerequisites include deep knowledge of Oracle Database architecture, custom ETL implementation, dimensional data modelling, practical Git use, and basic Unix/Linux proficiency. Knowledge of Apache Airflow, Oracle REST Data Services, and Oracle Enterprise Manager is also expected.
Veritaz is a leading IT staffing solutions provider in Sweden, committed to advancing individual careers and aiding employers in ensuring the perfect talent fit. With a proven track record of successful partnerships with top companies, we have rapidly grown our presence in the USA, Europe, and Sweden as a dependable and trusted resource within the IT industry.
Job Overview
Role Summary
Our client is seeking a Senior Oracle ETL/BI Developer for a consulting assignment focused on developing and optimizing complex data integration and business intelligence solutions. The role requires deep expertise in Oracle Database architecture, advanced SQL development, custom-built ETL processes, and dimensional data modelling. The consultant will translate high-level business requirements into functional, maintainable, and high-performing data solutions within a complex enterprise IT environment.
Key Responsibilities
- Design, model, develop, and test complex ETL processes using custom-built code rather than dedicated ETL platforms.
- Translate high-level or simplified business requirements into robust, maintainable technical implementations.
- Develop advanced Oracle SQL using capabilities such as analytic functions and hierarchical queries.
- Optimize Oracle Database performance through indexing, partitioning, query tuning, and related optimization techniques.
- Create and maintain dimensional data models supporting business intelligence and analytical use cases.
- Work effectively within a complex enterprise technology landscape, potentially involving subscription-based business models.
- Use Git to manage source code and support controlled development workflows.
- Contribute to development and operational activities in Unix/Linux-based environments.
Technical Stack & Requirements
- Database: Extensive knowledge of Oracle Database architecture, functionality, indexing, partitioning, and performance tuning.
- Query development: Strong proficiency in Oracle SQL, including analytic functions and hierarchical queries.
- Data integration: Proven ability to design, implement, and test complex custom-coded ETL processes.
- Data modelling: Experience with dimensional data modelling for BI and analytics solutions.
- Oracle ecosystem: Knowledge of Oracle REST Data Services and Oracle Enterprise Manager.
- Workflow orchestration: Knowledge of Apache Airflow.
- Operating systems: Basic experience working in Unix/Linux-based environments.
- Version control: Practical experience using Git.
Qualifications & Experience
The successful consultant will have senior-level experience in Oracle-based ETL and BI development, supported by strong business analysis capabilities. Previous work in subscription-based industries with complex IT environments—such as telecommunications, banking, or insurance—is required. The role calls for the ability to understand business needs, refine incomplete or high-level requirements, and convert them into reliable and maintainable data solutions.