Job Description

Job Title: Data Engineer Batch Location: Pune
About Barclays Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group.
Risk and Control Objective Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.
Working Flexibly
We're committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers' and clients' needs. Whether you have family commitments or you're a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life. If you would like some flexibility then please discuss this with the hiring manager.
Introduction:
Design and Development of ETL solutions for BUK Shared Technology work in Information Management using Ab-Initio (ETL) technologies.

• Design, Development & Testing of complex ETL components
• Create and maintain optimal data pipeline architecture
• E2E Implementation of ETL solution along with support
• Work with stakeholders including the Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
• Complete Ownership of ETL application or process
• Ability to provide technical help to team members and participate and contribute to relevant technical standards
• Adoption of new tech skills and implement internal process improvements using new tech skills

What will you be doing?

• Design, development and implementation of optimal data pipeline architecture and data structures for data lake/data warehouse using Ab-Initio.
• Work with stakeholders including the Product, Data and Design teams to assist with data related technical issues and support their data analytical needs
• Streamline existing and introduce enhanced reporting and analysis solutions that leverage complex data sources derived from complex multiple internal systems
• Design and build the infrastructure required for optimal ETL Solution for data from variety of different sources using Ab-Initio ETL Technologies
• Define and document best code practice within an agile environment with DevOps approach to development and implementation
• Contribute broadly to data engineering development work and Provide database design, development and implementation support
• Develop Data Ingest Techniques from multiple data sources
• Learn new tools and expand big data functionalities by implementing additional Hadoop and Spark ecosystem components to meet evolving business needs
• Responsible for creating work estimate, technical projects plans and PROD implementation plan
• E2E Responsibility of developed application which includes critical data issue resolution and BAU support to stakeholders
• Lead POC work for new product ideas - should perform well as an individual contributor and lead the activities along with other data engineers

Leading Others

• 
  
  • Responsible for co-ordinating, participating in, and is responsible for, the work of a team of managed services/ contractors on a need basis.
  • Making effective use of resources during the various stages of the work, ensuring that business objectives are met and deliverables achieved to agreed time, and quality
  • Providing advice, guidance and assistance to less experienced colleagues (as required).
  • Putting in place mechanisms and procedures for the structured review of work produced and ensuring that these are adhered to.
  • Establishing and maintaining agreed standards applicable to the work undertaken and ensuring that these, and other mandatory standards and architectures, are adhered to.
  
  

Capability Growth

• 
  
  • Building and maintaining an expert understanding of the various stages of software development, enhancements, and support (where required).
  • Providing guidance and assistance to colleagues in any aspect of programme design, creation, testing and documentation.
  • Interfacing with other teams, sharing technical knowledge and expertise and resolving issues as necessary. Acting as a point of reference for both internal and external technical queries.
  
  

Organizational Improvement

• 
  
  • Assisting with the implementation of operational objectives for relevant team/programme.
  • Supporting the implementation of strategy and policy issues by involvement in development/change and/or advice to other technical areas and making recommendations to improve procedures and working practices.
  • Taking part in evaluations and reviews of programming methods, tools and standards.
  
  

What we're looking for:

• Excellent communication and written skills
• Good understanding of banking/financial domain
• Strong analytical skills and aptitude for problem solving
• Good team player and able to lead, guide and support developers or junior team members
• Able to work independently and work along with team

Skills that will help you in the role:

• Expertise in Ab-Initio (Batch) & ETL Design /Solution skills along with performance enhancement knowledge
• Experience with relational database such as Oracle, SQL Server, Teradata
• Strong knowledge of data and analytics, ETL (Ab-Initio), reporting tools, data governance, data warehousing, structured and unstructured data.
• Experience of Tech team leading and providing support whenever required
• Passionate about Agile Software processes, data-driven development, reliability and experimentation
• Experience developing and maintaining data warehouse in big data solutions using Ab-Initio Technologies

Desirable skills/Preferred Qualifications:

• B.E./B. Tech in Computer Science, Engineering or related degrees
• Experience designing, building, and maintaining data processing systems
• Big data knowledge including Hive, Impala, HDFS, Scala
• SQL query writing using Teradata and Oracle would be added advantage
• TWS Scheduling & Unix scripting Knowledge
• Big data knowledge including Hive, Impala
• Should have good experience on Unix Scripting and command
• Work experience with R, Python, Scala and Pandas or similar programming knowledge is plus

Where will you be working? Pune
Be More at Barclays At Barclays, each day is about being more - as a professional, and as a person. 'Be More @ Barclays' represents our core promise to all current and future employees. It's the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are. Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details. Purpose, Values and Mindset
We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term. Our values underpin everything we do: Respect, Integrity, Service, Excellence and Stewardship.
Respect We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone's contribution. Integrity We operate with honesty, transparency and fairness in all we do. Service We act with empathy and humility, putting the people and businesses we serve at the centre of what we do. Excellence We champion innovation, and use our energy, expertise and resources to make a positive difference. Stewardship We prize sustainability, and are passionate about leaving things better than we found them.
Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do; our Mindset is to Empower, Challenge and Drive.
Empower Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure. Challenge Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and be open to alternative viewpoints. Drive Focus on outcomes. Deliver with pace. Be passionate and ambitious about what we do. Take personal responsibility. Actively build collaborative relationships to get things done.