Senior ETL Developer

Bank of America is guided by a common purpose to help make financial lives better through the power of every connection. The company emphasizes responsible growth, an inclusive workplace, and flexible benefits that support teammates’ physical, emotional, and financial wellness. This role is responsible for developing and delivering complex requirements to accomplish business goals, ensuring software meets functional, non‑functional, and compliance requirements while being maintainable, easy to integrate, and testable.

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
• Code solutions and unit test to deliver a requirement/story per defined acceptance criteria and compliance requirements
• Design, develop, and modify architecture components, application interfaces, and solution enablers while maintaining principal architecture integrity
• Mentor other software engineers and coach the team on CI‑CD practices and automating the tool stack
• Execute story refinement, define requirements, and estimate work necessary to realize a story through the delivery lifecycle
• Perform spikes/proofs of concept as needed to mitigate risk or implement new ideas
• Automate manual release activities
• Design, develop, and maintain 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
• Production Support Skills
  • Autosys
  • 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

Schedule

• Shift: 1st shift (United States of America)
• Hours per week: 40