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 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 restore
Skills 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.

Only shortlisted candidates will be contacted.

People who read this post also read :