ETL Platform Engineer

ETL Platform Engineer at American Express Global Business Travel

Amex GBT is a place where colleagues find inspiration in travel as a force for good and – through their work – can make an impact on our industry. We’re here to help our colleagues achieve success and offer an inclusive and collaborative culture where your voice is valued.

We are seeking a talented and experienced ETL Platform Engineer to join our Technology team. This is a technical role focused on administering, maintaining, and optimizing the Ab Initio - Enterprise ETL Platform in a Linux environment. This position focuses on platform operations, performance optimization, version management, and providing technical support to application teams running ETL jobs on the platform.

What You’ll Do

As an ETL Platform Engineer, your responsibilities will include:

• Platform Administration & Maintenance: Install and configure Ab-initio Software components in Linux Environments. Administer and maintain the Ab-Initio platform infrastructure in Linux environments. Perform platform version upgrades and patch management with minimal downtime. Execute Co>Op upgrades and ensure platform stability post-upgrade. Configure and manage dbc/ini files for integration with various source systems and target databases. Manage platform configuration, security, and access controls. Perform routine maintenance tasks and automate operational procedures.
• ETL Job Support & Monitoring: Monitor ETL job execution and platform performance in real-time. Provide technical support to application teams for ETL job processing and troubleshooting. Troubleshoot and resolve platform-related issues impacting ETL job execution.
• Code Promotion & Deployment: Manage code promotion activities across development, testing, and production environments. Coordinate with application teams on deployment schedules and requirements. Validate code deployments and ensure platform stability post-promotion. Maintain deployment documentation and change logs. Support rollback procedures if needed.
• Monitoring, Performance Optimization & Tuning: Monitor platform performance metrics and identify optimization opportunities. Analyze ETL job performance and recommend tuning strategies. Implement performance improvements and validate results. Optimize resource utilization (CPU, memory, disk I/O) across the platform. Conduct capacity planning and recommend infrastructure enhancements.
• Integration & Connectivity: Configure and maintain connectivity with various source systems and target databases. Set up and manage database connections and integration parameters. Support data ingestion from multiple sources and Data platforms. Troubleshoot connectivity and data flow issues.

What We’re Looking For

• 3+ years of hands-on experience with ETL/data integration tools; preferably with Ab Initio.
• 3+ years of Ab Initio platform administration and operational support experience.
• Strong understanding of Ab Initio architecture, components, and configuration.
• Proficiency in Ab Initio platform administration, maintenance, and troubleshooting.
• Experience with Ab Initio version upgrades and Co-Op upgrades.
• Experience supporting ETL job execution and troubleshooting.
• Proficiency in Linux/Unix environments and command-line operations.
• Shell scripting expertise.
• Familiarity with system monitoring and performance analysis tools.

Preferred Qualification

• Strong knowledge of SQL, data warehousing concepts, various data management systems and integrating with various database technologies like UDB, IBM Netezza & PDOA appliances or Microsoft SQL server is required.
• Development experience with ETL/data integration tools; preferably with Ab Initio.
• Knowledge of Big Data ingestion techniques/tools & integrating with NoSQL databases is a plus.
• Knowledge of Ab Initio metadata management and repository administration.
• Experience with Ab Initio parallel processing and optimization techniques.

Location

Bangalore, India

The #TeamGBT Experience

Find your happy medium at Amex GBT:

• Work and life: Flexible benefits are tailored to each country and start the day you do. These include health and welfare insurance plans, retirement programs, parental leave, adoption assistance, and wellbeing resources to support you and your immediate family.
• Travel perks: Get a choice of deals each week from major travel providers on everything from flights to hotels to cruises and car rentals.
• Develop the skills you want: Access over 20,000 courses on our learning platform, leadership courses, and new job openings available to internal candidates first.
• Champion Inclusion: Connect with colleagues through our global INclusion Groups, centered around common identities or initiatives, to discuss challenges, obstacles, achievements, and drive company awareness and action.

And much more!

We are committed to providing reasonable accommodation to qualified individuals with disabilities. Please let your recruiter know if you need an accommodation at any point during the hiring process. For details regarding how we protect your data, please consult the Amex GBT Recruitment Privacy Statement.

If you’re passionate about our mission and believe you’d be a phenomenal addition to our team, don’t worry about “checking every box;” please apply anyway. You may be exactly the person we’re looking for!

Key skills/competency

• Ab Initio platform administration
• ETL job support
• Linux/Unix environments
• Shell scripting
• Performance optimization
• Data integration
• SQL
• Data warehousing
• Troubleshooting
• Version management