Data Engineer II B - GBS IND

Bank of America; Hyderabad; On-site; INR 3,000,000 - 4,200,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

Bank of America is seeking an Informatica and Oracle DB Data Engineer to join the GIS team in India. You will be the technical developer for Oracle and Informatica solutions, combining senior-level hands-on development with leadership, design decisions, and mentoring.

The role emphasizes end-to-end delivery of PL/SQL and ETL components, with collaboration across architecture and product teams, and a focus on performance and reliability in data-intensive environments.

Qualifications

• Bachelor's degree in Computer Science or related field
• 7+ years of experience in Oracle SQL/PL/SQL development and ETL
• Strong hands-on experience with Informatica PowerCenter
• Strong understanding of Data Warehousing concepts (facts, dimensions, star/snowflake)
• Experience with large datasets and high-volume batch processing
• Proficient debugging, analytical and troubleshooting skills
• Experience with data integration and data quality
• Experience with Oracle database internals and performance tuning

Responsibilities

• Own end-to-end design and delivery of PL/SQL and ETL components.
• Define coding standards, performance benchmarks, and best practices.
• Review and approve technical designs, code, and ETL workflows.
• Collaborate with architects, product owners, and business stakeholders; provide estimates, risk assessment, and delivery plans.
• Support releases, production deployments, and major incident resolution.

Job description

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. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day. Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates’ physical, emotional, and financial wellness through affordable, competitive and flexible benefits. We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve. Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs. At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. 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

The Global Information Security (GIS) role is responsible for protecting the organization’s information assets, systems, and data across global operations. This role ensures confidentiality, integrity, and availability of information by implementing security controls, monitoring threats, managing risks, and ensuring compliance with internal policies and regulatory requirements.

Job Description

We invite you to join the GIS team as an Informatica and Oracle DB Data Engineer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive to their unique needs. The Data Engineer acts as the technical developer for Oracle and Informatica solutions within a project or program. This role combines senior-level hands-on development with technical leadership, estimation, design decisions, and team mentoring.

Responsibilities

• Technical Data Engineer Own end-to-end design and delivery of PL/SQL and ETL components
• Define coding standards, performance benchmarks, and best practices
• Review and approve technical designs, code, and ETL workflows
• Delivery & Stakeholder Interaction Collaborate with architects, product owners, and business stakeholders Provide technical estimates, risk assessment, and delivery plans Support releases, production deployments, and major incident resolution

Oracle Development (PL/SQL)

Design, develop, and maintain complex Oracle PL/SQL components, including:

• Stored Procedures, Functions, Packages, Triggers, Views and Materialized Views

Write and optimize complex SQL queries for high-volume transactional and analytical systems Implement efficient data processing logic using BULK COLLECT, FORALL, cursors, and collections Enforce coding standards, best practices, and documentation for PL/SQL development Work closely with data modelers and architects to ensure optimal schema and index design Provide support for production issues, bug fixes, and performance enhancements

Informatica (ETL) Development

Hands-on development and maintenance of Informatica PowerCenter mappings, sessions, and workflows Design end-to-end ETL solutions for Data Warehousing and operational systems Strong experience with Informatica transformations including:

• Source Qualifier, Lookup (connected/unconnected), Joiner, Aggregator, Router, Expression, Filter, Update Strategy

Experience handling slowly changing dimensions (SCDs), incremental loads, and data validation checks Ability to analyze and resolve ETL job failures and data issues Monitor and enhance ETL performance using Informatica tuning techniques

Requirements

• Education : Bachelor’s degree in Computer Science, Information Security, or a related field
• Certifications If Any : NA
• Experience Range : 7+ years
• Foundational skills : Strong expertise in Oracle SQL and PL/SQL development Proven hands-on experience with Informatica PowerCenter Strong understanding of Data Warehousing concepts (facts, dimensions, star/snowflake schemas) Deep experience in SQL and ETL performance tuning Experience working with large datasets and high-volume batch processing Strong analytical, debugging, and troubleshooting skills

Desired Skills

• Conducts logical and physical database design Designs key and indexing schemes and designs partitioning Constructs and implements operational data store Analyze and Optimize query performance Ensures that data models are consistent with the ecosystem Adheres to data management standards and advises on best practices Participates in building and testing business continuity & disaster recovery procedures per requirements Has experience with relational database internals, including both query processing and query planning, or other data processing infrastructure Has knowledge of key data structures and algorithms Has knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases Has experience with dealing with data at scale Has experience adhering to strict audit standards Has experience with relational database management systems (e.g. Oracle) Has experience in different programming/scripting languages (e.g. python) and ETL tools (e.g. Informatica) Experience with Data Analysis and Science will be a plus, the ideal candidate should be able to understand the business driven off the data and how it fits into the Application platform

Work Timings : 11:30 IST to 20:30 IST

Job Location : Hyderabad/Chennai /Mumbai

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!

Partnering Locally

Learn about some of the ways Bank of America is making a difference in the communities we serve.

Global Impact

Learn about the six areas that guide Bank of America's efforts to help make financial lives better for customers, clients, communities and our teammates.

Opportunity and Inclusion

Each employee brings unique skills, background and opinions. We see opportunity and inclusion as our platform for innovation and a key component in our success.

Our Values

Learn about our four values that represent what we believe.