Senior Batch and Database Developer
New York, NY 10017 US | Work from home flexibility TELECOMMUTE US
Job Description
Senior Batch and Database Developer
Our Function
The Investment Operations business department supports all aspects of the trade life cycle. The department is sub-divided into multiple groups: performance, trade support equity, trade support fixed income, etc. The Investment Operations Technology group is within Application Development and support this business department and lead the technology strategy to support all groups within this department.
Your responsibilities will include, but are not limited to the following:
- Responsible for translating functional design into technical specifications ensuring functionality and integration with existing systems/platforms
- Develop and maintain all documentation pertaining to a programming project that is detailed and accurate
- Perform detailed impact analysis and provide estimates for change requests across one or many complex projects
- Design, and implement software solutions that are structured and easily maintained
- Create requests and provide governance to promote code to different environments based on firm standard
- Ensure code is versioned and checked into source control system
- Provide oversight to, as well as create deployment scripts and verify correctness within integration environment
- Troubleshoot production issues, document incidents, and provide timely fixes and drive problem resolution.
- Perform creation of unit, functional, integration and performance testing and provide evidence of results.
- Bachelor Degree in Computer Science or IT related field
- 15+ years of software development experience using relational databases
- Experience building Data Warehouses / Data Marts including familiarity with i.e modelling data
- Development experience with Oracle version 12 or above
- Experience generating complex result sets using SQL including familiarity with i.e. analytic functions
- Experience optimizing/tuning SQL queries including familiarity with i.e. generating and interpreting execution plans i.e. query processing, including selecting the optimal join execution methodology
- Experience coding stored procedures in PL/SQL / T-SQL including familiarity with i.e. exception handling
- Experience in creating Autosys jobs and ETL process
- Strong analytical skills, including a thorough understanding of how to interpret business needs and translate them into application requirements
- Power BI experience a plus
- Snowflake experience a plus