Informatica ETL Developer
Apply NowCompany: Centraprise
Location: Minneapolis, MN 55407
Description:
Job Title: Informatica ETL Developer
Location: Minneapolis, MN
Job Type: Full Time
Job description:
Solid 3+ years in Informatica ETL process
Design and develop mappings, Workflows from various Transformations like re-usable transformations, Mappings/ Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
Create Informatica mappings, workflows with source as mainframe, Databases and multiple files.
Good understanding on PL/SQL store procedures/functions to incorporate in ETL for data load.
Strong experience in Dimensional Modelling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using Erwin and ER-Studio
Create informatica mappings using CDC flow.
Create Dimension/Fact with all types of SCD concepts.
Experience on Unix Shell Scripts which would be used in ETL to do other activities.
Good understanding on deploying ETL workflows in QA and Production using Bitbucket, Bamboo and RA tools.
Experience in Performance tuning of targets, sources, mappings and sessions.
Good understanding of development methodologies like Waterfall and Agile model
Good communication skill is a must.
Location: Minneapolis, MN
Job Type: Full Time
Job description:
Solid 3+ years in Informatica ETL process
Design and develop mappings, Workflows from various Transformations like re-usable transformations, Mappings/ Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
Create Informatica mappings, workflows with source as mainframe, Databases and multiple files.
Good understanding on PL/SQL store procedures/functions to incorporate in ETL for data load.
Strong experience in Dimensional Modelling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using Erwin and ER-Studio
Create informatica mappings using CDC flow.
Create Dimension/Fact with all types of SCD concepts.
Experience on Unix Shell Scripts which would be used in ETL to do other activities.
Good understanding on deploying ETL workflows in QA and Production using Bitbucket, Bamboo and RA tools.
Experience in Performance tuning of targets, sources, mappings and sessions.
Good understanding of development methodologies like Waterfall and Agile model
Good communication skill is a must.