Role And Activities:

  • Develop data warehouse models and prepare reports for meta data integration into systems
  • Draft ETL scripts to map the data and prepare required reports for Risk Management Team
  • Perform tests, validate data flows and prepare ETL processes according to business requirements
  • Excellent written and verbal communication skills and be able to lead meetings with technical peers regarding the solution designs.
  • Ability to communicate with the Business Analysts, Project managers and Head of Business when it comes to converting the ETL design into specific development activities
  • Develop MIS documentation to allow for smooth operations and easy system maintenance
  • Provide strong reporting and analytical information support to management team * Generate both periodic and ad hoc ETL jobs as needed for Risk Management team
  • Analyze and interpret complex data on target systems and provide resolutions to data issues
  • Maintain required system documentation according to IT applications procedures
  • Collaborate with developers and business users to gather required data and execute ETL programs and scripts on systems
  • Perform root cause analysis on processes and resolve all issues related to ETL
  • Validate all data and perform routine tests on databases
  • Develop and perform tests on all ETL codes for system data * Design data mapping techniques for data models in systems
  • Schedule ETL processes and prepare documents for data flow diagrams
  • Internal Testing
  • Conducting unit and integration testing
  • Preparation & Support for user acceptance testing
  • Support for production implementation

Skills/ Experience Required
: * Strong Knowledge of Informatica Power Centre 9.6

  • Knowledge of OFSAA / OFSDF Data Models / Structures
  • Experienced with SQL Queries and Databases like SQL Server, Oracle, Sybase etc.
  • Keen on Analyzing Data, Reconciliation, Data Validation, Finding Potential Issues & Testing
  • Banking/Financial Institute Domain Knowledge
  • 5 years of overall IT experience, with a minimum of 3 years in banking
  • Effective, precise and clear Communication Skills to levels
  • Bachelor's Degree.

Job Type: Full-time

Job Location:

  • Abu Dhabi

Required education:

  • Bachelor's

Required experience:

  • Data Warehouse Models: 3 years
  • Banking: 3 years
  • IT: 5 years
  • Informarica Power Centre 9.6: 5 years
  • OFSAA / OFSDF Data Models / Structures: 3 years
  • ETL process: 5 years

Required language:

  • English

6 days ago

Related jobs

Immediate opportunity for ETL resource with one of our reputed client
ATRIBS METSCON Group - Abu Dhabi, AZ

Ability to communicate with the Business Analysts, Project managers and Head of Business when it comes to converting the ETL design into specific development...Read More

6 days ago

Functional Analyst holding expereince in Digital field

The jobholder is required to perform effective coordination between customers and IT teams for Demands (Projects and RFCs) related to Digital Technologies....Read More

6 days ago

Techno Functional Wealth Management Consultant

 The successful candidate will partner with business and technology representatives in establishing delivery teams and provide expertise for the technology...Read More

4 months ago

Russian speaking project co-ordinator/translator

* With basic IT knowledge who can understand what a project and importance of communication * Able to speak/read/write/understand good english, so she couldRead More

4 months ago

PMWeb Consultant (AUH)
ATRIBS METSCON Group - Abu Dhabi, AZ

PM Web Consultant:. To develop custom reports, builds workflows that meets business requirements and also can do customization....Read More

5 months ago