SOA Specialist.IT Development at Kenya Airways

Role Statement

Responsible for analysis and development of integrations and ETL/ELT processes, dashboard visualization and reports to support business requirements.

Must be able to work with 3rd Party system vendors, functional business analysts, business process owners and other technical team members in supporting applications integration design, development and maintenance. Should be capable of executing requirements and design specification into development deliverables.

Responsibilities

• Design and develop end to end data warehouse integrations and ETLs processes for upstream and downstream source systems.
• Continuously monitor all integrations and scheduled processes to measure and improve on data quality.
• Work closely with database analysts and architects in data modeling and data structure specifications
• Thoroughly test all integrations and ETL/ELTs, data maps to guarantee data quality.
• Review and interpret data into actionable reports for various business units using tools such as Tableau
• Provide Technical Support to various Data driven business users
• Continuously analyze and identify opportunities to improve on existing ecosystems
• Participate in business requirement gathering and validation to understand data and reporting requirements.
• Work closely with business analysts, project managers, database analysts and architects to design and translate requirements into technical specification documents.
• Provide required documentation such as functional specifications, integration documentation, data mapping.
• Ensure that all developments are well documented and adhere to the KQ release management process.
• Analyse and agree with supervisor or technical lead on work effort estimations for projects
• Work with project managers to ensure on-time implementation of assigned tasks
• Adhere to architecture and design principles and coding standards.
• Design and develop integration solutions for the business application systems.
• Work very closely with users and business analysts to understand requirements and then develop the required solutions.
• Automation of complex and manual data exchange processes.
• Documentation of the design, test plans, manuals as well as any other artifacts that help describe the function, architecture, and design of the solution.
• Participating in team activities such as peer code reviews to improve the overall quality of team deliverables.
• Identify solution initiatives, which can be created for better efficiency and process controls within any business systems environment.
• Support the execution of System Integration Tests (SITs) and the User Acceptance Test (UATs).
• Perform root cause analysis for recurring incidents, identify and implement optimal solutions, formalize test plans and implement troubleshooting procedures
  
  

Key performance indicators

• Effectively gather and validate requirements.
• Maintain proper documentation such as solution design documentations, integration documents.
• Accurately size the effort required to execute a project.
• Effectively manage the customer expectations by constantly communicating to business users.
• Deliver development projects within the agreed schedule and plan.
• Quality assurance by reducing the number of bugs uncovered during tests.
• Ensure that all development projects are aligned to the overall project objective and that the result meets all requirements.
• Adherence to architecture and design principles and coding standards
• Self-motivated, enjoys problem solving, solution development, system integration challenges
• Adhere to the IT System development methodology (SCRUM)

• Bachelor’s degree in Computer Science, Information Technology, Computer Engineering or related degree
• Training and certification in SOA middleware and data integration tools
• Certifications in system development tools and languages. (Added advantage)
• A minimum of 3 years’ experience in SOA integrations, ETL/ELT processes, Business Intelligence development and visualization.
• Minimum 3 years programming experience in: Java, C++, C#, XML, PL/SQL, PERL, Python, Shell Scripting, SQL Server, SOAP/REST,
• Experience in a SOA middleware and Data Integrator
• Experience in working with Windows and Unix/Linux environments.
• Experience in Oracle and Microsoft database architecture
• Has an understanding of data warehouse concepts.
• Good understanding of Software Development Life Cycle process
• Knowledge in report and dashboard development
• Experience in querying data from a variety of data sources and relational databases using Stored Procedures, Functions, Views, Webservices.
• Experience and proficiency in analytical tools such as Tableau, Oracle MS SQL.
• Experience in data Warehouse environments and Dimensional data modeling experience.
• Experience in data management practices with excellent skills in data integrations.
  
  

Additional Skills

• Ability to excel in a fast paced, team-oriented environment.
• Good troubleshooting skills and ability to work independently/ proactively are a must.
• Excellent verbal and written communication; effective liaison skills and the ability to work with a wide-range of professionals in various disciplines.
• Commitment to and has a high affinity for delivering the highest level of customer satisfaction
• Motivated and energetic individual, who takes initiative, enjoys finding solutions to a varying number of challenges, is detail-oriented, and takes extreme pride in their work.