Selective Insurance Company of America

ITS Senior Application Developer

Location US-NJ-Branchville
Experience (Years)
Information Technology
Full-Time Regular
FLSA Status
Job ID
Travel %
Relocation Cost
Auto Reimbursement


Selective Insurance is looking for a Sr.Application Developer, Informatica to work in the Information Management - Advanced Analytics Department on the predictive modeling team. The individual in this role will use data integration and data quality products on Informatica, Statistica, Netezza and SQL Server technologies and assist in predictive model build and deployment.  The Individual should be able to work directly with business owners to develop solutions and apply thought leadership in advancement of analytics at Selective. All job duties and responsibilities must be carried out in compliance with applicable legal and regulatory requirements.


  • Builds complex data Integration/analytics solutions working in an Agile environment
  • Implement proven practices using tools like Informatica - PowerCenter, DVO, Data quality and Statistica. 
  • Perform data analysis, data modeling, document processes, develop, test, implement and maintain Informatica processes to extract, load and process data based on business needs.  
  • Writes complex SQL Queries against SQL Server and Netezza including analyzing and troubleshooting SQL statements, code and modeling database objects.
  • Independently performs problem determination and resolution in the production environment and support production as needed both during and after normal business hours.
  • Assists and guides junior developers and performs code, design, and test plan reviews for peers.
  • Build Proof of Concepts to explore technology trends in analytics for use within the organization.


  • College degree in Computer Science, Management Information systems, Engineering, Business Administration or related field preferred.
  • Minimum of 3 years of experience with
    • Developing, testing and implementation of ETL processes using Informatica  Power center
    •  Sound understanding of dimensional and relational database models and working experience related to Data Warehouse and/or Data mart
    • SQL programming and SQL Stored procedure experience using MS SQL Server and/or Netezza
    • Data analysis, profiling and data quality
    • Strong understanding of ETL Testing strategies
  • Must be self-motivated and be able to work with minimal supervision
  • Strong analytic and problem solving abilities
  • Strong written and verbal communication skills are a must for this position
  • Property Casualty Insurance experience preferred
  • Experience working in Agile Scrum Methodology is preferred

Selective is an Equal Employment Opportunity employer. Selective maintains a drug-free workplace.



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed