Principal Application Developer/Analyst

US-RI-Johnston
Job ID
2017-7136
# Positions
1
Work Location
Works from an office location
Employee Type
Employee
Category
Information Services - Applications Developer

Overview - External

PRINCIPAL APPLICATION DEVELOPER/ANALYST

Responsibilities - External

Duties:

 

Responsible for oversight of the coding, testing, analysis, design, definition, development and implementation of business applications within FM Global's Information Services department. Design, develop, maintain and otherwise support ETL software that migrates data across environments and/or systems including the transformation and population of the data. Write T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes. Develop detailed technical specifications and ETL documentation in collaboration with data analysts and Business Intelligence developers. Design ETL audit control and scheduling processes. Collaborate with quality assurance specialists and develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues.

 

Qualifications - External

Requirements:

 

Requires Bachelor’s degree in Computer Science, Management Information Systems, Computer Engineering, or related field of study and 7 years application development experience with focus in Data Warehousing, Business Intelligence, and Data Mart. Experience specified must include:

 

  • 7 years experience with ETL technologies such as Unix shell scripts, PL SQL, Oracle Transparent Gateway, SSIS ETL tools, Microsoft SQL Server, Microsoft APS, PowerShell;

 

  • 7 years experience with translation of requirements and models into highly effective technical processes and/or business system designs;

 

  • 5 years business processes experience in financial services, insurance, or healthcare industries;

 

  • 5 years experience in the project management life cycle.

 

40 hours / week

 

Job location:   Factory Mutual Insurance Company: 270 Central Avenue, Johnston, RI 02919.

 

Apply to:           Apply at www.fmglobal.com/careers, job ID# 2017-7136

                              Factory Mutual Insurance Company

270 Central Avenue

Johnston, RI 02919