girl looking into her desktop
Back to search results

Software Engineer I A - GBS IND

Gurugram, , India;

Job Description:

Overview (Bank of America overview, BA Continuum India overview, Business 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:

Shared Technology Services (STS) is a technology group providing Application Development Shared Technology Services to the Global Business Services. STS is one of several Global Technology & Operations (GT&O) transformation initiatives aimed at simplifying and modernizing our technology and operations environment.

STS is about the people who get our technology work done. STS is about building our own fungible – or interchangeable – pools of in-house technology resources, keeping intellectual capital inside the bank. The members of this group will provide subject matter expertise on their respective technology domains.

Job Description:

The Individual will be a part of Shared Technology Services (STS-DB),  will work on Oracle PL/Sql, Oracle Exadata, Informatica, tableau and AutoSys. S/he will perform data analysis, write SQL queries including stored procedures and functions for on-demand analytics to create necessary reports. He will Monitor ETL loads on regular intervals to ensure loads have successfully completed. He will also work on packages, stored procedure, triggers and functions as per story assigned to him/her.

Responsibilities

The job primarily involves

  • Experience in Oracle PL/SQL, Oracle Exadata and other database technologies.
  • Involved in creating the mappings in order to extract the data from source to target using Informatica.
  • SQL- must be having experience on WITH clause, Analytical functions, and creating compiles Views.
  • PL/SQL- must be having experience on exception handling, cursors, cursor variables, collections, bulk dml, stored procedures, functions, triggers, and packages.
  • Must have good knowledge on data modelling, data quality and data validation.
  • Should have good knowledge on oracle performance tuning.
  • Good knowledge on using data dictionary views and oracle built in packages.
  • Good working knowledge on indexes, partitions, hints.
  • Working knowledge on UNIX and Perl Script (not administration level knowledge but must have knowledge on development side basic utilities).
  • Monitor ETL loads on regular intervals to ensure loads have successfully completed.
  • Automate manual processes to reduce human intervention.
  • Ability to work independently with minimal guidance and possesses analytical skills
  • Ability to develop strong working relationship with team members and deliver quality solutions
  • Analyze failure messages and identify root causes of issues and apply solutions.
  • Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
  • Review and analyze system specifications
  • Should analyze users stories and/use cases/requirements for validity and feasibility.
  • Will participate in application planning, daily standup & retrospective meetings
  • Flexible to work in the US overlap time zone

Requirements

  • Education: BE/ BTech or MCA or as per company standards
  • Certifications If Any: Not mandatory.
  • Experience Range: 2-6  Yrs
  • Foundational Skill: 
    • Experience in Oracle PL/SQL, Oracle Exadata and other database technologies.
    • Involved in creating the mappings in order to extract the data from source to target using Informatica.
    • SQL- must be having experience on WITH clause, Analytical functions, and creating compiles Views.
    • PL/SQL- must be having experience on exception handling, cursors, cursor variables, collections, bulk dml, stored procedures, functions, triggers, and packages.
    • Must have good knowledge on data modelling, data quality and data validation.
    • Strong Linux and shell scripting
    • Strong knowledge of data manipulation using stored procedures
    • Use of Software Control Management tools
    • Team player, self-motivated
    • Provide technology solutions, through application designs and development
    • Excellent communication, analysis and problem solving skills
    • Quick to learn, self-motivated and enthusiastic
    • Able to work well in a highly motivated environment
  • Desired skills:
    • Knowledge on Agile
    • Python, Tableau, UNIX and Perl Script, Oracle Exadata.
    • Strong technical knowledge on writing complex SQL Queries and stored Procedures
  • Work Timings: General Shift 11:30 AM to 08:30pm
  • Job Location: Mumbai/Chennai, GGN

Job Band:

H7

Shift: 

Hours Per Week:

45

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Overview (Bank of America overview, BA Continuum India overview, Business 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:

Shared Technology Services (STS) is a technology group providing Application Development Shared Technology Services to the Global Business Services. STS is one of several Global Technology & Operations (GT&O) transformation initiatives aimed at simplifying and modernizing our technology and operations environment.

STS is about the people who get our technology work done. STS is about building our own fungible – or interchangeable – pools of in-house technology resources, keeping intellectual capital inside the bank. The members of this group will provide subject matter expertise on their respective technology domains.

Job Description:

The Individual will be a part of Shared Technology Services (STS-DB),  will work on Oracle PL/Sql, Oracle Exadata, Informatica, tableau and AutoSys. S/he will perform data analysis, write SQL queries including stored procedures and functions for on-demand analytics to create necessary reports. He will Monitor ETL loads on regular intervals to ensure loads have successfully completed. He will also work on packages, stored procedure, triggers and functions as per story assigned to him/her.

Responsibilities

The job primarily involves

  • Experience in Oracle PL/SQL, Oracle Exadata and other database technologies.
  • Involved in creating the mappings in order to extract the data from source to target using Informatica.
  • SQL- must be having experience on WITH clause, Analytical functions, and creating compiles Views.
  • PL/SQL- must be having experience on exception handling, cursors, cursor variables, collections, bulk dml, stored procedures, functions, triggers, and packages.
  • Must have good knowledge on data modelling, data quality and data validation.
  • Should have good knowledge on oracle performance tuning.
  • Good knowledge on using data dictionary views and oracle built in packages.
  • Good working knowledge on indexes, partitions, hints.
  • Working knowledge on UNIX and Perl Script (not administration level knowledge but must have knowledge on development side basic utilities).
  • Monitor ETL loads on regular intervals to ensure loads have successfully completed.
  • Automate manual processes to reduce human intervention.
  • Ability to work independently with minimal guidance and possesses analytical skills
  • Ability to develop strong working relationship with team members and deliver quality solutions
  • Analyze failure messages and identify root causes of issues and apply solutions.
  • Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
  • Review and analyze system specifications
  • Should analyze users stories and/use cases/requirements for validity and feasibility.
  • Will participate in application planning, daily standup & retrospective meetings
  • Flexible to work in the US overlap time zone

Requirements

  • Education: BE/ BTech or MCA or as per company standards
  • Certifications If Any: Not mandatory.
  • Experience Range: 2-6  Yrs
  • Foundational Skill: 
    • Experience in Oracle PL/SQL, Oracle Exadata and other database technologies.
    • Involved in creating the mappings in order to extract the data from source to target using Informatica.
    • SQL- must be having experience on WITH clause, Analytical functions, and creating compiles Views.
    • PL/SQL- must be having experience on exception handling, cursors, cursor variables, collections, bulk dml, stored procedures, functions, triggers, and packages.
    • Must have good knowledge on data modelling, data quality and data validation.
    • Strong Linux and shell scripting
    • Strong knowledge of data manipulation using stored procedures
    • Use of Software Control Management tools
    • Team player, self-motivated
    • Provide technology solutions, through application designs and development
    • Excellent communication, analysis and problem solving skills
    • Quick to learn, self-motivated and enthusiastic
    • Able to work well in a highly motivated environment
  • Desired skills:
    • Knowledge on Agile
    • Python, Tableau, UNIX and Perl Script, Oracle Exadata.
    • Strong technical knowledge on writing complex SQL Queries and stored Procedures
  • Work Timings: General Shift 11:30 AM to 08:30pm
  • Job Location: Mumbai/Chennai

Learn more about this role

Full time

JR-21040558

Band: H7

Manages People:

Manager:

Talent Acquisition Contact:

Anjali Mishra

Referral Bonus:

0