Oracle Database Developer - Actuarial
IT - Information Technology
Estimated Travel Percentage (%):
AIG Employee Services, Inc.
Oracle Database Developer - Actuarial Position Summary: The primary purpose of the job is to provide Oracle design and development support for all Actuarial Information Technology projects. The Actuarial IT team needs a strong Oracle developer to create efficient data models, stored procedures, packages, and other database structures in support of data processing and storage for Actuarial modeling platforms. The project supports the actuarial department's growing data needs, automation of data intake and analysis We need a strong resource to creatively build and support our stakeholder's data needs fully utilizing Oracle recommended best practices. This position is required as we enter a new stage of increase need for data in Actuarial projects. Successful candidates should be self-driven, able to work with minimum supervision and have extensive experience in Data Modeling, Data Warehousing, PL/SQL, ETL processing, Reporting and background in finance and/or insurance. Responsibilities Include: ‒ Analyze business requirements, propose, design and implement technical solutions ‒ Participate in development of Actuarial Data Warehouse and ETL data flow ‒ Work effectively with the Infrastructure architects and DBA teams to ensure that all approved development and deployment procedures are followed. ‒ Provide production support from development teams for existing systems, troubleshoot data and/or system issues ‒ Identify root causes and resolve data related issues ‒ Review and optimize query performance
The Ideal Candidate will have: ‒ Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies including Oracle ODI ‒ Experience developing large scale systems ‒ Experience in one or more structured programming languages (C++, C#/.Net, PL/SQL, etc.) ‒ Experience developing interfaces to Oracle or other SQL-based databases ‒ Experience working in controlled development, testing and production environments ‒ Experience in Data Modeling, Data Warehousing, PL/SQL, ETL processing ‒ Familiarity with standard development toolkits including source repositories (TFS), SQL interpreters (TOAD), IDEs (.Net), etc. ‒ Sound understanding of RDBMS ‒ Basic understanding of finance and insurance industry is a plus ‒ Strong written and oral communication skills ‒ Excellent problem-solving and quantitative skills ‒ Aptitude for debugging problems in complex, unfamiliar code ‒ Demonstrated ability to work as part of a team ‒ Solid work ethic, self-driven with the ability to work with minimal supervision
It has been and will continue to be the policy of American International Group, Inc., its subsidiaries and affiliates to be an Equal Opportunity Employer. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.
At AIG, we believe that diversity and inclusion are critical to our future and our mission - creating a foundation for a creative workplace that leads to innovation, growth, and profitability. Through a wide variety of programs and initiatives, we invest in each employee, seeking to ensure that our people are not only respected as individuals, but also truly valued for their unique perspectives