Assistant Vice President; Software Engineer
| Company | Bank of America |
|---|---|
| Location | Charlotte, NC, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- Bachelor’s degree or equivalent in Engineering (any), Computer Information Systems, Management Information Systems, or related
- 5 years of progressively responsible experience in the job offered or a related IT occupation
- 5 years of experience in designing and developing solution architectures for Data warehousing systems using Oracle SQL, Informatica PowerCenter, Python Skills
- 5 years of experience in developing Complex ETL Informatica mappings, workflow, and tasks to load multiples Source Data into different tables and files
- 5 years of experience in creating and scheduling jobs in Autosys and Airflow to automate the job execution for Informatica workflow and Python based Data transfer process
- 5 years of experience in supporting System Integration Testing and User Acceptance Testing using SQL
- 5 years of experience in creating and providing the technical specification documents to production support team
- 5 years of experience in analyzing large data sets, manipulating, cleansing, and processing data using Pyspark, AirFlow and CI/CD cloud deployment.
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.
Preferred Qualifications
-
No preferred qualifications provided.