- 4+ years of hands-on Ab Initio development experience.
- Design, develop, and maintain ETL workflows using Ab Initio.
- Build and optimize graphs, plans, and reusable components.
- Develop complex data integration and transformation processes.
- Work with GDE, Co>Operating System, EME, and Conduct>It.
- Write and optimize SQL queries for data extraction and transformation.
- Perform data validation, reconciliation, and troubleshooting.
- Monitor ETL jobs and resolve production issues.
- Collaborate with business analysts, data architects, and other development teams.
- Ensure data quality, accuracy, and performance optimization.
- Participate in code reviews, testing, and deployment activities.
Key Responsibilities
- 8+ years of overall IT experience.
- 4+ years of hands-on Ab Initio development experience.
- Design, develop, and maintain ETL workflows using Ab Initio.
- Build and optimize graphs, plans, and reusable components.
- Develop complex data integration and transformation processes.
- Work with GDE, Co>Operating System, EME, and Conduct>It.
- Write and optimize SQL queries for data extraction and transformation.
- Perform data validation, reconciliation, and troubleshooting.
- Monitor ETL jobs and resolve production issues.
- Collaborate with business analysts, data architects, and other development teams.
- Ensure data quality, accuracy, and performance optimization.
- Participate in code reviews, testing, and deployment activities.
Required Skills
- Strong hands-on experience with Ab Initio ETL development.
- Experience with Ab Initio GDE and Co>Operating System.
- Knowledge of Conduct>It and Enterprise Meta Environment (EME).
- Strong SQL and database concepts.
- Experience with Oracle, DB2, Teradata, or similar databases.
- Understanding of data warehousing and ETL concepts.
- Knowledge of Unix/Linux shell scripting.
- Experience with performance tuning and debugging.
Preferred Qualifications
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Knowledge of Python or other scripting languages.
- Experience with Agile/Scrum methodologies.
- Understanding of financial services or banking data.
Skills: teradata,etl,azure,aws,oracle,ab initio,sql