Farmers Insurance Careers

ETL Informatica Developer

Mercer Island, Washington
Information Technology


Job Description

Requisition ID: 180007WB
  
We are Farmers! 
  
Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world. Start your career at Farmers today! 
 
Job Summary 
  
We are looking for a strong ETL Informatica Developer with 5+ years’ experience in Power Center and working in an Agile delivery model.
 
Essential Job Functions   
 
  • Work under the direction of Software Engineering Manager/Technical Lead on the successful delivery of multiple ETL related projects and processes
  • Independently manage development of ETL processes – development to delivery.
  • Interface with Business and Business Analysts to understand functional requirements.
  • Translate functional requirements into technical specifications for ETL development; develop source-to-target mappings and actively work with Development, Test and Implementation efforts
  • Review design, code and migration objects for smooth project delivery 
  • Work with Data Governance team to ensure data quality
 
Physical Actions 
 
Required job duties are essentially sedentary work consisting of occasional walking, standing and lifting and/or carrying 10 lbs. maximum, and seeing.
  
Physical Environment 
 
Required job duties are normally performed in a climate controlled office environment.
  
Education Requirements 
  
Bachelor’s degree or equivalent or specific relevant experience 
 
Experience Requirements 
  
  • 5+ years of experience in developing data integration and ETL with Informatica Power Center
  • 5+ years of experience with Informatica Power Center 10.x, Power Exchange 10.1, Information Analyst, Metadata Manager
  • Strong expertise with advanced SQL on Oracle/DB2/Microsoft SQL Server.
  • Experienced in effective management of multiple competing and frequently changing assignments and priorities.
  • Should have good understanding of data integration concepts and terminology.
  • Experienced with agile project methodologies
  • Financial Services/ Life Insurance domain background a plus.
  • Strong understanding of data warehousing basics and concepts.
  • Exposure to Data modeling – dimensional and relational modeling.
  • Strong analytical skills (able to read/write complex SQL queries to analyze data, investigate defects, validate data quality, etc.).
  • Experience in BI/DW development.
  • SQL Server 2012/2014/2016, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
  • Strong oral and written communication skills.
  • Strong documentation skills (scope, requirements, high-level design).
  • Effective time and priority management.
  • Ability to work in a collaborative team
  • Quick learner, self-starter, organized, and detail oriented.
  • Effective problem solving skills.
  • Ability to explain complex concepts/issues in simple terms.
  • Ability to identify and appropriately escalate issues/risk to management for direction.
 
Preferred Skills:
  • Experience in Life Insurance Industry.
  • Experience with SQL Server database administration is preferred
  • Experience with other reporting tools including Business Objects, Crystal Reports, Tableau
 
Farmers is an equal opportunity employer, committed to the strength of a diverse workforce. 

Schedule: Full-time

Job Posting: 09/24/2018