Oracle OBIEE/ODI Developer

Job Title: Oracle OBIEE/ODI Developer Location: Rockville, MD - Hybrid (2 Days Onsite in a Week) Duration : 6Months C2H Job Description: Technical developer responsible for designing and developing solutions with technical expertise in data warehouse design, ETL (ODI), reporting and analytics. The incumbent designs and develops enterprise data warehouse (EDW), ETL and business intelligence systems on OBIEE and Tableau. This position will provide guidance and technical oversight an offshore BI development team to support the ongoing operation and enhancements of EDW, ETL and OBIEE systems. Basic Qualifications: • Bachelor's degree in computer science or relevant field • Overall 8 years of experience in data warehouse and OBIEE, with focus on ETL/ODI • Minimum 6 years of experience in end-to-end deployments of OBIEE Summary of duties: • Responsible for gathering requirements and specifications from business stakeholders. • Designs, codes, verifies, tests, documents, amends, and refactors substantially complex programs/scripts and application integrations as technical lead • Investigates escalated, non-routine and high-impact incidents to responsible service owners and seeks resolution. • Leads assessment, analysis, planning and design of release packages, including assessment of risk. Liaises with business and technology teams on release scheduling and communication of progress. Ensures release processes and procedures are applied and releases can be rolled back as needed. • Provide expertise in performing application development, configuration and unit testing of data integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications. • Collaborate with development team to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end users • Experience with transforming logical business requirements into appropriate schemas and models • Create both logical and physical data models, with emphasis on data preparation, data profiling, data cleansing, and data auditing • Responsible for working with the offshore BI team members and business stakeholders to deliver reporting and analytics solutions within the data warehouse and OBIEE. • Responsible for analysis, design, development, customizations, validations, deployment and post-implementation support for OBIEE components including Oracle BI Admin, interactive dashboards, BI Publisher, scheduler, and interactive reporting using OBIEE 12c • Work closely with business stakeholders, developers(offshore) and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases. • Responsible to create, maintain and enhance Business Intelligence components (metadata, reports, metrics, dashboards) and manage the overall BI ecosystem by resolving defects in timely manner. • Lead BI application change control management by performing impact analysis to drive changes • Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of the client • Coordinate work efforts with the DBA team for application changes and system performance issues • Collaborate on testing OBIEE functionality for deployment of upgrades to keep application release level current • Proactively work through service requests with Oracle support as needed.

Created: 2024-11-05