Senior Engineer II
On-site · Bengaluru, Karnataka, India
Job Summary
Senior ETL Engineer with deep expertise in Ab Initio, ETL/data integration, and Linux-based platform administration. Responsible for designing, developing, and supporting enterprise-scale ETL/ELT workflows using Ab Initio, administering the Ab Initio platform, performing performance tuning and capacity planning, managing code promotion and release activities across environments, and integrating with PostgreSQL and other databases. Candidates should have strong SQL skills, experience with Kafka-based data movement, and familiarity with Airflow for workflow orchestration. The role emphasizes collaboration with engineering and business stakeholders, troubleshooting, and maintaining data quality across complex data pipelines in a fast-paced enterprise setting.
Required Qualifications
- 5+ years of hands-on experience with ETL/data integration tools, preferably Ab Initio
- 5+ years of strong experience in Ab Initio platform administration, maintenance, and operational support
- Strong understanding of Ab Initio architecture, components, configuration, and platform management
- Proven experience in Ab Initio version upgrades, patching, and Co>Op upgrades
- Strong hands-on experience in supporting ETL job execution, troubleshooting failures, and resolving platform-related issues
- Strong proficiency in Linux/Unix environments and command-line operations
- Good hands-on expertise in shell scripting for automation and operational support
- Strong experience in PostgreSQL and integration with multiple database technologies
- Excellent knowledge of SQL, including: complex joins subqueries aggregations analytical/window functions performance tuning reconciliation and validation queries
- Practical experience with Kafka, including: producing data to Kafka topics consuming data from Kafka topics understanding event-driven and streaming integration concepts
- Strong troubleshooting and problem-solving skills in enterprise data environments
- Experience with monitoring, performance analysis, and platform optimization
- Exposure to Apache Airflow for workflow orchestration and scheduling
- Development experience with ETL/data integration tools, preferably Ab Initio
- Strong understanding of data warehousing concepts and enterprise data integration patterns
- Experience integrating with multiple database technologies such as: PostgreSQL IBM DB2 IBM Netezza Microsoft SQL Server
- Knowledge of Ab Initio metadata management and repository administration
- Experience with Ab Initio parallel processing and optimization techniques
- Knowledge of Big Data ingestion techniques/tools and integration with NoSQL databases
- Experience working with multiple data platforms and enterprise data ecosystems
- Soft Skills: Strong verbal and written communication, stakeholder collaboration, prioritization, problem-solving, governance, documentation, and teamwork
- Location Bangalore, India
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.