Ab Initio ETL Developer

Persistent Systems; Pune District; Hybrid; INR 1,500,000 - 2,300,000; Full time

Benefits offered by this job

Hybrid work

Job summary

Persistent is seeking an Ab Initio ETL Developer to join our Data Engineering team. The role focuses on designing, developing, testing, and delivering enterprise data solutions using Ab Initio GDE, with strong SQL and UNIX scripting skills.

You will work across on-premises and cloud environments, implementing CI/CD pipelines, and collaborating in an Agile setting to ensure high-quality, scalable data products.

Qualifications

• Experience in ETL development for enterprise-scale data engineering solutions.
• Hands-on Ab Initio GDE with graph design, development, testing, and deployment.
• Strong SQL skills with performance tuning and complex queries.
• Proficiency in UNIX shell scripting for automation.
• Experience with CI/CD using Jenkins or GitLab CI and source control (Git/GitHub/Bitbucket).

Responsibilities

• Design, develop, test, and deliver enterprise data engineering solutions.
• Build and maintain ETL solutions using Ab Initio GDE.
• Analyse source-to-target mapping requirements for data integration.
• Develop data processing in on-premises and cloud environments.
• Create reusable ETL frameworks and components.
• Coordinate with Product Owners, Analysts, and engineers in Agile ceremonies.
• Write and optimize complex SQL queries and database objects.
• Develop UNIX shell scripts to automate tasks.
• Participate in sprint planning and estimations.
• Ensure unit and integration testing and resolve production issues.

Skills

ETL development

Data warehousing

Agile delivery

SQL proficiency

Unix scripting

Education

Bachelor's degree in Computer Science / related

Tools

Ab Initio GDE

Jenkins

GitLab CI

GitHub

Bitbucket

Job description

We are seeking a highly skilled Ab Initio ETL Developer to join our Data Engineering team. The ideal candidate will have extensive experience in ETL development, data processing, data warehousing, and enterprise-scale data engineering solutions. The role requires expertise in Ab Initio development, SQL, UNIX scripting, CI/CD practices, and Agile delivery methodologies to build and support robust, scalable, and high-performing data solutions.

• Experience: 5 to 8 Years
• Job Type: Full Time Employment

What You'll Do:

• As an Ab Initio ETL Developer, you will be responsible for designing, developing, testing, and delivering enterprise data engineering solutions. You will work closely with Product Owners, Business Analysts, architects, and engineering teams to ensure successful delivery of high-quality data products.
• Design, develop, and maintain ETL solutions using Ab Initio Graphical Development Environment (GDE).
• Analyse and implement source-to-target mapping requirements for data integration projects.
• Build and support data processing solutions across on-premises and cloud-based environments.
• Develop reusable and scalable ETL frameworks and components.
• Write, optimise, and maintain complex SQL queries and database objects.
• Develop UNIX shell scripts to automate routine operational and data processing tasks.
• Implement CI/CD pipelines using tools such as Jenkins and GitLab CI for automated deployments.
• Utilise version control systems including Git, GitHub, and Bitbucket for source code management.
• Collaborate with Product Owners, Business Analysts, and engineering teams to define requirements and evaluate solution feasibility.
• Participate actively in sprint planning, estimation, and Agile ceremonies.
• Perform unit testing, integration testing, and ensure adherence to quality standards.
• Troubleshoot production issues and provide timely resolution.
• Drive continuous improvement initiatives and engineering best practices across the development lifecycle.

Expertise You'll Bring:

• We are looking for a passionate data engineering professional with strong ETL development expertise, exceptional problem-solving skills, and experience delivering high-quality enterprise data solutions.
• Strong experience in ETL, Data Processing, Data Warehousing, and Data Engineering.
• Hands-on expertise in Ab Initio GDE, including graph design, development, testing, and deployment.
• Strong understanding of source-to-target mapping and ETL design principles.
• Experience working with both on-premises and cloud-based data platforms.
• Advanced SQL skills with expertise in performance tuning and query optimisation.
• Strong knowledge of relational database management systems (RDBMS).
• Hands-on experience with UNIX shell scripting.
• Experience with CI/CD tools such as Jenkins, GitLab CI, or similar platforms.
• Proficiency with version control systems including Git, GitHub, and Bitbucket.
• Knowledge of Agile methodologies, Scrum practices, and JIRA.
• Ability to design, develop, test, and deliver end-to-end data engineering solutions.
• Strong focus on quality, performance scalability, maintainability, and security.
• Experience conducting code reviews and implementing engineering best practices.
• Ability to define and implement Definition of Done, including unit testing, integration testing, and non-functional quality standards.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work collaboratively in a fast-paced Agile environment.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Let’s unleash your full potential at Persistent - persistent.com/careers

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.