Responsibilities:
Interact with business stakeholders to provide solutions that address business data analytics requirements
Work with SQL and other database access tools and methods to meet business or technical needs
Design, implement, and support data‑movement solutions across multiple platforms and data sources (database tables/views and external files) using custom code and ETL tools/frameworks
Conduct shell scripting and advanced SQL development
Identify opportunities to fine‑tune and optimize SQL queries and views
Become proficient in the data model and data structures to efficiently respond to business queries and requests
Provide ongoing maintenance and support for database schemas and views
Conduct root‑cause analysis and resolve production problems and data issues
Work within the defined software development lifecycle, following established change‑control policies
- Demonstrated experience working on the design, implementation, and deployment of large, complex software projects.
- High Level of expertise with Oracle Database, PL/SQL programming and ASE Sybase,.
- Familiarity with Python, Perl or other shell scripting languages.
- Advanced proficiency with SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and SQL Performance/Tuning
- Advanced proficiency with Packages/Functions/Procedures programming and debugging.
- Financial Industry Experience
- Experience of working with large volumes of data
- Good understanding of Database Architecture
- Solid understanding of relational and dimensional data models
- Experience with business intelligence reporting tools, data integration tools , and metadata repository processes and tools
- Full Software Development Lifecycle, including requirements identification, design, and task estimation.
- Ability to understand sophisticated mathematical and financial concepts
- Experience working on financial data model and orders/trade Flows
- Self-starter with proven ability and initiative to learn and research new concepts, ideas, and technologies quickly
- Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills
- Ability to take responsibility and work independently in a high-pressure, time critical environment.
Skills Required
- Design, implementation, and deployment of large, complex software projects
- High level of expertise with Oracle Database
- PL/SQL programming
- ASE Sybase
- Familiarity with Python, Perl or other shell scripting languages
- Advanced proficiency with SQL (complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions)
- SQL performance tuning and optimization
- Advanced proficiency with packages/functions/procedures programming and debugging
- Financial industry experience
- Experience working with large volumes of data
- Good understanding of database architecture
- Solid understanding of relational and dimensional data models
- Experience with business intelligence reporting tools, data integration tools, and metadata repository processes/tools
- Full software development lifecycle experience (requirements, design, estimation)
- Ability to understand sophisticated mathematical and financial concepts
- Experience with financial data models and orders/trade flows
- Self-starter with strong research and learning initiative
- Strong analytical, organizational, and problem solving skills
- Ability to work independently in a high-pressure, time-critical environment
