DEVELOPER BI Publisher (OBIEE/OAS)

Requirement for DEVELOPER BI Publisher (OBIEE/OAS) at Gurugram location (4 to 9 years of experience). Must Have skills Reporting in BI Publisher, OBIEE, OAS, Understanding of Snowflake, SQL query optimisation, Power BI Immediate Joiners or max. notice of 15 days Location Gurgaon Duration 12 months Grade 3 Mode of Interview Virtual (Round 1) + In-person (Round 2) Relevant experience- 3-6 years S.No Mandatory Skills Weightage(%) 1 OBIEE/OAS 70% RPD 30% Analytics dashboard - 10/10 25% Security implementation 10% BI Publisher 30% Performance enhancement 5% 2 SQL 5% Writing complex SQL 30% debugging existing code 60% creating Procs & functions 10% 3 Power BI 20% data modeling 50% DAX query 50% 4 Python (good to have) 5% Job Description Title Senior Analyst Programmer Department GPS Location Gurgaon, India Level Grade- 3 About your role This is a challenging opportunity for experienced developer to work on the data warehouse alongside data analysts, business analysts, database administrators and business project teams. Key Responsibilities: Design, development, implementation of complex reportsCollect implementation requirements and convert them into tangible deliverables. About you Experience in OBIEE/OAS involving RPD & Metadata modelling, OBIEE Interactive DashboardsDesign and develop reports, charts and dashboards with different views using OBIEE presentation servicesDesign and develop physical layer, business model and mapping layer and presentation layers of OBIEE Repository using Administration toolSecurity implementation at both data level and object levelExperience in developing Olap reports for reporting/ad-hoc query requirementsExperience in data normalization/de-normalization and Performance Tuning / techniques.Implementing Multi-user development environment structureExperience in tuning of OBIEE/ ODI processes to meet performance requirements of reportsSound understanding of RDBMS concepts (preferably Oracle)Expertise in writing advanced Oracle SQL queries (DML/DDL)Experience of best practices - Dev Ops and Agile deliveryProven track record of high-quality project deliveries and technical achievementsExperience in data normalization / de-normalization and Performance Tuning / techniques.Expertise in writing advanced Oracle SQL queries (DML/DDL)Proven track record of high-quality project deliveries and technical achievementsSound analytical & debugging skills.Innovative and enthusiastic about technology and using it appropriately to solve problemsExcellent communication/presentation inter-personal skills to present to/liaise with all levels of stakeholders.Ability to thrive in a rapidly changing and expanding environment Thanks, N Regards, Aanchal Varshney dCS - Disa Consulting Services Talent Acquisition Manager Aanchal.v@disaconsulting.com | www.disaconsulting.com LinkedIn: https://www.linkedin.com/in/aanchal-varshney-b7898996/ Follow Us on LinkedIn: https://www.linkedin.com/company/disa-consulting-services/ MSME Certified .