Bank of America Sr Database Developer - Open to Netezza, Teradata, Oracle or SQL Server in Plano, Texas

Job Description:

Summary

  • Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions.

  • These application program solutions may involve diverse development platforms, software, hardware, technologies and tools.

  • Participates in the design, development and implementation of complex applications, often using new technologies.

  • May provide technical direction and system architecture for individual initiatives.

  • Serves as a fully seasoned/proficient technical resource.

  • Will not have direct reports but may lead projects and direct activities of a team related to special initiatives or operations.

  • May have responsibility for a project and project budget.

  • May collaborate with external programmers to coordinate delivery of software application.

  • Routine accountability is for technical knowledge and capabilities.

  • Works under minimal supervision, with general guidance from more seasoned consultants.

  • Typically requires 5-7 years of experience.

Job Description

  • The candidate is expected to work independently to source the wholesale loans data from various upstream systems, consolidate them and generate the risk numbers.

  • The candidate should be able to determine if the data received from the upstream systems are of good quality based on the rules and data quality validations defined and in case of any issues with the data quality analyze and come up with a preliminary summary of the root cause / issue.

  • The candidate is expected to liaise with the business analysts, risk managers and other technology delivery manager.

  • Considering the portfolio of products in review, the candidate should have strong domain knowledge in the field of Risk Management and various loan products in the Wholesale Banking domain.

  • He / She should have 6-8 years of experience in handling batch processing systems that processes data in the volume of 100-500 GB during the monthly cycle.

Primary Responsibilities:

  • Have a good understanding of the E2E process of the application

  • Have a good understanding of all aspects of the application like Upstream source of records, DB, ETL, ELT, Batch and Distribution layers.

  • Work with the Business Analysts to understand the enhancements / changes being propagated in a particular release cycle, design and work on the coding & unit testing tasks

  • Work with the QA team during the SIT phase and support the SIT

  • Work with Platform Support team during UAT phase

  • Identify improvement areas within the application and work with the respective component teams to implement the same

  • Be a good team player

  • Flexibility in adapting to team requirements

  • Ensuring adherence to defined process & quality standards, best practices

  • Ensuring high quality levels in all deliverables

  • Adhere to team’s governing principles and policies

  • Participate in mandatory training and cross functions across team

  • Demonstrate enthusiasm and zeal to acquire domain knowledge

  • Participate and contribute to Team/Project Reviews

  • Actively involved in Process improvements and automations.

Job Requirements

  • Excellent knowledge of Database & Datawarehouse Concepts

  • 6+ years of experience in one or more of the following databases – Netezza, Teradata, Oracle, SQL Server

  • 6+ years of experience in UNIX & Shell Scripting

  • 3+ years of experience in any job scheduling tools like Autosys

  • Ability to troubleshoot issues and perform RCA at a short interval

  • Ability to think out of box and provide innovative solutions

  • Ability to work independently and take up E2E ownership of tasks

  • Strong analytical and problem solving skills

  • Good verbal and written communication skills

Desired Skills

  • 1+ years of experience in Hadoop ecosystem.

  • 2+ years of experience in Banking or financial services domain.

Posting Date : 10/12/2017

Location :

Plano, TX, BUILDING A, 7105 CORPORATE DR,

  • United States

Travel : No

Full / Part-time : Full time

Hours Per Week : 40

Shift : 1st shift

Assistance for Applicants with Disabilities

Bank of America is committed to ensuring that our online application process provides an equal employment opportunity to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to submit an application, please visit the Applicants with Disabilities page at http://careers.bankofamerica.com/us/applicants-with-disabilities .

Diversity & Inclusion

At Bank of America, our commitment to diversity and inclusion is helping us to create not only a great place to work, but also an environment where our employees, our customers and our communities around the world can reach their goals and connect with each other. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Frequently Asked Questions

Need to know how to apply online, view a list of your submitted job applications or reset your password? Visit our FAQ at http://careers.bankofamerica.com/us/faq section for answers to these questions and more.