ETL Consultant Job in Kenya

Main Purpose

Working as an ETL Consultant of the delivery team in Nairobi for our clients across Kenya, the candidate would be responsible for end to end deliverables for the ETL phase of project engagement.

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 resolutionAnalyze & translate functional specifications & change requests into technical specificationsDevelop, test & implement program logicResponsible for the Extraction, Transformation & Loading of data from multiple sources into Data WarehouseDesign, develop & test large-scale ETL application for data warehouse application.Expertise in analyzing and coordinating the banking data, generating MIS reports, tables, listings, graphsWork with ETL tools, such as Data Stage and Informatics (preferred).Accessing data from relational databases and experience with handling large data setsIdentify 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 requiredSupport reporting automation for various businessesCreate standardized templates and formats for reportingPerform system backup and restoreProficient in Data warehouse concepts like Data warehouse architecture, Star schema, Snowflake schema, Data Marts, ODS, Dimension and Fact tablesUnderstanding of Informatics and Data Stage Architecture.Experienced periodical update of the data using merge statement and append proceduresWorking knowledge of database technologiesExposure of integrating applications in a complex and diverse systems environmentExposure to various third party products and experience of integrating them into a systems solutionProficient in logical and technical aspects of data mart structuresFirm background in systems analysis and designComfortable in working on Windows and Unix Platforms.Bachelor's degree or equivalent in Computer Science, IT or related and three (3) years relevant experienceTo 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.

Only shortlisted candidates will be contacted.

For a more comprehensive collection of jobs in Kenya, visit our new Kenyan Jobs Website http://www.kenyan-jobs.com/