Role & Responsibilities:
- Design, develop, and maintain Ab Initio graphs for extracting, transforming, and loading (ETL) data from diverse sources to various target systems.
- Optimize Ab Initio graphs for performance, ensuring efficient data processing and minimal resource utilization; conduct performance tuning and troubleshooting as needed.
- Implement data quality and validation processes within Ab Initio.
- Collaborate with data architects, business analysts, and cross-functional teams, including database administrators and QA, to ensure seamless integration of ETL processes.
- Participate in design reviews and provide technical expertise to enhance overall solution quality.
- Maintain proper documentation of ETL processes and solutions.
Required Education:
Required Technical and Professional Expertise:
- Experience in Ab Initio components such as Transform Functions, Rollup, Join, Normalize, etc.
- Data modelling and analysis to ensure optimal ETL design and performance.
- Implement best practices for reusable Ab Initio components.
Preferred Technical and Professional Experience:
- Optimize ETL processes for performance and minimal resource utilization.
- Work closely with cross-functional teams for smooth integration of ETL solutions.
- Provide technical expertise in design reviews and documentation.