Skills Required:
- Design, develop, test, deploy, and maintain Ab Initio applications using various components such as Control Center, GDE, Graphs, Plans, continuous flows Oracle, SQL, Unix Shell Scripting
- Experience in designing and delivering complex, large-volume data warehouse applications
- Working knowledge of source-code control using EME is required.
- Should have strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Ab Initio.
- Should have experience with SQL database programming, SQL performance tuning, relational model analysis.
- Must have the ability to relate to both business and technical members of the team and possess excellent communication skills.
- Participate in code reviews to ensure adherence to coding standards and best practices.
- Should be able to provide oversight and technical guidance for developers on Ab Initio.
Roles & Responsibilities:
- Analyze, design, implement and maintain high volume, multi-terabyte 24/7 data warehouse robust and fast ETL applications
- Develop logical and physical data models; advanced ETL development using Ab Initio
- Be a technical player on complex ETL development projects with multiple team members
- Develop relevant functional and technical documentation.
- Lead, design and develop data warehouse solutions using different architecture, design and modelling techniques
- Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.
- Lead the creation of all design review artifacts during project design phase, facilitate design reviews, capture review feedback and schedule additional detailed design sessions as necessary.
- Interact with Release Management, Configuration Management, Quality Assurance, Architecture Support Database Support, other Development teams and Operations as required
- Lead and contribute to all phases of the software development life cycle for Enterprise Data applications including current production and any future applications
- Create and enhance administrative, operational and technical policies and procedures, adopting best practice guidelines, standards and procedures
