Senior ETL Developer

Bank of America; Plano (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Bank of America in Plano, TX is seeking a Senior ETL Developer with 10+ years of experience in ETL development, data integration, and production support. You will work on Treasury ADS applications providing L3 production support and BAU enhancements.

The role requires strong analytical skills, ability to resolve complex data issues, and collaboration with global teams to deliver scalable data solutions. This position emphasizes designing and maintaining ETL processes, ensuring data quality, and

Qualifications

• 10+ years of ETL development, data warehousing and production support.
• Strong problem-solving and communication skills.
• Experience with globally distributed teams and offshore delivery.

Responsibilities

• Provide L3 support for critical ETL applications and data pipelines.
• Analyze, troubleshoot and resolve production incidents within SLA.
• Design, develop and maintain ETL processes and data integration solutions.
• Translate business requirements into technical designs.
• Collaborate with teams to deliver scalable solutions.

Skills

ETL Design

Data Warehousing

SQL Development

Hadoop Ecosystem

Hive

Spark

HDFS

Unix/Linux

Shell Scripting

CI/CD

Education

Bachelor's degree

Tools

Oracle Exadata

Oracle DB/PL-SQL

Autosys

Job description

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
• Design, develop, and modify 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: 1st shift (United States of America) Hours Per Week: 40

Privacy Statement

https://careers.bankofamerica.com/en-us/privacy-notice

Pay Transparency

https://careers.bankofamerica.com/en-us/pay-transparency

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day. One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We’re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being. Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization. Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Partnering Locally Learn about some of the ways Bank of America is making a difference in the communities we serve. Global Impact Learn about the six areas that guide Bank of America’s efforts to help make financial lives better for customers, clients, communities and our teammates. Opportunity and Inclusion Each employee brings unique skills, background and opinions. We see opportunity and inclusion as our platform for innovation and a key component in our success. Our Values Learn about our four values that represent what we believe. Pay Transparency: https://careers.bankofamerica.com/en-us/pay-transparency