Bank of America is looking to develop and deliver complex data solutions to accomplish technology and business goals, requiring expertise in data integration, cleaning, transformation, and control within operational and analytical data systems.
Requirements
- Experience in SQL, PL/SQL, Oracle 12c/19c, Oracle RAC, OLTP
- Proficiency with Packages, Stored Procedures, Functions, Triggers, Views, Materialized Views, Sequences, DB Objects
- Proficiency with SQL query tuning, partitioning, performance optimization, indexing
- Proficiency with DB schema and table design, logical/physical design, normalization/denormalization
- Ability to analyze various Oracle reports like SQL trace, tkprof , tuning advisor, ADDM etc and suggest improvements
- Experience with Extract-Transform-Load ETL processes
- Experience with Source Control: BitBucket/GIT, Subversion (SVN), Perforce, or similar
Responsibilities
- Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities
- Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment
- Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements
- Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and leads triage of underlying causes
- Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking outside the box to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes
- Leads complex information technology projects to ensure on-time delivery and adherence to release processes and risk management and defines and builds data pipelines to enable data-informed decision making
- Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls
Other
- Minimum of 6 years of job related experience required .
- Experience with Agile/Iterative development and full SDLC development
- Candidate must have a strong demonstrated ability to support data analysis within large/complex operational systems and a familiarity with relational modeling.
- Must work well in a supportive and transparent team environment, while having the ability to research and resolve issues independently.
- Agile development team experience, strong configuration management skills, and ability to thrive within a collaborative team environment are also highly desired.
