Ab Initio Developer

Published: Nov 1, 2024 – The Ab Initio Developer designs and implements an HR Data Warehouse and MI solution with Ab Initio and SQL, creates ETL processes, and develops SQL applications to support data needs. Collaborates with business analysts and solution architects to translate requirements into effective technical solutions, ensuring documentation, code quality, and alignment with acceptance criteria. The developer also coordinates with developers to deliver tested, high-performance solutions and provides Tier-3 support to promptly address technical issues.

Responsibilities:

• Design and implement an HR Data Warehouse & MI solution using Ab Initio, SQL, and Data Modelling.
• Work with business owners, business analysts, and solution architects to understand business requirements and solution design.
• Translate functional and technical requirements into IT solutions and prepare documentation and specifications for build and support handover.
• Estimate the level of effort required to develop code that meets acceptance criteria.
• Develop and design subject areas within the MS SQL Server data warehouse, including the development of any necessary MS SQL applications to support the HR MI&A team.
• Create an Ab Initio-based ETL process from various source systems into SQL databases, ensuring end-to-end development.
• Coordinate with other onshore and off-shore developers, deliver working code.
• Conduct peer reviews and provide documented constructive feedback.
• Ensure development meets all the specifications and has successfully passed all tests including unit, integration, regression, and system tests.
• Demonstrate tractability from functional design to technical design, through to testing.
• Ensure performance, security, and availability of databases.
• Provide Tier-3 support and production release support- respond promptly to requests from the support team to resolve user queries and handle technical issues that are out of scope for the support staff.

Skills:

• HR Data Warehouse Design (Hard Skills)
• Requirement Analysis & Solution Design (Soft Skills)
• Documentation & Specs Preparation (Hard Skills)
• MS SQL Data Warehouse Development (Hard Skills)
• Ab Initio ETL Process Creation (Hard Skills)
• Testing & Quality Assurance (Hard Skills)