Currently, we are seeking a talented SQL Developer to join the Life Insurance Division in Aliso Viejo. The Life Insurance Division works with financial and insurance professionals to give families and businesses the life insurance coverage needed to help meet important financial protection, wealth accumulation, and wealth preservation goals.
The SQL developer position will be a member of a highly technical team and will be responsible for the design, development, delivery and support of SQL solutions within the organization. The applicant must have a strong working knowledge of SQL Server 2012+ databases. This includes developing complex queries, performance tuning, optimization and developing complex stored procedures. The candidate must have strong written and verbal communication skills and the ability to explain logic behind their analysis/ideas in a clear and concise manner. This team will participate in a Salesforce transformation and implementation, moving to an AWS Cloud environment and data consolidation across the enterprise. A thirst and curiosity for learning innovative technologies is important and even better if complimented with a can-do attitude.
Understand architecture behind existing ETL solutions (in SSIS and PowerCenter) and provide support, improvements and performance tuning where necessary.
Participate in Analysis, design, development, deployment and testing of Data warehousing systems on OLAP and OLTP environment and implementation of Database Management Systems
Database Modeling/Designing using ERStudio to design Conceptual/Logical/Physical Modeling, Forward/Reverse engineering and ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.
Implementation of Data Warehousing, Data Marts, Star and Snow Flake Schema Modeling, Dimensional Modeling on OLTP and OLAP concepts
Ability to manage multiple projects with competing demands and the ability to adapt and change.
Prepares design documentation, mock-ups, and prototypes
Participates in code reviews
FACTORS FOR SUCCESS:
A skilled technician who can work with both business and technology partners. 5+ years in Information Technology industry experience including:
Three plus years of current, hands on database development Skills (particularly implementing SQL Server 2012+ technologies)
Exceptional skills in development of complex stored procedures and advanced SQL techniques to optimize system performance and generate multiple types of outputs: XML, Pivoted results, Data Sets
Understand normalized and star-schema (dimensional) physical models and logical modeling concepts
Extensive programming experience in T-SQL, tuning and optimization
Extensive experience determining, developing, testing, and implementing system requirements and specifications
Ability to communicate with a wide range of audiences including management, development, and operational units
Ability to develop technical documentation and executive summaries describing technical design and architectural concepts
Self-Motivated and quick learner
Strong analytical and technical design skills
ADDITIONAL EXPERIENCE IS A PLUS BUT NOT REQUIRED:
Hands on .Net development using Visual Studio 2012 or higher
Familiarity working with Database Source Code management with TFS
Familiarity working with Automated Database Deployments using TFS Release Manager
Experience with Informatica PowerCenter v9.6+ including installation and upgrade
Knowledge with QlikView to create dashboards and visualize data
Knowledge with ERStudio to manage ER Diagrams