Responsibilities




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.