ETL Developer 1 5 Years Need to be aware of Datawarehouse Concepts [ - Must have
Star Snow flex Schema - Must have Different Dimensions wit example - Must have Fact Fact Less fact - Must have OLAP and OTLP - Logical design/Physical design - Must have Normalise/Denormalise - Must have
Basics of scripts [unix] - Must have Need Informatica Concepts[like what is mapping ,transformation, variables, parameters ….]. - Must have Need to work on mappings with different sources - Must have Need to know all kinds of transformations. - Must have Mapplets Reusable Transformation. - Must have It will be good to develop one mappings on different transformation - Must have Session Configuration - Must have Workflow Worklet Configuration. - Must have Scheduling the workflow. - Must have Performance Tuning.- Good to have
Need to write Queries based on Scenario [like duplicate records Deletion, Joiners, to get topmost record….] -Must have Different types of Keys. - Must have Complex Queries based on Scenario - Must have Basic PL/SQL - Good to have Pan India