Previous Job
Previous
ETL Developer : 20-00486
Ref No.: 20-00486
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.”
 
Primary Skills: ETL background (SSIS, ODI, Informatica, DataStage, etc.)
Duration: Full time
W2 only
 
Responsibilities:
  • Seeking an 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.
  • 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.
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.
  • Understanding of operational data staging environments, data modeling principles, and data warehousing concepts.
  • Analytical skills and SQL proficiency.
  • Knowledge of Informatica ETL and Oracle/DB2 database technologies.
  • ETL background (SSIS, ODI, Informatica, DataStage, etc.)
  • Ability to explain complex concepts/issues in simple terms.
  • Ability to identify and appropriately escalate issues/risks to management for direction.
  • 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.
         To follow up with any questions, please contact Shabana at 408-907-2246

Akraya is an award-winning IT staffing firm and the staffing partner of choice for many leading companies across the US. We offer comprehensive benefits including Health Insurance (medical, dental, and vision), Cafeteria Plan (HSA, FSA, and dependent care), 401(k) (enrollment subject to eligibility), and Sick Pay (varies based on city and state laws).
 
If this position is not quite what you're looking for, visit akraya.com and submit a copy of your resume. We will get to work finding you a job that is a better fit at one of our many amazing clients. 

Akraya is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to gender, race, religion, national origin, ethnicity, disability, gender identity/expression, sexual orientation, veteran or military status, or any other category protected under the law. Akraya is an equal opportunity employer; committed to a community of inclusion, and an environment free from discrimination, harassment, and retaliation.