Previous Job
Junior ETL Developer : 19-04453
Ref No.: 19-04453
Category: BI, ETL & Data Warehousing
Location: Woodland Hills, California
"Women Back to Work is partnering with Farmers Insurance in Woodland Hills, CA to host their inaugural Returnship for those looking to return to the workforce. The WBW Farmers Returnship program is open to women who have a gap in their work history due to caring for a loved one, raising a child, or other voluntary reasons.  If you have at least 4 years of professional experience and have been out of the paid workforce for at least one year, we welcome you to apply. You will have the chance to upgrade your skills, build your experience and make valuable connections during this Returnship.”

Job Summary:
We seek 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.
If this job interests you and you are looking to return to work after a hiatus, please apply with your updated resume. Or if you have questions about this position, feel free to call 408-907-2246 to speak to Shabana, our dedicated Women Back to Work recruiter. 

If you are a Returner and can't find a position that is a good fit, please send your resume to and we'll get to work finding something that is a match for your skillset.