BGC Technology Team is looking for Sr. Database Developer who will design, develop, implement and support the firm's global data warehouse.
* Interact with business stakeholders to provide solutions addressing business data analytic requirements * Work with SQL and other database access tools and methods to address business or technical requirements * 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 and frameworks * Conduct PL/SQL, shell scripting and advanced SQL developments * Identify opportunities to fine-tune and optimize SQL queries/views and PL/SQL programs * Become proficient in the data model and data structures to be able to efficiently respond to business queries and requests * Provide ongoing maintenance and support of database schemas and views * Conduct root cause analysis and resolve production problems and data issues * Work within the defined software development lifecycle, following rigorous change control policies
* Demonstrated experience working on the design, implementation, and deployment of large, complex software projects. (5+ Years) * High Level of expertise with Oracle 12c, and PL/SQL programming. (5+ Years) * Familiarity with Python, Perl or other shell scripting languages. (3+ Years) * Advanced proficiency with Oracle SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and Oracle SQL Performance/Tuning * Advanced proficiency with PL/SQL Packages/Functions/Procedures programming and debugging, Oracle Collection and Object Types * Experience with Oracle Data Pump, SQL*Loader and external tables framework * Experience of working with large volumes of data * Good understanding of Oracle 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 * Plus : Expertise in full stack J2EE technologies, Servlets, Angular 2.0, Spring 4.0, HTML 5, XML, JSON, JQuery, JDBC, CSS (Bootstrap), JXLS, IText
About Bgc Partners
BGC Partners is a brokerage company servicing the wholesale financial and real estate markets.