girl looking into her desktop
Back to search results

ETL Informatica Application Developer

Atlanta, Georgia;

Job Description:

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.

The Developer work side by side with business partners to ensure expected quality software is built to serve our customers and clients.

They will be responsible for understanding the business requirements, build/enhance application components to support the requirement, enabling testing organization to certify the application, Support technology infrastructure team in production deployment and transitioning to support team.

The Developer is expected to learn the business and technical components of an application and work with their peers to follow enterprise software development methodologies.

Grow your career in our dynamic and fast paced environment of diverse software platforms and challenging projects that shape the future of the banking industry. Will not have direct reports.

Routine accountability is for technical knowledge and capabilities.

Responsibilities:

This role is for an Application developer to design, develop, maintain and test Data warehouse applications collaborating with the development team, testing team and business partners to ensure successful delivery and implementation of application Requirements.

Should have hands on experience in designing, developing and implementing ETL projects for data warehouses.

  • Responsibilities will include (but are not limited to) the following, and these will be evolving based on business needs:

  • Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mappings

  • Responsible for build of data mappings, sessions, and workflows to meet requirements (Informatica 9.x or above)

  • Responsible for development of job schedules that integrate with upstream and downstream systems (Autosys jobs)

  • Responsible for coordination of offshore development to assist in build efforts, including meeting with the offshore team on a daily basis to discuss ongoing work

  • Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy and integrity

  • Accountable for on-time delivery of all documentation, design, build, testing, and deployment according to the Work Breakdown Structures

  • Work with the production support teams as required to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities.

  • Must have impeccable written and oral communication skills down to the mapping documentation level

  • Directly working with users/ LOB to understand their needs and address their clarifications

  • Should be independent and quick learner.

Required Skills*

  • Requires 7-10 years of development experience in Informatica / ETL Tools

  • Minimum of 5+ years with Informatica Power Center 9.x or above designing, developing, testing, and debugging.

  • Minimum of 5+ years of development experience in Oracle, SQL Server, or another industry accepted database platform.

  • Minimum of 2+ years in Data Warehouse / Data Mart / Business Intelligence delivery

  • Minimum of 2+ years of Linux / shell scripting complementary with Informatica

  • Minimum of 2+ years of experience in job scheduling using Autosys or another industry accepted scheduling tool

  • Minimum of 3+ years in Data Analysis

  • Hands on Informatica Components (Designer, Monitor, and Repository Manager& Workflow Manager) using Informatica PowerCenter 9.x.

  • Experience in Creating Low level and high level Design Artifacts.

  • Proven experience in designing and building integrations supporting standard data warehousing data models star schema, snow flake and different Normalization Forms.

  • Ability to present technical concepts to senior level business stakeholders.

  • Ability to provide end to end technical guidance on the software development life cycle (requirements through implementation).

  • Analytical and problem-solving skills.

  • Impeccable Communication skills – verbal and written.

  • Should be a self-motivated worker.

  • Excellent interpersonal skills, positive attitude, team-player.

  • Willingness to learn and adapt to changes.

  • Experience in working in a global technology development model.

  • Effectively deal with multiple deadline-driven, customer-sensitive projects and tasks.

  • Strong time management and task prioritization    

Desired Skills

  • Experience in Banking and Finance domain.

  • Functional Knowledge of Hadoop Ecosystem

General Job Description:

Responsible for developing and delivering complex software requirements to accomplish business goals.

Ensures that software is developed to meet functional, non-functional, and compliance requirements.

Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces.

Familiar with development and testing practices of the bank.

Contributes to story refinement/defining requirements.

Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle.

Performs spike/proof of concept as necessary to mitigate risk or implement new ideas.

Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements.

Utilizes multiple architectural components (across data, application, business) in design and development of client requirements.

Assists team with resolving technical complexities involved in realizing story work.

Contributes to existing test suites (integration, regression, performance);

Analyzes test reports, identifies any test issues/errors;

Triages the underlying cause.

Documents and communicates required information for deployment, maintenance, support, and business functionality.

Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

Individual contributor.

*Candidates requiring current or future visa sponsorship will not be considered for this position**

**This role is not open to telecommuting or remote arrangements**

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

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.

The Developer work side by side with business partners to ensure expected quality software is built to serve our customers and clients.

They will be responsible for understanding the business requirements, build/enhance application components to support the requirement, enabling testing organization to certify the application, Support technology infrastructure team in production deployment and transitioning to support team.

The Developer is expected to learn the business and technical components of an application and work with their peers to follow enterprise software development methodologies.

Grow your career in our dynamic and fast paced environment of diverse software platforms and challenging projects that shape the future of the banking industry. Will not have direct reports.

Routine accountability is for technical knowledge and capabilities.

Responsibilities:

This role is for an Application developer to design, develop, maintain and test Data warehouse applications collaborating with the development team, testing team and business partners to ensure successful delivery and implementation of application Requirements.

Should have hands on experience in designing, developing and implementing ETL projects for data warehouses.

  • Responsibilities will include (but are not limited to) the following, and these will be evolving based on business needs:

  • Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mappings

  • Responsible for build of data mappings, sessions, and workflows to meet requirements (Informatica 9.x or above)

  • Responsible for development of job schedules that integrate with upstream and downstream systems (Autosys jobs)

  • Responsible for coordination of offshore development to assist in build efforts, including meeting with the offshore team on a daily basis to discuss ongoing work

  • Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy and integrity

  • Accountable for on-time delivery of all documentation, design, build, testing, and deployment according to the Work Breakdown Structures

  • Work with the production support teams as required to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities.

  • Must have impeccable written and oral communication skills down to the mapping documentation level

  • Directly working with users/ LOB to understand their needs and address their clarifications

  • Should be independent and quick learner.

Required Skills*

  • Requires 7-10 years of development experience in Informatica / ETL Tools

  • Minimum of 5+ years with Informatica Power Center 9.x or above designing, developing, testing, and debugging.

  • Minimum of 5+ years of development experience in Oracle, SQL Server, or another industry accepted database platform.

  • Minimum of 2+ years in Data Warehouse / Data Mart / Business Intelligence delivery

  • Minimum of 2+ years of Linux / shell scripting complementary with Informatica

  • Minimum of 2+ years of experience in job scheduling using Autosys or another industry accepted scheduling tool

  • Minimum of 3+ years in Data Analysis

  • Hands on Informatica Components (Designer, Monitor, and Repository Manager& Workflow Manager) using Informatica PowerCenter 9.x.

  • Experience in Creating Low level and high level Design Artifacts.

  • Proven experience in designing and building integrations supporting standard data warehousing data models star schema, snow flake and different Normalization Forms.

  • Ability to present technical concepts to senior level business stakeholders.

  • Ability to provide end to end technical guidance on the software development life cycle (requirements through implementation).

  • Analytical and problem-solving skills.

  • Impeccable Communication skills – verbal and written.

  • Should be a self-motivated worker.

  • Excellent interpersonal skills, positive attitude, team-player.

  • Willingness to learn and adapt to changes.

  • Experience in working in a global technology development model.

  • Effectively deal with multiple deadline-driven, customer-sensitive projects and tasks.

  • Strong time management and task prioritization    

Desired Skills

  • Experience in Banking and Finance domain.

  • Functional Knowledge of Hadoop Ecosystem

General Job Description:

Responsible for developing and delivering complex software requirements to accomplish business goals.

Ensures that software is developed to meet functional, non-functional, and compliance requirements.

Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces.

Familiar with development and testing practices of the bank.

Contributes to story refinement/defining requirements.

Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle.

Performs spike/proof of concept as necessary to mitigate risk or implement new ideas.

Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements.

Utilizes multiple architectural components (across data, application, business) in design and development of client requirements.

Assists team with resolving technical complexities involved in realizing story work.

Contributes to existing test suites (integration, regression, performance);

Analyzes test reports, identifies any test issues/errors;

Triages the underlying cause.

Documents and communicates required information for deployment, maintenance, support, and business functionality.

Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

Individual contributor.

*Candidates requiring current or future visa sponsorship will not be considered for this position**

**This role is not open to telecommuting or remote arrangements**

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21072675

Band: H5

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Nicole Sanchez

Referral Bonus:

0