Job Overview
| Particulars | Details |
|---|---|
| Position | Oracle BI / OBIEE Engineer |
| Company | Vienna Consultancy |
| Job Type | Remote |
| Experience | 3 - 4 years |
| Category / Department | IT |
| Application Mode |
🏢 About Vienna Consultancy
Company Overview:
Vienna Consultancy provides staffing and HR consulting services designed to connect organizations with qualified professionals. The company focuses on customized staffing solutions, recruitment, HR consulting, and supporting organizations in achieving business goals while improving efficiency and productivity. Its approach emphasizes strong relationships among clients, consultants, staff, vendors, and the wider community.
Company Mission:
To build relationships with the right candidates to meet client requirements while providing customized staffing solutions and experienced professionals with relevant technology expertise.
Company Vision:
Not Provided
Core Values / Principles
Build Trust
Take Care of Our People
Work Together
Build Strong Relationships
Proactive service
Responsive communication
A/2-35, Comfort Zone, Balewadi, Pune - 411045, Maharashtra, India
💡 Editor's Note / Preparation Tip
Resume Tips:
Highlight 4+ years of overall experience and clearly state 3+ years of OBIEE experience.
Showcase hands-on RPD development across all three layers.
Mention OBIEE dashboards, reports, Answers, Scorecards, and BI Publisher.
Highlight Oracle SQL and PL/SQL expertise.
Include data modeling experience with Star and Snowflake schemas.
Clearly list ETL tools such as ODI, Informatica, DataStage, or SSIS.
Mention Oracle Database, data warehouse, performance tuning, and query optimization experience.
Include measurable improvements in BI performance or reporting efficiency where applicable.
Interview Preparation:
Revise OBIEE architecture and RPD development.
Prepare questions around Physical, Business Model, and Presentation layers.
Review logical and physical data modeling concepts.
Prepare scenarios involving OBIEE dashboards, reports, Answers, and Scorecards.
Revise BI Publisher architecture and reporting.
Practice Oracle SQL and PL/SQL queries.
Review Star vs. Snowflake schema design.
Prepare ETL and data warehouse scenarios.
Revise OBIEE performance tuning and query optimization techniques.
Be prepared to troubleshoot reporting, repository, and database-related issues.
Professional Tips:
Clearly separate OBIEE, Oracle BI, database, and ETL experience on your resume.
Highlight specific enterprise BI implementations rather than listing technologies only.
Mention the scale and complexity of reporting environments where possible.
Demonstrate strong troubleshooting and performance optimization experience.
Since this is a contract role, clearly mention availability and relevant recent project experience.
📝 Job Description
Position Details:
Vienna Consultancy is seeking an experienced Oracle BI / OBIEE Engineer to design, develop, and support enterprise business intelligence and reporting solutions.
The role requires hands-on expertise in OBIEE/Oracle BI, including RPD development across the Physical, Business Model, and Presentation layers. The candidate should also have experience developing and supporting OBIEE dashboards, reports, Answers, and Scorecards, along with BI Publisher.
Strong Oracle SQL and PL/SQL knowledge is required, together with experience in data modeling, data warehousing, ETL processes, and Oracle Database environments. Candidates should also be capable of performance tuning and query optimization.
Benefits / Compensation
Contract duration: 6 months
Work Mode: Remote
Salary/contract compensation: Not Provided
Candidate Requirements:
4+ years of overall experience.
3+ years of OBIEE experience.
Strong OBIEE / Oracle BI knowledge.
Experience with RPD development.
Experience with OBIEE dashboards, reports, Answers, and Scorecards.
Experience with BI Publisher.
Strong Oracle SQL and PL/SQL skills.
Knowledge of data modeling.
Understanding of Star and Snowflake schemas.
Experience with ETL processes.
Oracle Database knowledge.
Data warehouse concepts.
Performance tuning and query optimization experience.
Preferred Skills:
ODI
Informatica
DataStage
SSIS
Oracle BI
OBIEE
BI Publisher
SQL
PL/SQL
Data Warehousing
Performance Tuning
Query Optimization
Working Days & Hours:
Not Provided
How to Apply:
Interested candidates can share their updated resume at muskan@viennaconsultancy.com.
🎯 Key Responsibilities
- ✓ Design, develop, and support enterprise BI and reporting solutions.
- ✓ Develop and maintain OBIEE RPD across Physical, Business Model, and Presentation layers.
- ✓ Develop and support OBIEE dashboards, reports, Answers, and Scorecards.
- ✓ Develop and maintain BI Publisher reports.
- ✓ Write and optimize Oracle SQL and PL/SQL queries.
- ✓ Develop and maintain data models using Star and Snowflake schemas.
- ✓ Work with ETL processes and data integration workflows.
- ✓ Troubleshoot BI and reporting issues.
- ✓ Perform performance tuning and query optimization.
- ✓ Work with Oracle Database and data warehouse environments.
- ✓ Support enterprise reporting and business intelligence requirements.
💡 Required Qualifications & Skills
🚀 Career Guidance & Interview Insights
To help you succeed, we've compiled original preparation guides, resume keywords, and growth analytics for this category of role.
Joining as a Oracle BI / OBIEE Engineer offers a fantastic opportunity to work at the forefront of technological innovation. You will be exposed to modern software development lifecycles, collaborate with cross-functional product teams, and design scalable architectures that directly impact end-users. The continuous learning curve in tech ensures that your programming, debugging, and system engineering skills remain highly marketable and sharp.
The career roadmap in technology is highly rewarding. Typical progression starts as a Junior Software Engineer, moving to Associate Developer and then Senior Software Engineer (3-6 years). From there, professionals choose between an individual contributor track—becoming a Tech Lead, Staff Engineer, and Principal Architect—or a management track, advancing to Engineering Manager, Director of Engineering, and Chief Technology Officer (CTO).
Expected Technical & Behavioral Questions:
- Q1: How do you optimize database query performance?
Answer Tip: Talk about indexing strategies, query execution plan analysis, avoiding N+1 queries, and implementing caching layers (like Redis). - Q2: Explain the differences between Microservices and Monolithic architecture.
Answer Tip: Highlight scaling advantages, loose coupling, independent deployments, network latency considerations, and data consistency challenges in microservices. - Q3: How do you handle merge conflicts in Git?
Answer Tip: Explain checking out the local branch, pulling the latest main branch, running git merge, opening the conflicted files to resolve blocks manually, and committing the resolved merge.
To pass automated ATS (Applicant Tracking System) screening and catch the recruiter's eye, tailor your resume with the following tips:
- Keywords to include: Software Engineering, SDLC, OOP, CI/CD Pipelines, SQL databases, Agile, Unit Testing, Code Review, Cloud Architectures (AWS/Azure).
- Format: Use a clean, single-column resume format. Avoid graphics, text boxes, or tables which can scramble ATS parser outputs.
- Quantify Results: Instead of writing 'wrote code', write 'Developed a caching system that reduced server response times by 35%.'
Estimated compensation for this role type in India is ₹6,00,000 - ₹12,00,000 per annum (Mid level). The actual salary package offered depends on factors such as company size, work mode (remote or on-site), individual technical proficiency, and negotiations during final HR rounds.
Highly recommended certifications include: AWS Certified Solutions Architect, Microsoft Certified: Azure Fundamentals, Certified Kubernetes Administrator (CKA), Oracle Certified Professional Java SE, or tech-stack specific achievements (e.g. Meta Front-End Developer certification).
Frequently Asked Questions
What position is available?
Answer. The opening is for an Oracle BI / OBIEE Engineer.
Is this a permanent or contract position?
Answer. This is a contract position with a duration of 6 months.
What is the work mode?
Answer. The position is fully remote.
How much overall experience is required?
Answer. Candidates should have 4+ years of overall experience.
How much OBIEE experience is required?
Answer. Candidates should have at least 3 years of OBIEE experience.
What RPD development experience is required?
Answer. Candidates should have experience with Physical, Business Model, and Presentation layers.
Which Oracle database skills are required?
Answer. Strong Oracle SQL and PL/SQL skills, along with Oracle Database experience, are required.
Which data modeling concepts should candidates know?
Answer. Candidates should understand data modeling, including Star and Snowflake schemas.
Which ETL tools are mentioned?
Answer. ODI, Informatica, DataStage, and SSIS are mentioned as relevant ETL technologies.
How can candidates apply?
Answer. Candidates can send their updated resume to muskan@viennaconsultancy.com.
Share This Job
🛡️ Safety Disclaimer: JobPortalConnect curates official listings for informational purposes. Genuine recruiters will never ask you for processing fees, training payments, or security deposits. If you spot suspicious activity, copyright issues, or wish to request the removal of this listing, please report it to us immediately at contact.jobportalconnect@gmail.com.