Verified 5 days ago
Senior Engineer II
About the role
Data Integration Team at American Express Global Business Travel builds and maintains enterprise-grade ETL pipelines and the Ab Initio platform. The Senior Engineer designs, develops, and optimizes scalable ETL/ELT workflows, administers the Ab Initio environment on Linux, and supports Kafka‑based data movement. Bangalore, on‑site, hybrid schedule with occasional remote days as needed.
What you’ll do
- Design, develop, and maintain Ab Initio ETL workflows
- Administer and upgrade Ab Initio platform components
- Optimize ETL job performance and resource utilization
- Support application teams with ETL job processing and issue resolution
- Develop and maintain Kafka integration pipelines
- Write and tune advanced SQL queries for data extraction and validation
- Automate operational tasks using shell scripts
- Document platform configurations and change logs
What you’ll bring
- 5+ years ETL/data integration experience
- 5+ years Ab Initio platform administration
- Strong Linux/Unix command‑line skills
- Advanced SQL and PostgreSQL expertise
- Kafka production and consumption experience
- Shell scripting for automation
- Performance tuning of ETL jobs
- Troubleshooting complex data pipelines