Ventera's mission is to be a growing business technology consulting firm recognized for earning the loyalty of customers and employees by committing to their success. Ventera delivers innovative business and technology solutions to unique customer challenges, to help our clients achieve meaningful results. Our team brings expertise and serves as a trusted advisor to our clients in the areas of Management Consulting, Software Engineering, and Data Solutions. Walking through Ventera, you will find a highly engaged and collaborative workforce. We strive to make Ventera a fun place to work, as well as a place where you will want to stay and build your professional career. Come join us!
Senior Business Intelligence Developer is responsible for the design, development and implementation of business intelligence and user reporting solutions using BI analytical & ETL tools based upon business requirement and content knowledge. Senior Developer will develop reliable and complex ETL processes and BI Solutions to support new development of the Enterprise Data Warehouse, Data Marts and other Business Intelligence projects. Assist in completing current Data Warehouse initiative projects and support & participate in source data analysis, specifically as it relates to domain definitions. Must also have proven ability to perform technology needs assessment and evaluate solution options; the capability of performing interface analysis at the detail level; experience in documenting requirements (Jira) and working in a Agile scrum team. Strong understanding of database methodology, data analysis, advanced SQL queries, ETL, business intelligence applications and full Software Development Lifecycle (SDLC).
Overall 7+ years of hands on Experience with OBIEE Development; Per contract requirement, candidate must have lived in the US for the past three, consecutive years.
Proficient in BI reports + dashboard development
Must have OBIEE 11G reports development work experience
Resource needs to be experienced in BI Publisher, OBIEE Answers (reports, dashboards) as well as handling RPD development, managing security etc.
Must know how to write advance SQL, use Oracle's SQL aggregate and analytic functions
Must understand OBIEE ad-hoc reports development process
Must understand creating maps/interactive dashboard catalog objects
Resource needs to be experienced in writing and debugging SQL queries
BI Publisher Report Developer
Must have mastery of creating of XML data templates
Must know how to create report layout templates
Must have skill sets in writing complex SQL and PLSQL programs
Must have proficiency in tuning the SQL, PLSQL code for optimum performance