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
Senior Software Engineer role focused on Atlassian’s Trusted Data Platform. The available description emphasizes a distributed-first, remote-friendly work environment with virtual interviews and onboarding. Specific technical responsibilities, required qualifications, compensation, travel, and clearance details are not provided.
Cloud • Information Technology • Consulting • Cybersecurity
Owns ingestion, data modeling, reconciliation, validation, and lineage for a financial billing platform on GCP. Designs auditable, idempotent BigQuery pipelines; implements data quality controls, quarantine processes, effective-dated reference data, and accurate monetary handling. Develops tested Python and advanced SQL, collaborates with engineering and finance stakeholders, and mentors team members. Preferred experience includes invoicing, regulated or audited finance environments, and additional GCP services.
Top Skills:
BigQueryCloud RunCloud StorageFirestoreGoogle Cloud PlatformPydanticPytestPythonSQL
Fitness • Healthtech • Retail • Pharmaceutical
Designs and builds data models, schemas, and ETL/ELT pipelines for analytics, reporting, and machine learning workloads. Optimizes query performance and cloud data infrastructure, establishes data quality and governance practices, integrates datasets with BI and machine learning tools, documents workflows, and mentors junior engineers. Collaborates with data scientists, analysts, and product owners to translate business requirements into scalable technical solutions.
Top Skills:
AWSAzureData MartsData WarehousingDimensional ModelingEtl/EltGCPOmopPythonSQLTuva
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
