Develop and maintain Oracle APEX applications, Oracle Analytics Server/OBIEE reporting solutions, BI Publisher reports, and Oracle database objects. Build dashboards, workflows, integrations, REST APIs, and data models; write complex SQL and PL/SQL; troubleshoot and tune application and database performance; support deployments, testing, production issues, documentation, and stakeholder collaboration.
Ciklum is looking for a Senior Data Engineer to join our team full-time in India.
We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.
About the role:
As a Senior Data Engineer, become a part of a cross-functional development team engineering experiences of tomorrow.
Responsibilities:
- Develop and maintain BI solutions using Oracle Analytics Server (OAS) / OBIEE
- Develop and maintain Oracle APEX applications
- Design and develop interactive APEX pages, forms, reports, dashboards and workflows
- Develop and maintain OBIEE/OAS RPD models, dashboards and reports
- Develop reports using BI Publisher
- Write complex SQL queries and work with Oracle databases
- Develop and maintain database objects such as tables, views, procedures, functions and packages
- Integrate APEX applications with Oracle databases and other systems/APIs
- Develop REST-based integrations and APIs where required
- Perform data validation, troubleshooting and performance tuning
- Analyze and resolve application, reporting and database issues
- Support deployment across Development, QA and Production environments
- Work with business and technical teams to understand requirements and deliver solutions
- Participate in testing, defect resolution and production support
- Prepare technical documentation and support knowledge transfer
Requirements:
- Strong hands-on experience with Oracle APEX development
- Experience developing APEX applications, pages, forms and interactive reports
- Experience with Interactive Reports and Interactive Grids
- Good knowledge of APEX components, processes, validations and dynamic actions
- Experience with APEX security and authentication concepts
- Experience integrating APEX applications with REST APIs is preferred
- Strong knowledge of PL/SQL and Oracle Database
- Hands-on experience with Oracle Analytics Server (OAS) and/or OBIEE
- Experience with RPD development
- Good understanding of Physical, Business Model & Mapping and Presentation layers
- Experience developing dashboards, analyses, prompts and reports
- Experience with BI Publisher
- Understanding of BI architecture and reporting solutions
- Strong SQL and PL/SQL skills
- Experience with Oracle database development
- Experience developing views, stored procedures, functions and packages
- Good understanding of data modelling and database concepts
- Experience with query and application performance tuning
- Strong analytical and problem-solving skills
- Ability to work independently on APEX and BI development activities
- Good understanding of Oracle technologies and database architecture
- Strong communication and collaboration skills
- Ability to troubleshoot application, BI and database issues
- Good stakeholder-management and documentation skills
- Bachelor's degree in Computer Science, Information Technology, Engineering or a related field
- 5+ years of relevant experience
- Hands-on Oracle APEX development
- OAS / OBIEE experience
- SQL / PL/SQL
- Oracle Database
- Experience with BI dashboards/reporting
- Ability to work from Pune
Desirable:
- Oracle APEX application migration or upgrade experience
- OAS / OBIEE upgrade or migration experience
- Oracle REST Data Services (ORDS)
- Oracle Cloud / OCI experience
- Oracle Autonomous Database
- Oracle Data Integrator (ODI)
- REST API development and integration
- JavaScript, HTML and CSS
- Linux/Unix scripting
- CI/CD and source-control experience
- Agile/Scrum experience
What’s in it for you?
- Strong community: Work alongside top professionals in a friendly, open-door environment
- Growth focus: Take on large-scale projects with a global impact and expand your expertise
- Tailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company-paid certifications
- Endless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands-on experience with cutting-edge technologies
- Care: We’ve got you covered with company-paid medical insurance, mental health support, and financial & legal consultations
About us:
At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you’ll work with cutting-edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress.
India is a strategic innovation hub for Ciklum, with growing teams in Chennai and Pune leading advancements in EdgeTech, AR/VR, IoT, and beyond. Join us to collaborate on game-changing solutions and take your career to the next level.
Explore, empower, engineer with Ciklum!
Interested already? We would love to get to know you! Submit your application. We can’t wait to see you at Ciklum.
#LI-GP1
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Develop and maintain software for Atlassian’s Trusted Data Platform. The provided description contains limited role-specific responsibilities, qualifications, technologies, travel requirements, and clearance information.
Information Technology
Build and maintain scalable data pipelines for a global fintech engagement using Azure Databricks, PySpark, SQL, and Delta Lake. Develop Bronze, Silver, and Gold data layers, optimize data models, implement validation and monitoring, troubleshoot data quality issues, and follow governance, security, cataloging, and lineage standards while collaborating with data and engineering teams.
Top Skills:
AzureAzure DatabricksCi/CdDelta LakeGitPysparkSQL
AdTech • Digital Media • Marketing Tech • Mobile
Designs and develops scalable data architectures, cloud data solutions, data warehouses, business analytics tools, and complex data pipelines. The role involves data wrangling, exploration, and discovery across heterogeneous sources, using AWS, SQL, Python, and relational database technologies. The engineer also contributes to data engineering innovation, knowledge sharing, and project planning while enabling data-driven organizational decision-making.
Top Skills:
Amazon Web Services (Aws)Data WarehousingDaxPythonRelational DatabasesSQL
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
