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
Ciklum Chennai, Tamil Nadu, IND Office
Campus 3B, Co-Wrks, 5th Floor, RMZ Millenia Park II, MGR Main Rd, Kandanchavadi, Perungudi, Chennai, India, 600096
Similar Jobs
Information Technology
Build and maintain scalable data pipelines on Azure Databricks using PySpark, SQL, and Delta Lake. Design dimensional and Gold-layer data models, ingest structured and semi-structured data, implement testing and monitoring, troubleshoot data-quality issues, and follow cataloging, lineage, security, privacy, and regulatory standards. Collaborate with data leads, analysts, data scientists, and AI engineers to deliver reliable datasets and participate in code reviews and platform standards discussions.
Top Skills:
AzureAzure DatabricksAzure Event HubsCi/CdDelta LakeGitMariadbPysparkSQL
Fintech • Food • Payments • Software
Own and operate qlub’s production data platform across ingestion, dbt modeling, BigQuery, Airflow, ClickHouse, GCP infrastructure, data quality, and CI/CD. Build reliable pipelines, optimize performance and cost, troubleshoot production issues, establish engineering standards, and mentor data engineers. Explore practical applications of LLMs and agents for data discovery, monitoring, and troubleshooting while maintaining secure, maintainable systems.
Top Skills:
AirbyteApache AirflowApache FlinkAws Ec2Aws RdsAws S3BashCi/CdClickhouseCloud RunCronDatastreamDbtDebeziumDockerFivetranGitGoogle BigqueryGoogle Cloud Platform (Gcp)Google Cloud StorageGreat ExpectationsIamKafkaKubernetesLinuxLlm ApisMonte CarloPostgresPower BIPythonRagSodaSQLSshTableauTerraform
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.
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
