Senior ETL Developer

Job Description:

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates’ physical, emotional, and financial wellness through affordable, competitive and flexible benefits.

We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve.

Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

This job is responsible for developing and delivering complex requirements to accomplish business goals. Key responsibilities of the job include ensuring that software is developed to meet functional, non-functional and compliance requirements, and solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Job expectations include a strong knowledge of development and testing practices common to the industry and design and architectural patterns.

We are seeking a Senior ETL Developer with 10+ years of experience in ETL development, data integration, and production support. This role will support Treasury ADS applications by providing L3 production support, delivering BAU enhancements, resolving complex data issues, and ensuring the stability, availability, and performance of critical data platforms.

The ideal candidate will possess strong analytical and troubleshooting skills, be capable of making quick decisions during production incidents, and work effectively with business, architecture, development, QA, and support teams in a global delivery environment.

Responsibilities:

• Provide L3 support for critical production ETL applications and data pipelines
• Analyze, troubleshoot, and resolve production incidents within SLA commitments
• Perform root cause analysis and implement preventive solutions
• Design, develop, and maintain ETL processes and data integration solutions
• Translate business requirements into high-level and detailed technical designs
• Collaborate with Information Architecture, Business Analysts, and development teams to deliver scalable solutions
• Drive BAU enhancements, defect remediation, and production support activities
• Mentor junior developers and provide guidance to offshore teams
• Support audit, compliance, data quality, and governance initiatives
• Participate in code reviews and enforce development standards and best practices
• Coordinate with L1/L2 support, QA, infrastructure, and upstream/downstream partners
• Identify opportunities to improve application performance, reliability, and operational efficiency
• Codes solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements
• Designs, develops, and modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained
• Mentors other software engineers and coach team on Continuous Integration and Continuous Development (CI-CD) practices and automating tool stack
• Executes story refinement, definition of requirements, and estimating work necessary to realize a story through the delivery lifecycle
• Performs spike/proof of concept as necessary to mitigate risk or implement new ideas
• Automates manual release activities
• Designs, develops, and maintains automated test suites (integration, regression, performance

Required Qualifications:

• 10+ years of experience in ETL development, data warehousing, and production support
• Strong problem-solving, analytical, and communication skills
• Ability to manage multiple priorities and deliver in a fast-paced environment
• Experience working with globally distributed teams and offshore delivery models
• Design, develop, enhance, and maintain ETL processes and data integration solutions
• Participate in requirement analysis, solution design, development, testing, and implementation activities
• Develop high-level and detailed technical designs to address business and technical requirements
• Support multiple projects and enhancement requests concurrently while ensuring quality delivery
• Support data quality initiatives and ensure data integrity across processing systems
• Participate in audit reviews and compliance-related activities
• Assist in implementing controls, monitoring, and validation processes
• Ensure adherence to enterprise development, governance, and operational policies

Required Technical Skills:

Primary Skills

• Informatica PowerCenter
• ETL Design & Development
• Data Warehousing
• SQL Development & Performance Tuning

Secondary Skills

• Hadoop Ecosystem
• Hive
• Spark
• HDFS

Database & Development Skills

• Oracle Exadata
• Oracle Database / PL-SQL
• UNIX/Linux Shell Scripting
• Autosys

Production Support Skills

• Incident Management
• Root Cause Analysis (RCA)
• Application Monitoring
• Release & Change Management

Desired Qualifications:

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field
• Banking, Treasury, Finance, or Regulatory Reporting domain experience
• Strong understanding of end-to-end data processing, data models, and data distribution frameworks
• Experience with Data Quality and Data Governance initiatives
• Exposure to Agile development methodologies
• Experience mentoring junior team members and leading technical discussions
• Knowledge of CI/CD tools and operational best practices

Skills:

• Application Development
• Automation
• Influence
• Solution Design
• Technical Strategy Development
• Architecture
• Business Acumen
• DevOps Practices
• Result Orientation
• Solution Delivery Process
• Analytical Thinking
• Collaboration
• Data Management
• Risk Management
• Test Engineering

Shift:

Hours Per Week: