Skills and Responsibilities: Required Skills: • Strong experience in: o OBIEE 11g/12co RPD modeling (Physical, BMM, Presentation layers) • Expertise in Answers, Dashboards, and BI Publisher• Strong SQL and database knowledge Key Responsibilities: • Design and develop OBIEE dashboards, reports, and scorecards • Create interactive visualizations for business users • Customize reports with filters, prompts, and drill-down capabilities RPD Development (Repository Design) • Develop and maintain OBIEE Repository (RPD) including: Physical layero Business Model & Mapping (BMM) layero Presentation layer • Implement logical schemas, joins, hierarchies, and aggregates Data Analysis & Modeling • Translate business requirements into technical specifications • Build and optimize data models for reporting and analytics • Work closely with data warehouse and ETL teams Performance Tuning • Optimize report performance and query execution • Troubleshoot issues related to slow reports or data inconsistencies • Implement caching and aggregate navigation Integration • Integrate OBIEE with data sources (Oracle DB, SQL Server, flat files, etc.) • Work with ETL tools (Informatica, DataStage, Talend) for data pipelines • Support integration with other Oracle tools (e.g., ODI, OAC) Security & Governance • Implement user authentication and authorization • Manage data-level security (row-level, object-level) • Ensure data governance and compliance policies are followed Testing & Deployment • Perform unit testing, integration testing, and UAT support • Handle deployments across environments (Dev, QA, Prod) • Maintain version control of RPD and reports" Salary Range - CA$ 100,000 - CA$ 120,000 Per Year TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion. Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.