Selective Insurance Company of America

IT Sr. Application Developer ETL

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


Selective Insurance is looking for an IT Sr. Application Developer – ETL to work in the Information Management – E&S BI Analytics Department and work as part of a cross-functional team to develop ETL solutions. This individual plays a key role in the team with responsibility for data integration and data transformation for various analytic needs. The individual should apply thought leadership in the areas of application modernization and technology advancement in ETL space. All job duties and responsibilities must be carried out in compliance with applicable legal and regulatory requirements.


  • Understands and translates business needs into technology solutions
  • Builds complete data Integration solutions working in an Agile environment to provide rapid solutions conforming to best practices using tools like Informatica - PowerCenter, and DVO.
  • Perform data analysis, data modeling, document processes, develop, test, implement and maintain based on business requirements.  
  • Writes complex SQL Queries against SQL Server and Netezza including analyzing and troubleshooting SQL statements, code and modeling database objects.
  • Plans and provides ETL solutions to achieve desired end-results on business problems working closely with Data Architects and BI Admin team 
  • Independently performs problem determination and resolution in the production environment and support production as needed both during and after normal business hours.
  • Performs code, design, and test plan reviews for peers and develops system implementation schedules. Coordinates testing and debugging for programming changes with Data Warehouse team, other Information Management teams including E&S Operational System team.
  • Learn new tools / technologies / methodologies as appropriate for the department, etc.
  • Responsible to acquire training, as needed, and will learn user functions, organization, and role in the enterprise to the extent required


  • College degree in Computer Science, Management Information Science, Business Administration or related field preferred.
  • Minimum 6 years of experience with
    • Developing, testing and implementation of ETL processes using Informatica Suite tools - Power center
    • RDBMS, developing SQL programming and SQL Stored procedures using MS SQL Server 
    • Full Project life cycle implementation specific to ETL
    • Performance tuning in Informatica Powercenter
    • Experience working in:
      • Netezza
      • DVO
      • Proficiency with query optimization using Netezza, SQL Server 
  • Additional understanding of BI technologies like SSIS, SSRS and SSAS is preferred.
  • Highly motivated with passion for designing and developing analytics solutions
  • Experience diagnosing problems and troubleshooting production issues
  • Strong analytic and problem solving abilities
  • Strong foundation in System Development Lifecycle principles
  • Strong written and verbal communication skills are a must for this position
  • Property Casualty Insurance experience preferred

Experience working in Agile 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