ETL Informatica Developer

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

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Node JS Senior Dev / Dev Lead (Node JS, Web Se...
Bellevue, WA Next Level Business Services, Inc.
Direct Client - Sr. Oracle Apps ( EBS ) Devel...
Seattle, WA ChaTeck Incorporated
Web Development Immersive Instructor
Seattle, WA General Assembly
Store Community Development Specialist - Natio...
Redmond, WA Microsoft Corporation