Vacancy expired!
Job Description:
Who We Look ForBank of America's associates are innovators and problem-solvers. We look for creative collaborators who evolve, adapt to change and thrive in a fast-paced global environment. The Horizontal Data team within Finance Technology consists of extremely talented engineers, who develop industry leading financial management platforms that provide data solutions supporting regulatory reporting globally.We are looking for looking for a talented and highly motivated software engineer with extract, transform and load (ETL) and data warehousing experience using Informatica PowerCenter and Oracle.The ideal candidate will also be well versed in the agile software development lifecycle (SDLC) process, and be proficient in Python programming.Role OverviewEnterprise Finance Technology's Horizontal Data team is looking for motivated new talent to fill the need for an extract, transform and load (ETL) engineer. This role will develop, enhance, modify, and maintain ETL/Data warehouse applications supporting the Global Liquidity Management line of business.- Deliver software solutions along the complete software development lifecycle through requirements, design, develop, test, debug, release and support.
- Work in a team environment employing the agile software development methodology.
- Work closely with business partners in defining requirements in support of Corporate Treasury functions and implement in the prescribed technologies.
- Perform data extraction from heterogeneous data sources, data transformation / cleansing and database loading using the Informatica PowerCenter (10.x) toolset.
- Optimize data throughput by leveraging push down optimization, bulk loading and/or session partitioning.
- Optimize database performance by employing such tools as table partitioning / sub-partitioning, hash techniques, indexes, statistics, etc.
- Build and maintain UNIX shell scripts supporting ETL pre- and post- processing including trigger file interrogation, data file manipulation and file transfer.
- Developing ETL workflows using Informatica PowerCenter (10.x)
- Writing comlplex SQLs in support of ETL operations using ANSI Compliant SQL
- Developing scripts in support of ETL operations using UNIX shell, bash, python, perl, etc.
- Creating and altering Oracle database objects such as tabes/views, stored procedures, functions
- Data Modeling (Star/Snowflake shemas, SCD Type 1, Type 2)
- Expert knowledge in Oracle Exadata 12.1 or higher
- Experience with web services development and REST interfaces
- Proficiency with python programing
- Analytical skills to perform technical and functional analysis with strong communication skills
Vacancy expired!