OBIEE DEVELOPER

Phone/Skype Hire. Onsite from day 1

OBIEE DEVELOPER (day 1 On Site)

Location: NYC, NY

Duration: 36+ months

Direct client

3 Professional References Required

Responsibilities

• Maintain and support various databases used by the Office of Enforcement and Neighborhood Services (ENS).
• Create and maintain logical and physical data models.
• Create and maintain ETL packages in SQL Server Integration Services and Oracle Data Integrator to extract, transform, load and transfer between Oracle and SQL Server database.
• Create ETL mapping documentation.
• Perform data profiling data analysis, conversion, and migration of data between different databases. Create dimensional logical and physical data models.
• Create BI models in OBIEE.
• Performance tune and optimize queries.
• Assist development teams in the build out of schema and database technologies
• Assist in installing, configuring and setup of Business Intelligence Tool and other data tools as needed. Development of complex reports/dashboards for ENS business users.

Skills Needed Example ( 8+ Years)

• Minimum of 8 years of OBIEE Design, Deployment and developing relational and dimensional data models. ( ..Years)
• Minimum of 8 years of Oracle Business Intelligence Dashboards, Reporting Design and Development. ( ..Years)
• Minimum of 5 years of ETL Development via Oracle Data Integrator (ODI)/ SQL Server Integration service (SSIS). ( ..Years)
• Minimum of 5 years of experience with Oracle/SQL Server Database, writing SQL queries to perform complex data analysis, developing stored procedures, functions, triggers. ( ..Years)
• Minimum of 5 years of experience in performance tuning and Query optimization techniques. ( ..Years)
• Solid understanding of dimensional model (Star Schema & Snowflake schema) ( ..Years)