ETL DEVELOPER

Zurich Capability Center is currently looking for a ETL Developer.

ETL Developer

This position will be part of an Enterprise Data Management Team that will be responsible for leveraging the value of the data assets throughout the organization and will facilitate the development/implementation of the desired end-state data environment.  The Enterprise Data Management Team will also be responsible for improving the organization's decision-making capabilities by providing high quality, transparent data within the data warehouse and associated data marts.

The talented Data Engineer will have experience working with very large data sets, designing, developing and debugging Informatica processes that populate Data warehouses on (MPP) platforms. The Data Engineer will also have significant knowledge of Big Data technologies and tools with the ability to share ideas among a collaborative team.

In this role, she/he will participate on core teams identifying and validating data scenarios within the Enterprise. The candidate will need to demonstrate the ability to develop actionable plans, recognize opportunities and be able to report out on on-going progress. This role will require technical documentation abilities and team coordination skills.

Client Internally Focused - The job’s core deliverables rely on delivering service to internal clients, usually at the line manager or employee level. May involve sharing subject matter expertise to others in the organization or supporting others in their efforts to deliver on our promise.

Basic Qualifications:

• Bachelors Degree in Computer Science or Mathematics/Statistics and 6 or more years of experience in the Data Engineering area

OR

• High School Diploma or Equivalent and 8 or more years of experience in the Data Engineering area

OR

• Zurich Certified Insurance Apprentice including an Associate Degree in Computer Science or Mathematics/Statistics and 6 or more years of experience in the Data Engineering area

AND

• 5 or more of experience in Enterprise Data Management
• Experience with ETL Architecture, ETL Design and End-to-End ETL Development work
• Experience in scripting languages
• Experience with data transformation and aggregation tools
• Experience in data analysis, data interrogation or data profiling

Preferred Qualifications:

• Experience with Informatica PowerCenter
• Experience with processing large datasets on MPP platforms
• Strong SQL and stored procedures skills
• Experience in scripting languages including Shell and Perl
• Experience with replication tools like Attunity
• Exposure to job scheduling tools like AutoSys
• Experience with Dev/Ops
• Strong verbal and written communication skills
• Ability to work independently and interact effectively as part of a team
• Insurance industry experience

Who we are 

Looking for a challenging and inspiring work environment where you can make a difference? At Zurich millions of individuals and businesses place their trust in our products and services every day. Our 53,000 employees worldwide form the basis of our success, enabling, businesses and communities to face a world of risk with confidence. Imagine if you could help people do this all over the world. You’d give them confidence and reassurance by protecting what they love most. It’s a big challenge, but you will be supported by a world-class team who believe in helping you to reach your full potential and deliver on our promises. 

So be challenged. Be inspired. Help us make a difference. 

At Zurich we are an equal opportunity employer. We attract and retain the best qualified individuals available, without regard to race/ethnicity, religion, gender, sexual orientation, age, or disability