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.