Share this Job
Apply now »

Sr. Informatica Developer


We are Farmers!

We are… more than just your favorite commercials. We are a passionate, award winning, equal opportunity employer, committed to the strength of a diverse workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn’t just our business – it’s our culture! We are Farmers!


Do you thrive in a high-volume, fast-paced environment? Do you enjoy the challenge of a position where no two days are alike? We are looking for positive, high-energy professionals who are not just looking for a job, but a meaningful career!

Job Summary

Farmers New World Life (Bellevue, WA) seeks a Sr. Informatica Developer to design, implement, and operate comprehensive Data Warehouse systems to balance optimization of data access with batch loading resource utilization factors, according to customer requirements. Specific duties include: implementing large-scale big data and cloud ecosystems to generate business insight reports; architecting and building ETL jobs using Informatica product suites with embedded business logics to load Data Marts and Data Warehouse and generate reports for business users; creating complex SQLs, PL/SQL and stored procedures to perform data analysis and loading into the RDMS; creating ETL jobs and Unix/Linux scripts to manage complex ETL data integration pipelines; participating in Data Warehouse data modeling; performing requirement gathering and analysis, issue clarifications, reviewing documentations and performing use case analysis; performing data warehouse capacity planning and maintenance, monitoring and performance tuning; preparing and executing Unit test cases, System Integration testing and User Acceptance testing; managing and mentoring support and development team; and participating in operational review meeting with multiple stake holders. Positions requires AWS Certified Cloud Practitioner Certification. Option to work remotely is available.

Position requires a Bachelor’s degree or foreign equivalent, in Computer Science, Electronics Engineering, or a closely related field of study, plus 2 years of experience in the job offered, or as a Technology Lead, or similar experience in data warehouse and ETL domain. Must have 2 years of experience with each of the following: working with ETL Tools, including Informatica PowerCenter 10.1, Informatica PowerExchange; working with Databases, including Oracle 12c, 11i, 10g, and Teradata; working with various languages, including Oracle PL/SQL, Oracle Stored Procedure, Unix/Linux Shell scripting, and Python programming; and working with Cloud Technologies, including AWS Lambda, AWS Glue, AWS Dynamo DB, AWS Aurora DB, and AWS Redshift. Must have AWS Certified Cloud Practitioner Certification. Option to work remotely is available.

Full time position. Apply by submitting your resumes at, Job ID 16625








Job Location(s): US - WA - Bellevue-15500

Want to learn more about our culture & opportunities? Check out and be sure to follow us on InstagramLinkedIn, and TikTok.

Nearest Major Market: Seattle
Nearest Secondary Market: Bellevue

Apply now »