Job Description

Job Description:

The developer will help design, develop, and maintain ETL mappings, sessions, workflows and batches required for servicing of Arch's Data Warehouse and Marts. The developer will also participate in the business analysis process, conduct data quality investigations, and assist in the development of test plans and test data. He or she will work closely with other SQL/DW developers and may assist in the development of ETL solutions with DW team. The developer should possess excellent technical/business communication skills to interact with both IT & business teams for understanding requirements to develop and deploy data integration solutions to support DW and BI efforts.

Required Skills:
  • Good Production support experience in Data Warehouse side and strong T-SQL skills.
  • Knowledge and experience applying SDLC processes
  • About five (5) years of related experience in IT corporate systems environments required.
  • Minimum of three (3) years' experience with Informatica Power Center in the MS SQL 2000/2005/2008/Oracle environments and in designing and developing complex ETL packages
  • Strong technical knowledge of Enterprise Data Warehouse, design and development of ETL packages, database design, operating systems and Information Management
  • Must have the strong communication skills and ability to develop and present solutions to team and managers
  • Must be able to solve complex problems with direction
  • Must be able to interact effectively and patiently with customers during time sensitive tasks
  • Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required
  • Ability to establish and maintain positive working relationships with other employees
  • Understanding of Interface Concepts (both end-user and data)
  • Knowledge of P&C / Specialty insurance is a real plus

Should you be interested kindly send your resume to Thank you!

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online