Abinitio Developer (2-5 years)

Infosys; Hyderabad; On-site; INR 700,000 - 1,000,000; Full time

Job summary

Infosys in Hyderabad is seeking an ETL/Data Engineer to design and implement data integration solutions within the Data Analytics Unit. You will transform business requirements into scalable ETL workflows, extract and load data across sources, and maintain SQL queries and shell scripts.

Your role includes data profiling, cleansing, validation, and ensuring data quality, while optimizing batch jobs and supporting production systems. Collaboration with analysts and DBAs is essential.

Qualifications

• ETL design and data integration capabilities required.
• Proficiency in writing SQL queries and stored procedures.
• Experience with Unix shell scripting for data processing.
• Ability to profile, cleanse, and reconcile data to ensure quality.
• Experience in optimizing ETL jobs for performance.

Responsibilities

• Design and develop ETL workflows (graphs) using Ab Initio GDE.
• Analyze business requirements and convert them into data integration solutions.
• Extract data from multiple sources, transform, and load into data warehouses.
• Write and maintain SQL queries and Unix shell scripts.
• Perform data profiling, validation, cleansing, and reconciliation for quality.
• Optimize ETL jobs for performance and scalability.
• Troubleshoot production issues and provide application support.
• Conduct code reviews, testing, deployment, and documentation.
• Collaborate with BAs, data architects, DBAs, QA, and stakeholders.
• Manage scheduling tools like Autosys or Control-M and monitor batch jobs.

Skills

ETL design

SQL scripting

Unix shell

Data profiling

Data quality

Troubleshooting

Education

MCA

MSc

MTech

Bachelor of Engineering

BCA

BSc

BTech

Tools

Ab Initio GDE

Autosys

Control-M

Job description

Educational Requirements;

MCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech

Service Line;

• Data Analytics Unit

Key Responsibilities

• Design and develop ETL workflows (graphs) using Ab Initio GDE
• Analyze business requirements and convert them into technical data integration solutions.
• Extract data from multiple source systems, transform it, and load it into data warehouses or target systems.
• Write and maintain SQL queries, stored procedures, and Unix shell scripts.
• Perform data profiling, validation, cleansing, and reconciliation to ensure data quality.
• Optimize ETL jobs for performance and scalability.
• Troubleshoot production issues and provide application support.
• Conduct code reviews, testing, deployment, and documentation activities.
• Collaborate with business analysts, data architects, DBAs, QA teams, and stakeholders.
• Manage scheduling tools such as Autosys or Control-M and monitor batch processing jobs.