Intercontinental Exchange Company Profile

Senior Database Developer at Intercontinental Exchange (Atlanta, GA)

About the Employer

Job Description

ICE is seeking a Senior Database Developer to join the ICE Clearing Technology Department in support of the ICE Clear Treasury, Risk Management, and Clearing Operations groups. This is an opportunity to work with the Clearing Enterprise Data Warehouse and Reporting solution, providing analytical capabilities to business users of our core enterprise clearing platform. As a Senior Database Developer, you will be responsible for interfacing with business users to understand their data analytic requirements, building complex views and queries, working closely with reports developers to build reports, preparing documentation, and providing production support. This position will require an individual who can work with minimal supervision on a wide range of projects interfacing with business users, development teams, and management. The ideal candidate has been successful in a lead database developer role, driving work from the concept phase to production deployment. Duties and Responsibilities 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 Ability to generate, modify and version database object scripts (DML/DDL) 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 Create and maintain up to date documentation of the data model, data flow and field level mappings Knowledge and Experience Bache lor degree or foreign equivalent in related field, or equivalent experience Minimum of 7 years experience in database developments for various transactional and/or analytical database systems Advanced proficiency with Oracle SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, materialized views, 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 working with large volumes of data Good understanding of Oracle Database Architecture Experience with Oracle development tools (TOAD, Oracle SQL Developer) and Source Control Software Advanced knowledge in scripting in Unix/Linux environment Solid understanding of relational and dimensional data models Experience with business intelligence reporting tools (SQL query, Business Objects), data integration tools (Informatica, etc.), and metadata repository processes and tools Experience with financial reporting is a plus Experience with Oracle Application Express is a plus Experience with Talend ETL is a plus Strong written and oral communications skills 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 effectively move forward on tasks even with ambiguous or changing requirements Ability to prioritize and execute tasks efficiently in a high-pressure environment Ability to work in a team-oriented, collaborative environment Ability to quickly pick up new tools and technologies Strong presentation and interpersonal skills