• Principal Application Developer/Analyst

    Location US-RI-Johnston
    Job ID
    # Positions
    Work Location
    Works from an office location
    Employee Type
    Information Services - Applications Developer
  • Overview - External


    Responsibilities - External



    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



    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