Latest Kenya Jobs: Consultant at ETL Consultant

Latest Kenya Jobs: Consultant at ETL Consultant
Location : Nairobi,Kenya Country : Kenya
Industry : Communications Position Type : Full Time
Experience Level : 3 Years Education Level : Bachelors Degree

ETL Consultant
The position would require working onsite / offsite across varied short term / long term analytics driven projects

Main Responsibilities
    * Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
    * Analyze & translate functional specifications & change requests into technical specifications
    * Develop, test & implement program logic
    * Responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse
    * Design, develop & test large-scale ETL application for data warehouse application.
    * Expertise in analyzing and coordinating the banking data, generating MIS reports, tables, listings, graphs
    * Work with ETL tools, such as Data Stage and Informatics (preferred).
    * Accessing data from relational databases and experience with handling large data sets
    * Identify and implement automation improvements Create job schedules / job flows using LSF, monitoring and troubleshooting schedules jobs Enhancing / Validating / Debugging existing job(s)
    * Be the owner of codes & queries and handle modifications whenever required
    * Support reporting automation for various businesses
    * Create standardized templates and formats for reporting
    * Perform system backup and restoreSkills Required
    * Proficient in Data warehouse concepts like Data warehouse architecture, Star schema, Snowflake schema, Data Marts, ODS, Dimension and Fact tables
    * Understanding of Informatics and Data Stage Architecture.
    * Experienced periodical update of the data using merge statement and append procedures
    * Working knowledge of database technologies
    * Exposure of integrating applications in a complex and diverse systems environment
    * Exposure to various third party products and experience of integrating them into a systems solution
    * Proficient in logical and technical aspects of data mart structures
    * Firm background in systems analysis and design
    * Comfortable in working on Windows and Unix Platforms.

Educational Background
    * Bachelor’s degree or equivalent in Computer Science, IT or related and three (3) years relevant experience

To apply for this position send your CV to mycv@myjobseye.com quoting the position in the subject line.

Kindly also mention your current/ last salary and benefits.