ETL Subject Matter Expert

company banner
Farmers Insurance
Agile, Analysis, Analyst, Business Objects, Business Requirements, Data Modeling, Data Warehouse, DB2, Development, IBM, Informatica, Lifecycle, Modeling, Project, QA, Shell Scripting, SQL, Testing, Unix
Full Time, Full Time
Work from home not available Travel not required

Job Description



We are Farmers!
Want to work at a company who aspires to make state of the art technology central to business? Ready to play your part in a team that is skilled, knowledgeable and agile? Appreciate an environment where your opinions and contributions are highly valued?



We will provide you with a place to grow, a place to build a career, and a place where everyone is part of the team. At Farmers, you will have the opportunity to work on today's most innovative projects in ETL solutions. We recognize that our success results from the success of our employees, and we strive to create an environment that challenges and nurtures talent.



Job Summary


Farmers is looking for an Informatica ETL Subject Matter Expert and Support Analyst with a knowledge of design, development and testing of ETL systems and an aptitude to support and optimize existing Data Warehouse and related applications. The right candidate will work on supporting a complex landscape of Data Applications, identification and analysis of optimization opportunities, design and development of solution options. Role also involves leading supplier partners and liaising with business and IT partners to deliver successful outcomes.


Essential Job Functions



  • Understand the source systems, applications and conduct the data profiling.

  • Support production data sets, Informatica jobs and applications to meet business SLA's.

  • Provide subject matter expertise and knowledge guidance to end user stakeholders.

  • Identify, build and deploy optimization and automation opportunities.

  • Convert Business Requirements into Technical Requirements and Design.

  • Assist and resolve production issues.

  • Create Informatica Mappings, Workflows and Sessions.

  • Perform audit, balance and checks for data loads.

  • Governance and audit of supplier partner deliverables and production implementations.

  • Co-ordinate Data Modeling of Sources and Targets.

  • Provide Support for QA/UA Testing.

  • Review and validate the detailed technical design for business applications provided by the supplier to ensure alignment with business requirements; Validates suppliers estimates.

  • Estimates Rough Order of Magnitude for the level of effort/cost of new application functionality.

  • Performs quality review checks on project deliverables.

  • Acts as liaison between Business and IT, as assigned.


Education Requirements: High school diploma or equivalent required. Bachelor's degree preferred or equivalent, relevant experience.


Experience Requirements:



  • 2+ Years of experience on Informatica ETL development.

  • 1+ Years of experience on Informatica ETL Production support.

  • Experience understanding of data warehousing concepts - Star schema/Snowflake schema, Type I/Type II dimensions, etc.

  • Strong SQL skills.

  • Unix Shell scripting.

Special Skill Requirement



  • May require occasional traveling.

  • Good written and oral skills in local language.

  • Business Objects a plus.

  • Tableau a plus.

  • IBM DB2 a plus.
  • Flexible and adaptable, regularly adjusting direction and vision based on feedback from multiple sources, including customers, and internal staff.
  • Collaborative mind set to work with multiple teams and stakeholders.
  • Demonstrated ability to effectively work through a formal system development lifecycle.
  • Comfortable working in both co-located and large scale distributed environments using Agile methodologies and techniques.
  • Strong verbal and written communication skills.
  • Solves complex problems and develops innovative solutions.

(HR Title: Application SME I)



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

Schedule: Full-time

Job Posting: 07/01/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 : 1900035C

Similar Positions at Farmers Insurance

Informatica Cloud Developer
  • Woodland Hills, CA
  • 1 day ago
IT Database Administrator - Woodland Hills, CA
  • Woodland Hills, CA
  • 1 day ago
IT Data Analyst - SQL proficient
  • Woodland Hills, CA
  • 1 day ago
Network Subject Matter Expert
  • Oklahoma City, OK
  • 1 day ago
ETL Developer
  • Bellevue, WA
  • 1 day ago