Back to search results

Analyst I - Apps Prog

Mumbai, India

Job Description:

Overview

Bank of America is one of the world’s leading financial institutions, serving individual consumers, small and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services. We are committed to attracting and retaining top talent across the globe to ensure our continued success. Along with taking care of our customers, we want to be the best place for people to work and aim at creating a work environment where all employees have the opportunity to achieve their goals.

We are a part of the Global Business Services which delivers technology and operations capabilities to Bank of America lines of business (LOB) and enterprise functions.

Our employees help our customers and clients at every stage of their financial lives, helping them connect to what matters most. This purpose defines and unites us. Every day, we are focused on delivering value, convenience, expertise and innovation for individuals, businesses and institutional investors we serve worldwide.

 * BA Continuum is a nonbank subsidiary of Bank of America, part of Global Business Services in the bank.

Process Overview

Investment & Banking Solutions Technology team is responsible for Investment Products, Card, Deposits, Consumer Vehicle Lending, Retirement, Lending, US Trust. This team provides wealth management financial solutions to individual & institutional clients and Consumer Banking products. The team delivers technology solutions through robust and scalable applications developed on various platforms such as .Net, SQL Server, Oracle, Java/J2EE, Angular JS and Mainframe. This team constitutes Application development, Testing (functional and automation), Design/Architecture and Business Analysis

Job Description

A Strong Database developer in Microsoft SQL Server who will be involved in database design, data storage, performance.  Developer will be working with several team members across location, learn existing architecture and will work on upgrading the current DB in newer version or newer Memory DB tool such as Mem SQL.  Team member should be able to work in Agile construct. Exposure to Wealth platform will be helpful.

Responsibilities

  • Understanding existing application data model.
  • Review and interpret ongoing business report requirements
  • Develop procedures and scripts as per business requirement
  • Develop, implement and optimize stored procedures and functions using T-SQL
  • Analyze existing SQL queries for performance improvements
  • Understand existing database solution and ability to implement the same on MemSQL DB.
  • Write quality unit test cases to ensure quality deliverables.
  • Review the code and suggest best standards.

    Requirements

  • Education: Any Graduate
  • Certifications If Any: NA
  • Experience Range: 4 to 6 years
  • Mandatory skills :
    • Experience in Microsoft SQL Server (T-SQL)
    • Strong hands-on experience in writing complex SQL queries and performance tuning
    • Adequate experience in SQL design standards & debugging
    • Good understanding of any In-memory/MPP/Distributed Database Server architecture
    • Experience in Autosys + Agile (Added advantage)
    • Understanding of MemSQL database architecture (Added advantage)
    • Passion to learn project domain & processes

Desired skills : Memory data stores skill such as Mem SQL

Work Timings: 12 pm – 9 pm

Job Location: Mumbai (Malad)

Learn more about this role

Full time

JR-20010217

Manages People: No

Manager:

Talent Acquisition Contact:

Referral Bonus:

Street Address

Primary Location:
Mindspace, Link Road Malad, Mumbai, 400064