
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. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.
Being a Great Place to Work is core to how we drive Responsible Growth. This includes our commitment to being a diverse and inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve.
At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!
RESPONSIBILITIES:
Follow agile software development methodology to actively participate in tech reviews and design document deliverables.
Develop and deliver complex requirements to accomplish business goals.
Ensure that software is developed to meet functional, non-functional and compliance requirements.
Code solutions, unit testing, and ensure the solution can be integrated successfully into the overall application / system with clear, robust, and well-tested interfaces.
Design data model and database schema, Tables, Views, Stored procedures for Core database in the Oracle Exadata database platform.
Design and develop solution architectures for Data warehousing systems using Oracle SQL, Informatica PowerCenter, Python Skills to effectively manage, transform, and analyze data.
Develop Complex ETL Informatica mappings, workflow, and tasks to load multiples Source Data into different tables and files.
Creating and scheduling jobs in Autosys and Airflow to automate the job execution for Informatica workflow and Python based Data transfer process.
Support System Integration Testing and User Acceptance Testing using SQL to ensure issue resolution and prevention tasks when defects are identified.
Create and provide the technical specification documents to production support team to support the applications.
Analyze large data sets, manipulate, cleanse, and process data using Pyspark, AirFlow and CI/CD cloud deployment.
Remote work may be permitted within a commutable distance from the worksite.
REQUIRED SKILLS & EXPERIENCE:
Bachelor's degree or equivalent in Engineering (any), Computer Information Systems, Management Information Systems, or related: and
5 years of progressively responsible experience in the job offered or a related IT occupation.
Must include 5 years of experience in each of the following:
Designing and developing solution architectures for Data warehousing systems using Oracle SQL, Informatica PowerCenter, Python Skills to effectively manage, transform, and analyze data;
Developing Complex ETL Informatica mappings, workflow, and tasks to load multiples Source Data into different tables and files;
Creating and scheduling jobs in Autosys and Airflow to automate the job execution for Informatica workflow and Python based Data transfer process;
Supporting System Integration Testing and User Acceptance Testing using SQL to ensure issue resolution and prevention tasks when defects are identified;
Creating and providing the technical specification documents to production support team to support the applications; and,
Analyzing large data sets, manipulating, cleansing, and processing data using Pyspark, AirFlow and CI/CD cloud deployment.
If interested apply online at www.bankofamerica.com/careers or email your resume to bofajobs@bofa.com and reference the job title of the role and requisition number.
EMPLOYER: Bank of America N.A.
Shift:
1st shift (United States of America)Hours Per Week:
40Learn more about this role