SQL Developer

Woodland Hills CA
April 16 2018
Insurance, Securities
Functional Area:

IT - Information Technology

Estimated Travel Percentage (%): No Travel

Relocation Provided: No

American General Life Insurance Company

Your future team

Our technology teams collaborate with their worldwide colleagues and partners every day to take on the challenges of providing IT support to one of the world's leading financial services firm. We're people who believe that with the right values and hard work, anything is possible. We know that if we're at our best, that enables our customers to be their best and realize their dreams and hoped for successes. The Information Technology group provides enterprise-wide IT solutions for all of AIG's specialized disciplines. Technology provides strategic and procedural support in all of AIG's specialized disciplines, such as policy issuance, premium collection, claims handling, and administration. It enables AIG to deliver business strategies through efficient world-class IT and operations services, while ensuring the necessary IT risk management and security measures are in place.

Your contribution at AIG
As a Leader, you are respected for your deep technical expertise and/or ability to oversee programs and processes. You balance the needs of multiple stakeholders, making sound decisions using data, analysis, experience, and judgment, along with a risk mindset. Ultimately, you take ownership for key outcomes.

The primary purpose of the job is to provide Oracle design and development support for all Actuarial Information Technology projects. Job will also entail data management support activities of RIS experience studies team

The Actuarial IT team needs a strong Oracle and SQL developer with good Business Analyst background to understand RIS experience study business processes and provide technical support. Developer should be able to create efficient data models, stored procedures, packages, and other database structures in support of data processing and storage for Actuarial modeling platforms.

Role would require working closely with Actuaries, IT team and stakeholders to understand data needs, analyze issues and provide appropriate solution. The project supports the actuarial department's growing data needs, automation of data intake and analysis. We need a strong resource to bring technical solution by thoroughly understanding, analyzing, and documenting stakeholder's processes and information needs following best practices.

Successful candidates should be self-driven, able to work with minimum supervision and have extensive experience in developing Oracle PL/SQL and Microsoft SQL solution

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

Job Requirements:

The Ideal Candidate will have:

‒ Extensive experience with database development tools (Oracle, Microsoft SQL, Toad), ETL and integration technologies including Oracle ODI and Microsoft SQL

‒ 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

- Experience with Measure and ACORD a plus and LOMA.

- Experience with any ETL application such as Datastage a plus

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.

We consider qualified applicants with criminal histories, consistent with applicable law.