WestDesMoinesRecruiter Since 2001
the smart solution for West Des Moines jobs

ETL Developer

Company: Sammons Financial Group, Inc.
Location: West Des Moines
Posted on: September 16, 2021

Job Description:

Insight Global is looking to directly hire an ETL/Informatica Developer in a permanent role to join a growing financial company located in West Des Moines, IA. The ideal candidate will be joining a new team of Enterprise Data & Analysis professionals to assist with streamlining data security across an entire organization and ensuring that the flow of data is secured from start to finish. Under general direction, formulates and defines system scope and objectives. Devises or modifies procedures to solve highly complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed specifications to write programs. Designs, codes, tests, debugs, documents and maintains those programs. Competent to work on and responsible for nearly all phases of applications systems analysis and programming projects. Regularly provides guidance and training to less experienced analysts/programmers. This team will also be exploring and releasing a new Data Lineage tool which this candidate will assist in the roll-out and implementation of that new technology. Additional responsibilities include, but are not limited to:

As a ETL developer you would be responsible for developing the ETL mappings as per the Technical Specs.

Test the ETL mappings developed as per the Specs to ensure quality of the mappings and the data.

Provide inputs to continuously improve ETL process discipline and resulting output quality.

Tuning of ETL performance.

Collaborate with the Architects on POC of new tools and technologies.

Exposure to cloud based DW Snowflakes highly preferred.

Exposure to CDC tools like Attunity Replicate, AWS DMS, Goldengate etc. is good to have.

Experience with Python nice to have.

Snowflake data warehousing experience.

Insurance or Annuity experience.
Bachelor's Degree in the field of Computer Science, Information Science, Management Information Systems, Information Technology, or similar field.

5+ years of experience developing in Informatica.

5+ years of experience in designing and delivering Data Warehouses and reporting solutions.

High Level of SQL experience in regards to complex SQL queries.

Experience with Database technologies such as Oracle, DB2, SQL server.

Experience with Extract, Transform and Load and ELT development.

5+ years of hands on experience with Informatica Power Center.

Data modelling experience with dimensional modeling.

Understanding of Metadata, Data Governance, Data Quality and Data security.

Keywords: Sammons Financial Group, Inc., West Des Moines , ETL Developer, Other , West Des Moines, Iowa

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Iowa jobs by following @recnetIA on Twitter!

West Des Moines RSS job feeds