Informatica Specialist – Information Delivery (MLH306)

 

About the Company

Come Work With Us!


At Selective Insurance, we specialize in developing careers for people who share our values of commitment, integrity and extraordinary service. As a leading regional property and casualty insurance organization, we provide a broad range of insurance products and services to an expanding market throughout our operating territory. A.M. Best has rated Selective A+ (Superior) for 45 consecutive years.


 

About the Opportunity Informatica Specialist ~ Information Delivery

Corporate Headquarters ? Northern NJ


Selective Insurance is seeking an IT professional to function in an Informatica administration role for our business intelligence team.  This technical position requires hands-on capabilities.  You will be responsible for installing, configuring, upgrading, monitoring and the administration of Informatica PowerCenter for our organization.  You will be directly responsible for ensuring a stable and reliable environment including performance monitoring and tuning, capacity planning, load balancing and failover planning.  You will need to work closely with the system administrators and database administrators to monitor and tune performance, track and manage system usage and patterns, forecast system growth needs, coordinate releases, manage system events and report to management on opportunities to further automate and optimize our systems. You will be responsible for maintaining and troubleshooting existing Informatica programs, in addition to developing new ETL programs as needed to contribute to the other aspects of the business intelligence team.  You will provide expert guidance and mentor a group of developers in their programming activities, as well as serve as the focal point for all Informatica related issues.  You will also need to work with management to ensure adherence to license agreements. You will need to learn other technologies to contribute to other aspects of the organization.  You will play a key role on the business intelligence team and expectations and standards are high.  You will be responsible for providing production support as required both during and after normal business hours.

 

Responsibilities include, but are not limited to:

Provide lead and administration support for all components of Informatica

Responsible for setting up security, groups and roles as well as defining development standards and reviewing scripts to ensure they comply to guidelines

Will act as coordination point for promoting jobs between all environments

Work with the system administrators, database administrators and developers to support test and production Informatica servers including daily administration, configuration management, monitoring, tuning and tool automation

Resolve problems in areas of performance, availability, access and other issues

Works closely with the business intelligence project managers

Participate in data modeling, design and metadata documentation sessions

Prepare estimates for design, coding and testing

Prepare technical specifications

Perform impact analysis to existing programs

Help development teams perform testing and debugging of programs

Modify existing ETL programs and write new programs as needed

Assist lower-level programmers in the development of complex programs

Debug/resolve issues of moderate to high level of difficulty whenever necessary

Monitor and report on performance and various other aspects of Informatica

Assist with pre-release and release processes including change control, contingency and fallback plans and production turnover and support

Work with other IT departments on integrated support as required

Provide off hours production support as required



 Candidates should meet the following require skills and requirements:

2 or 4 year degree in Information Technology, Computer Science, Business Administration or related field or completion of computer technical school

5+ years experience as developer and administrator in Informatica PowerCenter

Informatica lifecycle implementation experience

Minimum 3 to 5 years writing SQL and PL/SQL programs

Minimum 3 to 5 years of Data Warehouse/Data Mart experience

Strong understanding of relational and dimensional data modeling

Strong experience putting together and delivering technical presentations

Ability to develop creative solutions to address complex automation problems

Ability to understand and translate business needs into technical solutions

Previous experience as a technical lead and strong coaching skills

Strong analytical and problem solving abilities

Knowledge of modeling tools such as Erwin is a plus

Strong experience diagnosing problems and troubleshooting production issues

Experience with business intelligence reporting tools such as Cognos preferred

Experience with test tools such as LoadRunner and TestDirector preferred

Excellent written and verbal communication skills a must

Property Casualty Insurance experience preferred

 Salary requirements are requested with response (please use reference code: MLH306). "While all responses are appreciated, Selective will only contact candidates in whom we have an interest in discussing employment opportunities." NO AGENCIES/NO PHONE CALLS PLEASE!!!!!!
 Benefits We recognize people as our most valuable asset. Our employees enjoy an energized work environment, competitive salaries and benefits that include: Medical, Prescription, Dental, Life Insurance, Accidental Death & Dismemberment Insurance, Annual Cash Incentives (based on business and individual performance), Retirement Program and Flexible Spending Accounts in addition to our paid time off plan. Other benefits include Stock Purchase Program and confidential Employee Assistance Program. Job training programs and tuition reimbursement are also available.

* All qualified applicants will receive consideration for employment without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation or sex.
 ** All employment offers contingent upon the satisfactory completion of a comprehensive background investigation.
No recruiters or agencies without a previously signed contract. Only candidates whose profiles closely match requirements will be contacted during this search.