As part of Data migration project, following skill set resource should have –
Should be Technically sound in ETL process
Should have strong Experience in Change Data Capture
Should have strong Experience in expressions, Lookup tables (Connected & unconnected), Router, Union, Filter , Rank and Other transformations of ETL
Should have Enrich experience in handling Data Quality and Data Cleansing
Should have hands on experience on building the data warehouse
Should have expertise on scheduling the ETL jobs
Should have good Knowledge of SQL/PLSQL.
Should have Good knowledge on working with Oracle/Sybase/MS SQL Databases.
Should have good Knowledge of Dimensional Modeling using Star schema and Snow Flake schema for faster, effective querying and Business Analysis Requirements.
Should be able to understand the requirements and write Functional Specification Document, Design Document and Mapping Specifications.
Should have Strong Expertise in working with power center designer to create mappings, mapplets and transformations to integrate data between various data source systems and target platforms.
Should have Good knowledge in ETL Error Debugging/Handling.
Should have Good knowledge in ETL flow deigning.
Should have knowledge on CRM Data Structure
Should have experience on Data Masking and Data Security.