Job Details
Job Description
Administration Duties and Responsibilities:
- Data Warehouse Databases (EDH, OFDM) Administration.
- EDH and OFDM Performance Monitoring and Fine Tuning.
- Assist the EDW Head to Set the EDH and the OFDM Backup/ Recovery.
- Policies and Procedures.
- Execute the Backup/ Recovery Policy.
- Maintain The Development & UAT Environments in Sync with the Production.
- Schedule test jobs on the UAT Environment and prepare it for each test as required.
- Assist the EDW Head to setup Change Control Management And Deployment Procedures.
- Create/ Modify Data Warehouse Oracle Database Schemas/ Tables as required.
- Document All the Changes to the EDW, and Maintain/ Update the EDW Data Dictionary.
- Informatica Administration (Developers access rights to Informatica Workflows, Worklets, Maps, and stored Procedures)
- Ensure smooth operation of the Informatica Server (Trouble shoot and solve problems).
- Monitor the growth rate of tables' sizes and house each in the proper area (Large Tables, Medium size Tables, and Small Tables Area).
- Monitor the adequacy of the Available Storage and suggest/ recommend appropriate course of action to the EDW Head.
- Generate ideas and recommend to the EDW Head ways to Improve the Performance of The Data Warehouse or The Controls that govern its operation. (e.g. Altering the structure of some tables, implementing new Indices, tables segmentations, implementing new Audit Logs, … etc.).
Operation Duties and Responsibilities:
- Informatica Daily Operation - Execute Daily ETL Runs.
- Informatica Monthly Operation - Execute Monthly ETL Runs.
- Trouble shoot and solve any problems during the Daily & Monthly Runs or escalate Immediately to the EDW Head.
- Ensure correct execution of daily & monthly runs and Report Runs' Status, on a daily basis to the EDW Head supported with the System's Logs.
- Ensure correct results by execution of daily & monthly reconciliation between the source systems and the EDH, and between the EDH and the OFDM. Incase of discrepancies, investigate the reason, report to and corrective action with the EDH Head.
- Assist the EDH Head to develop and maintain (Update upon changes) a Desktop Operation Manual that describes in detail the steps required to run or re-run the daily and monthly operations of the EDW, the backup and recovery procedures and to build logical flowcharts of the steps to be followed to trouble shoot and solve problems.
Development Duties and Responsibilities:
- Source Systems Analysis.
- Design and Develop or Modify ETL's.
- Design and Develop or Modify Rollup Processes.
- Design and Develop or Modify Data Marts as required.
- Informatica New source systems Analysis/Design and Development.
- Informatica Workflows development / Enhancements.
Other Duties and Responsibilities:
- Acts as a Backup/ Replacement to the OFSA & BI Specialist in his Absence.
- Participates in all Data Warehouse related projects, or any project that includes changes to any of the current source systems and could impact its interface with the Data Warehouse.
Desired Profile
- Bachelors Degree.
- At least 2 - 5 years relevant experience.
- Team player, good interpersonal skills and able to work under pressure.
- Ability to make decisions and follow through with initiatives.
- Planning, organizing and analytical ability.
- Hardworking and performance oriented.
- Customer Centric.
- Change management.
- People management/development.
Key Skills
Personal integrity, self-motivation and self-management.
Apply to this Job
Forward to Friend
Company Details
Contact Details
Contact Name
: NouraEmail
: 227@gulfbankers.comContact Mobile
: n/a
Company Profile
Information not available.
