Avp- Cnslt-apps Prog

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**

The position will require deep collaboration with internal team members and some stakeholders outside of the core team. Proven experience coordinating multiple data integration projects/assignments simultaneously under mínimal supervision and completing assigned tasks accurately and on a timely basis. Must demonstrate strong attention to detail with excellent organization skills. This role will primarily support the Automation team for Corporate Audit.

**Responsibilities**:

- Develop, test, debug, migrate, document and help operationalize ETL codes by leveraging industry best practices and ensure adherence to internally defined SDLC practices.
- Work closely and collaborate with internal team members and some stakeholders outside of the core team in implementing solutions.
- Develop codes across various platforms like informatica power center, Informatica data quality tools and Alteryx.
- Create data profiles, write scripts, and develop workflows to support the data quality program.
- Will be creating indexes, data models etc and other features of ETL tools that help structure the data based on the business needs.
- Develop Linux/Unix shell scripts to support automation.
- Work on Hadoop (Hive), SQL server and oracle platforms on a regular basis.
- Write code for enhancing existing programs or developing new programs.
- Review code developed by other Developers.
- Provide input and drive programming standards.
- Write detailed technical specifications for subsystems. Identify integration points.
- Do production support and report on code errors, missing elements found in system and functional requirements and explain impacts to team members.
**Requirements**:

- Education: Graduate
- Certifications : NA
- Experience Range : 10 to 12 years
- ** Foundational Skills**:5+ years of progressive experience in using data integration/ETL tools like Informatica (Version 10 or greater) and Alteryx.
- Should have Knowledge of setting up, configuring, and maintaining ETL processes from Linux.
- 5+ years of experience with Linux/power shell scripting is required.
- Experience working with relational data sources (i.e., SQL Server, Teradata, Oracle), Big Data sources (i.e., Hive, Hadoop), and unstructured data sources.Should have Hands on experience in Big data and Hadoop technologies
- At least 3-5 years relevant experience with data analytics, with demonstrated experience and proficiency in the use of data analytics tools.
- Well-versed in writing queries in an efficient and optimized manner
- Excellent command over developing, maintaining and scheduling ETL jobs
- Knowledge of importing data from external sources in an efficient manner (use of multiple connection types)
- Experience writing SQL queries required
- Proven experience coordinating multiple projects/assignments simultaneously under mínimal supervision and completing assigned tasks accurately and on a timely basis.
- Fluency in written and spoken English.
- Informatica Power center, Informatica data quality tool, Hadoop, SQL Server, Oracle and Unix/PowerShell scripting
- ** Desired skills**:

- Strong communication, analytical and interpersonal skills.
- Proactive in nature, assertive, inquisitive, analytical, has excellent attention to details.
- Ability to develop a data-driven approach during audits.
- Familiar with all informatica suite of tools, Python, PowerShell scripting and Unix Scripting language.

Work Location : GGN

Work Timings: 11am to 8pm

**Job Band**:
H5

**Shift**:
**Hours Per Week**:
45

**Weekly Schedule**:
**Referral Bonus Amount**:
0