Job Description:
Trigyn has permanent opportunities for ETL Developer. This resource will be working Remotely.
Job Description:
1. Create new facts and dimensions based on the Technical Design document.
2. Create and maintain Type I and Type II Modification of Prebuilt Mappings
3. Analyze and Customize the Repository .RDP file in order to meet the reporting and Dashboard needs
4. Maintain and correct defects of the prebuilt mappings
5. Create new Workflows and run jobs using the Data Warehouse Administration Console (DAC)
Ultimate result of service
Scripts, procedures and documentations on new data extractions, data models, system
configurations/modifications that meet the defined timeline and quality standard.
To deliver state-of-the-art reporting to enable Self-Service and create Human resources scorecard.
Outputs/Works Assignment
• Develop and maintain ETLs for the inbound data from various enterprise systems such as PeopleSoft and SAP;
• Implementation of Oracle Business Intelligence (OBIEE) Software
• Designing and implementation of the metadata, ETL and reporting components of the solution.
• Develop and provide dashboards, reports and enhanced UI features based on the functional design documents provided by the Business and as part of new Inspira module rollouts; keep the various dashboards refreshed on a regular basis from the source system and to bring in new modules into the dashboard as required by the Business.
• Maintain and support Data warehousing, data management and data modeling.
• Participate in Technical Design Document Creation.
• HRM Scorecard Facts and Dimensions: Implement Dimensions and Facts involved in HRM Scorecard Dimensional Model.
• Security implementation of OBIEE repository level. Translating business requirements in to technical requirements.
• Correct defects and modify Scorecard Dimensions and Facts.
• Performance Tuning of the existing Mappings in order to reduce the load window.
• Personal Action Fact for advanced Human Resources metrics and scorecard to support Human resources
• Scorecard and reports to the GA and External Organizations.
• Integration of Information from multiple sources (IMIS-Sybase, PeopleSoft-Oracle, etc.) to meet HR Business needs
• Develop a Payroll Fact, Budget and Expenditure Fact to support Business.
• Apply patches and system updates to the Oracle Business Intelligence system and Weblogic Server whenever required.
Skill Set
• Must have minimum of 1- 2 years of OBIEE 11G reports development work experience. Proficient in OBIEE ad-hoc reports, dashboard, OBIEE architecture and administration
• Experience with ETL tools, Informatica is desired.
• Must know how to write advance SQL and working with SQL server.
• Experience in modeling and building OBIEE repository layers.
• Experience developing reports and dashboards in OBIEE.
• Exposure to PeopleSoft tools is preferable
For Immediate Response, Please send your Resume to Global-Recruitment@Trigyn.com
TRIGYN TECHNOLOGIES is a multinational IT services company with resources deployed in 28 countries. TRIGYN is an ISO 9001:2015, ISO 27001:2022 (ISMS) and CMMI Level 5 certified company. TRIGYN has offices in the United States, Canada, Switzerland and India.