Bank Of America Software Engineer III 

United States, Georgia, Atlanta 

91689386

Job Description:

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.

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

1st shift (United States of America)