Job Title: BI Analytics Engineer
Job Duties: Design and develop ODI Projects, Packages and Mappings to extract and load data into custom data warehouse. Configure and setup ODI master and work repository, models, sources and knowledge modules. Deal with ODI Knowledge Modules like LKM, IKM, JKM and CKM. Work on ODI Topology Manager Module to manage the data describing the information systems. Create and modify SQL and PL/SQL database objects. Collect ETL requirements from business teams and design technical documents. Monitor ETL jobs and troubleshoot errors using operator logs. Create connection pools, import physical tables and define joins in the physical layer of the repository. Develop and customize Dimensions Drill down Hierarchies Logical Objects in Business Model and Mapping Layer. Establish time series objects to date functions, construct aggregations and logical based measures in Business Model and Mapping Layer. Use OAS & OBIEE 12c, to develop Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, guided navigations as per requirement. Required skills and utilities: ODI 12c (Oracle Data Integrator), OBIEE 12c/OAS (Oracle Analytics Server), Oracle Database 12c, SQL Server Management Studio v17.3, PL/SQL.
Other: Full Time. Travel involved to unanticipated client locations within US.
Requirements: Master’s Degree in Computer Science or Equivalent + 1 year of experience in job offered or related. Any suitable combination of education, training or experience accepted.
Location: Alpharetta, GA
Respond to: HR–Code KP, CSI Solutions LLC, 5445 McGinnis Village Place, Suite 104A, Alpharetta, GA 30005
This position is eligible for our employee referral program