Job Description :
Hi
Hope you are doing great.


Position : Informatica Developer with oracle
Location : chesterfield, MO
Duration 6 months
Position Overview
RGA is looking for results oriented, Senior Data Warehouse Developer to independently design, develop, test, implement, document, and support data warehouses, including ETL, database, and scheduling technologies and processes. In this senior role, the developer will apply a general understanding of the data warehouse source and target systems, and leverage a general knowledge of business intelligence and big data technologies and processes, to execute responsibilities.


Responsibilities
Creates and supports the ETL process to extract the data from source systems and place it into the data warehouse
Performs data warehouse design and testing, including data design, database architecture, metadata, and repository creation
Designs, develops, and maintains relational databases for data storage and data mining
Works with business and IT stakeholders to optimize reporting information by defining business requirements and populating the data warehouse table structure
Creates data warehouse schematics and layouts; assists with developing capacity planning
Recommends improvements and applies standards, processes, and procedures for data warehousing systems
Seeks continuous data warehouse performance improvement and ensures security of data
Creates and implements effective metrics and monitoring processes
May lead small projects with manageable risks and resource requirements
Acts as a resource and impacts the quality of work for colleagues with less experience
Performs other duties as assigned

Requirements
4+ years Data Warehouse or relevant experience
Experience in Kimball dimensional modeling
4+ years ETL, database, and scheduling experience
Demonstrated ability to quickly learn new technologies
1+ years of Data Analysis experience
Advanced ability to solve complex problems, drawing upon creativity, experience, and multiple sources of information
Advanced interpersonal skills, including the ability to build consensus
Advanced communication skills, including the ability to communicate complex information in straightforward manner
Regular and predictable attendance
Bachelor’s degree or equivalent education/ experience
Informatica Power Center & Data Validation Option
Tidal Enterprise Scheduler
Oracle SQL & PL/SQL
Vertica
Preferred:
Insurance and/or reinsurance industry knowledge
Master’s degree and/or LOMA certification
Experience as an ETL team lead
Talend
SQL Server
SQL Server Integration Services
PostgreSQL
Erwin Data Modeler


Company Overview
Reinsurance Group of America, Incorporated (NYSE: RGA) is one of the largest global providers of life reinsurance, with offices around the world. RGA delivers expert solutions in individual life reinsurance, individual living benefits reinsurance, group reinsurance, financial solutions, facultative underwriting and product development. Our mission is to enhance our clients’ prosperity by supporting their financial and risk management capabilities.