Get your dream job within 2 days (HURRY UP)ENROLL NOW

ETL Informatica Developer

Job Id : 5605

Jobtitle : ETL Informatica Developer

Location : Des Moines, IA

Company Name : WissenIT Group

Industry : Information Technology

Salary : $71,000 - $125,000  YEAR

Job type : Fulltime

Posted on: 2019-10-15

Required Skills : Agile, Scrum, ETL, DB2, SQL, Coding Skill

Benefits : No benefits are available

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.



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



Latest jobs for you

  • AWS Solution Architect

    3K Technologies Santa Clara , CA

    Job Description : Solid experience (10-15 years) with on-prem and cloud (private and public) ...

    View Job
  • Senior Software / Data Engineer / Petabyte-scale

    Workbridge Associates San Francisco, CA

    This person should be a strong Java developer and experience with Hadoop stack, Spark, Hive, ...

    View Job
  • Test Execution Lab Technician FQA

    Kelly Services Irvine, CA

    Job Description: The Test Execution Lab Technician (Firmware Quality Assurance) will be ...

    View Job
  • Test Engineer

    Sira Consulting Nashville, TN

    Job Description : Skills required: 5+ years Healthcare, Automation testing, UFT, Web ...

    View Job
  • Java Developer - W2

    Sira Consulting San Jose, CA

    Job Description: Required Skills: Post Java Developer with 8+ years experience Java ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First