Selective Insurance Company of America

Application Developer

Experience (Years)
Information Technology
Full-Time Regular
FLSA Status
Job ID
Travel %
Relocation Cost


This position is for an ETL developer with Informatica PowerCenter experience to join Selective Insurance Company’s Enterprise Data Warehouse team.  Develops procedures for the solution of well-defined routine business problems with a high level of reliability, execution and speed. Converts these procedures into applications and programs required for computer solutions. All job duties and responsibilities must be carried out in compliance with applicable legal and regulatory requirements.


  • Analyze business requirements
  • Develop new or modify existing Informatica mappings based on those requirements while following department’s standards and guidelines
  • Write/update technical documentation including data flows
  • Provide support for production issues as needed
  • Learn new tools / technologies / methodologies as appropriate for the department, etc.
  • Meet with business unit representatives to define and evaluate routine business automation needs. Interpret business specifications to prepare for analysis/design functions.
  • Participate in systems analysis, general systems design, and detail systems design.
  • Generate, test, and document program code. Debug and resolve problems of moderate difficulty.
  • Modify existing applications programs or writes new programs of basic to moderate complexity and scope, working with applications systems designs and specifications and utilizing standards, procedures, and techniques.
  • Research and resolve problems in the production environment.
  • Assist higher-level programmers in the development of complex programs.
  • Assist others with debugging whenever necessary.
  • Responsible to acquire training, as needed, and will learn user functions, organization, and role in the enterprise to the extent required.


  • Ability to work well with others.
  • Possesses excellent verbal and written communication skills
  • Familiarity with related development environments.
  • ETL developer with 2-4 years of experience with Informatica PowerCenter.
  • Experience or exposure to additional Informatica tools a plus.
  • Demonstrated ability to create or modify SQL queries of medium to high complexity on SQL Server platform.
  • Experience with Netezza a plus.
  • Team player, able to work with team members both onsite and offshore.
  • Exposure or experience with any scheduling tool such as Control-M, Zena, Tidal, Auto Sys is a plus
  • College degree in Computer Science, Management Information Science, Business Administration or related field preferred.
  • Two years of programmer/analyst experience.

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