Senior ETL Data Egg

Barclays; Maharashtra; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

Barclays in Pune is seeking a Senior ETL Data Engineer to lead the evolution of our data infrastructure and deployment pipelines. You will build scalable, secure data systems and advance our digital solutions.

The role requires hands-on experience with AbInitio, SQL across all languages, Python and PySpark, plus cloud familiarity with AWS. You will collaborate with data scientists and stakeholders to deliver robust data services.

Qualifications

• Experience with AbInitio GDE graphs, plans, EME object/version management.
• Proficiency in Linux/Unix and Shell scripting.
• Strong Python and PySpark, with DataFrames, RDD and SparkSQL.
• Extensive SQL across DML, DDL and DCL.
• Experience with Oracle RDBMS and MongoDB NoSQL.
• Exposure to AWS and cloud services.
• Migration project experience.

Responsibilities

• Build and maintain data architectures pipelines that enable transfer and processing of durable, complete data.
• Design and implementation of data warehouses and data lakes with proper security.
• Develop processing and analysis algorithms for large data volumes and complexity.
• Collaborate with data scientists to build and deploy machine learning models.

Skills

AbInitio

Linux/Unix

Shell scripting

Python

PySpark

SQL

Oracle RDBMS

MongoDB

AWS

Migration projects

Stakeholder engagement

Data warehousing

Interpersonal skills

Job description

Join us as a Senior ETL Data Egg, 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.

To be successful as a Senior ETL Data Egg, you should have experience with:

• Practical AbInitio experience (GDE graphs, plans, psets, EME object/version management, environment migration, object comparison/diff).


• Proficiency in Linux/Unix and Shell scripting.


• Experience in python and PySpark and strong knowledge on Dataframes, RDD and SparkSQL.


• Experience in SQL in all 3 areas viz., DML (data manipulation language), DDL (data definition language) and DCL (data control language).


• Experience in working with Oracle RDBMS.


• Experience in working with MongoDB NoSQL database.


• Exposure to cloud services like AWS.


• Experience in any kind of migration projects.

Some Other Highly Valued Skills May Include

• Ability to engage with Stakeholders, elicit requirements/ user stories and translate requirements into ETL components.


• Ability to understand the infrastructure setup and be able to provide solutions either individually or working with teams.


• Good knowledge of Data Marts and Data Warehousing concepts.


• Resource should possess good analytical and Interpersonal skills.

You may be assessed on key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking and digital and technology, as well as job-specific technical skills.

The role is based out of Pune.

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

• To 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


• They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.


• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.


• OR for an individual contributor, they 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 your 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 – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.