13 days ago
Pune, IndiaSenior
Responsibilities
- Develop and maintain Oracle Analytics Server/OBIEE BI solutions, RPD models, dashboards, analyses, prompts, and reports.
- Develop and maintain Oracle APEX applications, including interactive pages, forms, reports, dashboards, workflows, validations, processes, and dynamic actions.
- Develop BI Publisher reports and database objects such as tables, views, procedures, functions, and packages.
- Write complex SQL and PL/SQL, integrate APEX applications with Oracle databases and REST APIs, and develop REST-based integrations where required.
- Perform data validation, troubleshooting, application and query performance tuning, and resolution of application, BI, and database issues.
- Support deployments across Development, QA, and Production environments, including testing, defect resolution, and production support.
- Work with business and technical teams to understand requirements and deliver solutions.
- Prepare technical documentation and support knowledge transfer.
Requirements
- Strong hands-on experience developing Oracle APEX applications, pages, forms, interactive reports, and interactive grids.
- Strong knowledge of APEX components, processes, validations, dynamic actions, security, and authentication concepts.
- Strong knowledge of PL/SQL, SQL, Oracle Database development, data modeling, database concepts, and Oracle database architecture.
- Hands-on experience with Oracle Analytics Server/OAS and/or OBIEE, including RPD development and Physical, Business Model & Mapping, and Presentation layers.
- Experience developing dashboards, analyses, prompts, reports, and BI Publisher solutions.
- Experience with query and application performance tuning, troubleshooting, reporting solutions, and BI architecture.
- Experience integrating APEX applications with REST APIs is preferred.
- Strong analytical, problem-solving, communication, collaboration, stakeholder-management, and documentation skills.
- Ability to work independently on APEX and BI development activities.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- At least 5 years of relevant experience.
- Desirable experience includes Oracle APEX and OAS/OBIEE migrations or upgrades, ORDS, Oracle Cloud/OCI, Oracle Autonomous Database, ODI, REST API development, JavaScript, HTML, CSS, Linux/Unix scripting, CI/CD, source control, and Agile/Scrum.
Benefits
- Company-paid medical insurance, mental health support, and financial and legal consultations.
- Internal meetups, conferences, workshops, Udemy access, language courses, and company-paid certifications.
- Opportunities for internal mobility, professional growth, and work on large-scale global projects.
- Full-time position based in India with the ability to work from Pune.
Tech Stack
Categories
Data Engineering
About Ciklum
Ciklum is an IT services firm that builds custom digital products and provides nearshore engineering teams, QA, DevOps, data analytics, and UX for enterprises and high-growth startups. It operates a services model spanning product engineering, e-commerce solutions, and managed delivery centers. Founded in 2002 and headquartered in London, the privately held company serves global clients including Just Eat and Zurich Insurance.