IFC - ETL Developer

1203 Barclays Global Serv. Cent; Pune District; On-site; INR 700,000 - 1,200,000; Full time

Job summary

1203 Barclays Global Serv. Cent is seeking an ETL Developer in Pune, India to lead data architecture and build robust data pipelines. You will design and implement scalable solutions while ensuring data accuracy and security.

The ideal candidate has extensive experience with Ab-Initio, Unix, and Python. This role includes collaborating with data scientists and leading a team to drive innovation in data management.

Join us in driving operational excellence through cutting-edge technology.

Qualifications

• Experience with Ab-Initio design, development, and maintenance of complex ETL processes.
• Strong command-line proficiency in Unix.
• Develop scripts for data validation and automation using Python.
• Design and implement enterprise data warehouse solutions.
• Knowledge of data pipeline optimisation and performance tuning.
• Experience with AWS for data storage and processing.
• Familiarity with Hadoop for data processing and analytics.

Responsibilities

• Build and maintain data architectures and pipelines.
• Collaborate with data scientists to deploy machine learning models.
• Ensure data accuracy, accessibility, and security.
• Lead a team in managing risk and strengthening controls.
• Partner with business functions for integrated solutions.

Skills

Ab-Initio design

Unix command-line proficiency

Python scripting

Data Warehouse concepts

AWS cloud solutions

Hadoop ecosystem

Data pipeline optimisation

Problem-solving

Job description

Job Description Purpose of the Role

To build and maintain the systems that collect, store, process, and analyse data, such as data pipelines, data warehouses and data lakes to ensure that all data is accurate, accessible, and secure.

Accountabilities

• Build and maintenance of data architectures pipelines that enable the transfer and processing of durable, complete and consistent data.
• Design and implementation of data warehoused and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures.
• Development of processing and analysis algorithms fit for the intended data complexity and volumes.
• Collaboration with data scientist to build and deploy machine learning models.

Analyst Expectations

• Perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement.
• Requires in-depth technical knowledge and experience in their assigned area of expertise.
• Thorough understanding of the underlying principles and concepts within the area of expertise.
• Lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.
• For leadership roles, demonstrate the LEAD behaviours: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.
• Or for an individual contributor, develop technical expertise in work area, acting as an advisor where appropriate.
• Will have an impact on the work of related teams within the area.
• Partner with other functions and business areas.
• Takes responsibility for end results of a team’s operational processing and activities.
• Escalate breaches of policies/procedure appropriately.
• Take responsibility for embedding new policies/ procedures adopted due to risk mitigation.
• Advise and influence decision making within own area of expertise.
• Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to.
• Deliver work and areas of responsibility in line with relevant rules, regulation and codes of conduct.
• Maintain and continually build an understanding of how own sub‑function integrates with function, alongside knowledge of the organisations products, services and processes within the function.
• Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub‑function.
• Make evaluative judgements based on the analysis of factual information, paying attention to detail.
• Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents.
• Guide and persuade team members and communicate complex/sensitive information.
• Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship and the Barclays Mindset – to Empower, Challenge and Drive.

Job Overview – IFC – ETL Developer

Join us as an IFC – ETL Developer at Barclays where you will spearhead the evolution of our infrastructure and deployment pipelines, driving innovation and operational excellence. You will harness cutting‑edge technology to build and manage robust, scalable and secure infrastructure, ensuring seamless delivery of our digital solutions.

Required Experience and Skills

• Experience with Ab‑Initio design, development and maintenance of complex ETL processes and data flows using Ab‑Initio platform.
• Unix, strong command‑line proficiency for job scheduling, monitoring and system administration.
• Python, develop scripts for data validation, automation and integration tasks.
• Data Warehouse concepts/design: design and implement enterprise data warehouse solutions, dimensional modelling, star/snowflake schemas and ETL architectures.
• Strong knowledge of data pipeline optimisation, performance tuning and data quality management, with a proven track‑record of delivering scalable data warehousing solutions.
• Experience with AWS cloud‑based data storage and processing solutions.
• Experience with Hadoop big‑data ecosystem for large‑scale data processing and analytics.
• Strong problem‑solving skills and ability to multi‑task.
• Experience with integration of multiple data sources and toolsets.

Location: Pune, IN.