Software Engineer III - GBS IND

Job Description:

About Us

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection.  Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.

One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We’re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.

 Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.

Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Global Business Services

Global Business Services delivers Technology and Operations capabilities to Lines of Business and Staff Support Functions of Bank of America through a centrally managed, globally integrated delivery model and globally resilient operations.

Global Business Services is recognized for flawless execution, sound risk management, operational resiliency, operational excellence and innovation.

In India, we are present in five locations and operate as BA Continuum India Private Limited (BACI), a non-banking subsidiary of Bank of America Corporation and the operating company for India operations of Global Business Services.

Process Overview

ATLAS – Corporate Technology Data Mart build with Informatica / Exadata to support Global Liquidity platform for internal, regulatory reporting and analytics. It is targeted to address current limitations in architecture, design and processes

Job Description

The Horizontal Data team within GBAMT ERFT- Finance Technology is seeking an ETL developer to join its team. The individual selected for this role will be experienced in Informatica and possess strong Oracle and data warehousing skills as well as be well versed in the Agile software development lifecycle methodology.

The developer will be a member of an agile scrum team and will work closely with an on-shore product lead and developers as well as off-shore developers and testers.

The developer will participate in all relevant Agile ceremonies; some after-hours support in the form of validating deployments and troubleshooting production issues may be required

Responsibilities

As an ETL Developer, candidate will be expected to help the team craft data solutions to meet business and enterprise requirements using SQL and ETL Tools to enhance and support a Data Warehouse.

Required Skills and Experience we are Looking For:

• Strong SQL skills and awareness / experience of good coding practices and ability to articulate such.
• Practical working experience with relational databases, preferably Oracle Exadata.
• Familiarity with Data Warehouse / Data Mart / Data Modeling / Business Intelligence concepts.
• Familiarity with Informatica.
• Familiarity with Autosys / Orchestration Tools.
• Someone who likes data, enjoys puzzles and is intrigued by using new and existing tools to map out data transformation solutions.

Requirements

• Education: B.E./ B. Tech/M.E./M. Tech/BSC/MSC/BCA/MCA (prefer IT/CS specialization)

• Experience Range: 7-10 years

Foundational skills*:

• Extensive experience in designing and implementing Data Warehouse and Data Mart solutions
• Strong Data Warehousing & Business Intelligence concepts in designing and implementing the dimensional Star Schema and Snowflakes Schema methodologies.
• Strong knowledge in Informatica PowerCenter
• Hands on experience on programming using Java, Python or any OOP programming language.
• Hands on experience with Oracle, SQL Server.
• Hands on Experience with UNIX, Autosys, JIRA, Bitbucket
• General financial instruments knowledge (equities, fixed income, options, swaps, futures, foreign exchange) in capital markets area.
• Excellent communication skills.
• Highly committed and ability to work in fast paced environment against tight deadlines
• Ability to work in international virtual teams and in matrix structures and being a good team player
• Positive attitude to resolve problems and ability to work odd hours to support the business demands

Primary Technical Skills

• Operating System          : UNIX / Windows
• ETL                                   :   Informatica
• Database                         :  Oracle
• Language                         : Python

Desired skills:

• Exposure / self-education with Unix scripting.
• Exposure / self-education with Python (e.g. Pandas, Data Frames) and use in data processing solutions.
• Exposure to CI/CD processes and tools (e.g. Ansible, Jenkins).
• Exposure to Airflow extremely helpful but not required.
• Experience designing and building data warehouses and knowledge of the data flows involved.
• Willingness to take on problems outside of current skillset and experience.
• Experience with development methodologies and working in an agile framework.

Work Timings: 11:00 AM to 8:00 PM

Job Location*: Chennai