ETL Informatica Developer

Qualifications:Basic knowledge of insurance and financial services products preferred. Advanced planning/organizational, problem-solving, analytical, time management, decision-making, and communication skills required, as well as solid leadership and basic presentation skills. Must be able to effectively communicate technical plans, strategies, and designs to all levels of the company. Basic knowledge of business unit applications preferred. Must be able to maintain a high degree of accuracy and confidentiality. Proficiency with database applications; knowledge of mainframe, distributed, and/or web programming languages. Working Conditions: Some travel may be required, including overnight stays. May be required to provide on-call support. Bachelor's degree in a computer related field or equivalent work experience plus 6-10 years of experience in IT field required. Proven experience as a senior IT professional. For positions with Principal Global Investors, you will be required to comply with a Code of Ethics which covers a number of obligations related to personal and business conduct as well as personal trading activities for you and members of your household. These same requirements may also apply to other positions across the organization. This position is for an Informatica/ETL developer/designer.

Skills needed

• Strong Informatica coding AND DESIGN skills.
• Strong knowledge of Data Warehouse environment (Warehouse table layers, ETL processes, Warehouse design concepts, etc.)
• Strong DB2 and SQL knowledge.
• Strong communication skills!
• Must be able to work independently without much hand holding.
• Must be driven and willing to take initiative
• Will be working on a scrum team so Agile experience preferred

Responsibilities:Under general direction, identify and provide complex technical and business solutions to meet business strategy. Provide leadership in areas of expertise throughout all phases of application systems development.

Comments:

Data Train team info:

• Agile/Scrum shop
• Work for Retirement (401k, Defined Benefit) business (approx. 450 IT folks in RIS business unit).
• 6 Scrum teams (4 Data Integration and 2 reporting)
• 6 8 per scrum team made up of Scrum Master, IT Product Owner, Bus Product owner, Developers, QA's & BA's
• Plan work in 10 week Program increments (5, week sprints)
• Teams/responsibilities divided up by data subject (Member level data, Plan level Data, Advisor level data, Investment level Data, etc.)

Skillsets/Technical knowledge:

• Strong understanding of Data Warehouse environment (all layers; staging, consumption (facts & dimensions).
• Data Modeling techniques (relational vs dimensional, historical vs current view)
• Good understanding of data acquisition methods
• Strong Informatica skills (for developers, bonus for QA/BA)
• Strong understanding of ETL processes in DW environment. Need to understand relationship between different DW layers/constructs
• Experience writing business requirements for data centric (analytic/reporting) needs (required for BA, bonus for BA/Dev)
• Experience creating test plans for ETL processes in a DW environment plus strong understanding of regression testing methods (required for QA, bonus for BA/Dev)
• Expected to assist with on-call responsibilities and production support