Junior ETL Developer

company banner
Farmers Insurance
Analytical Skills, Business Requirements, Database, Data Modeling, DataStage, DB2, Developer, Development, ERwin, Informatica, Management, Modeling, Oracle, Project, SDLC, SQL, Testing
Full Time, Full Time
Work from home not available Travel not required

Job Description



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

Farmers Group, Inc. seeks a Jr.ETL Developer to build and govern Operational Data Store (ODS) mappings and integrations. The ETL Developer will be responsible for SDLC of ODS application assets: gathering and interpreting business requirements; creating and documenting program design; coding, testing, and performance tuning program changes; supporting all implementation activities; and providing post-implementation monitoring/support.


Essential Job Functions


Informatica repository creation/configuration and mapping/workflow development, ODS data model enhancements, management of timely oral and written communications on project progress and overall status, facilitation of in-person and remote meetings with business & IT resources, coordination of code reviews and participation in peer-reviews to ensure development adherence to coding standards for quality and compliance, and maintenance of application run books and dashboards.


Education Requirements: High school diploma or equivalent required. Bachelor's degree preferred (Computer Science, Engineering, Information Technology, or similar field) or equivalent or specific relevant experience with 1 year of experience in job offered.


Experience Requirements:


  • Strong understanding of operational data staging environments, data modeling principles, and data warehousing concepts.
  • Strong analytical skills and SQL proficiency.
  • Strong knowledge of Informatica ETL and Oracle/DB2 database technologies.
  • ETL background (SSIS, ODI, Informatica, DataStage, etc.)
  • Strong oral and written communication skills.
  • Effective problem solving and time management skills.
  • Ability to explain complex concepts/issues in simple terms.
  • Ability to identify and appropriately escalate issues/risks to management for direction.
Special Skill Requirement :

  • Experience with ERWIN or similar data modeling tools, preferred.
  • Experience with JSON services or IIB integrations, preferred.
  • Experience in P/C Insurance Industry preferred (not required).
  • Experience with Sharepoint or other document sharing technologies, preferred.
  • Good written and oral skills in local language, preferred.


Farmers is an equal opportunity employer, committed to the strength of a diverse workforce.






Schedule: Full-time

Job Posting: 08/13/2019



Company Information

Creative, innovative, collaborative—if this describes you as an IT professional, Farmers® is a great place to build your career. IT at Farmers means working outside of traditional business and technology silos to not only ensure the security of our systems, but to develop forward-thinking products to help improve the experience of millions of Farmers customers. On the Farmers IT team, sharing knowledge and creating new tools is central to the daily work, and helps to power our company culture.
Dice Id : 80153772
Position Id : 190006B1

Similar Positions at Farmers Insurance

ETL Subject Matter Expert
  • Woodland Hills, CA
  • 2 days ago
IT Database Administrator - Woodland Hills, CA
  • Woodland Hills, CA
  • 2 days ago
Informatica Cloud Developer
  • Woodland Hills, CA
  • 2 days ago