Job Information
Bank of America Software Engineer III in Atlanta, Georgia
Software Engineer III
Atlanta, Georgia
Job Description:
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!
Job Description:
This job is responsible for developing and delivering complex requirements to accomplish business goals. Key responsibilities of the job include ensuring that software is developed to meet functional, non-functional and compliance requirements, and solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Job expectations include a strong knowledge of development and testing practices common to the industry and design and architectural patterns.
The role is responsible for the design, development, coding, testing, debugging and documentation of data-warehouse/database/business intelligence applications.
Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications.
Translate business requirements into technical specifications.
Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.
Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.
Hands on logical and physical data modeling and database design responsibilities.
Good understanding of Dimensional modeling
Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.
Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications.
Hands on experience to develop and support Unix Shell Scripting.
Should have understanding of scheduler (Autosys)
Perform data analysis and data profiling. Identify data quality issues.
Self starter, able to work on fast paced complex setup, able to function independently and deliver the work by proactively resolving the impediments. This is NOT a Jr role where developer is awaiting step by step guidance from team to function and deliver.
Responsibilities:
Codes solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements
Designs, develops, and modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained
Mentors other software engineers and coach team on Continuous Integration and Continuous Development (CI-CD) practices and automating tool stack
Executes story refinement, definition of requirements, and estimating work necessary to realize a story through the delivery lifecycle
Performs spike/proof of concept as necessary to mitigate risk or implement new ideas
Automates manual release activities
Designs, develops, and maintains automated test suites (integration, regression, performance)
Required Qualifications:
Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
Contribute to story refinement/defining requirements.
Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.
Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
Utilize multiple architectural components (across data, application, business) in design and development of client requirements.
Assist team with resolving technical complexities involved in realizing story work.
8+ years Informatica or other ETL tool
6+ years of professional experience with SQL/PLSQL
Understand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts.
Experience automating ETL with job scheduling tools. Autosys Preferred
Experience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plus
Demonstrate exceptional analytical skills and problem solving skills; excellent organizational, communication skills
A good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships.
An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.
Desired Qualifications:
Document and communicate required information for deployment, maintenance, support, and business functionality.
Strong experience in Informatica, Datawarehousing, data architecture, databases and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasets
Contribute to existing test suites (integration, regression, performance),analyze test reports, identify any test issues/errors, and triage the underlying cause.
Using Trino, Starburst or similar vendor tool exposure would be a plus.
Skills:
Application Development
Automation
Influence
Solution Design
Technical Strategy Development
Architecture
Business Acumen
DevOps Practices
Result Orientation
Solution Delivery Process
Analytical Thinking
Collaboration
Data Management
Risk Management
Test Engineering
Shift:
1st shift (United States of America)
Hours Per Week:
40
Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates.
To view the "EEO is the Law" poster, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) .
To view the "EEO is the Law" Supplement, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf) .
View the LA County Fair Chance Ordinance (https://dcba.lacounty.gov/wp-content/uploads/2024/08/FCOE-Official-Notice-Eng-Final-8.30.2024.pdf) .
Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy (“Policy”) establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment.
To view Bank of America’s Drug-free Workplace and Alcohol Policy, CLICK HERE .
This communication provides information about certain Bank of America benefits. Receipt of this document does not automatically entitle you to benefits offered by Bank of America. Every effort has been made to ensure the accuracy of this communication. However, if there are discrepancies between this communication and the official plan documents, the plan documents will always govern. Bank of America retains the discretion to interpret the terms or language used in any of its communications according to the provisions contained in the plan documents. Bank of America also reserves the right to amend or terminate any benefit plan in its sole discretion at any time for any reason.