Job Type
Job Details
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!
RESPONSIBILITIES:
Design and develop solutions for complex requirements in areas of Business Intelligence and Data Warehousing to accomplish business goals.
Code solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
Design/develop/modify architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained.
Design/develop/maintain automated test suites (integration, regression, performance).
Extract the data from Legacy system and provide the data in new environment.
Use Informatica ETL tool to implement business requirements and load into Oracle for Reporting on a Unix environment system.
Use Hadoop infrastructure to enable processing of large sets of data using Spark, Map Reduce, Hive.
Build framework with spark to perform transformations.
Design and develop end to end ETL and BI solutions by sourcing data from various data feeds.
Use SQOOP export/import to HIVE tables and then load them in Oracle to perform data manipulation and create reports for users.
Process and manipulate data into HDFS using Spark by designing optimal solutions for faster processing.
Use SQL ETL to develop Data Warehouse application in RDBMS.
Use Linux and Unix shell scripting to manage and maintain production environments.
Create ETL flows using Informatica PowerCenter 9.5.2 for new tables and modification in the rule for old tables in DW/DM according to the requirement provided.
Remote work may be permitted within a commutable distance from the worksite.
REQUIREMENTS:
Bachelor’s degree or equivalent in Engineering (any), Computer Science, 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 end to end ETL and BI solutions by sourcing data from various data feeds;
Using SQOOP export/import to HIVE tables and then loading them in Oracle to perform data manipulation and create reports for users;
Processing and manipulating data into HDFS using Spark by designing optimal solutions for faster processing;
Using SQL ETL to develop Data Warehouse application in RDBMS;
Using Linux and Unix shell scripting to manage and maintain production environments; and,
Creating ETL flows using Informatica PowerCenter 9.5.2 for new tables and modification in the rule for old tables in DW/DM according to the requirement provided.
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:
40Our Company “What would you like the power to do?” At Bank of America, we ask this question every day of all those we serve. It is at the core of... Read more