IT - Information Technology
Estimated Travel Percentage (%): No Travel
Relocation Provided: No
American General Life Insurance Company
The primary purpose of the job is to provide data maangement support to RIS experience Studies team. This role will be part of Actuarial Information Technology group.
The Actuarial IT team needs a strong SQL developer with good Business Analyst background to understand RIS epxerience study business processe and provide technical support. 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 Microsoft SQL and Oracle PL/SQL solution by understansing the business processes
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,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 applicaion 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.