Skills: DataStage, SQL programming, Datawarehousing concepts
Skill Description: Create workflows for data extraction, transform and loading of data from source to target
Thorough knowledge of different source systems like Files, DBs SQL, Oracle, DB2 etc.
MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB and IBM Db2 Etc.
Good understanding of target systems like landing zone, transformation zone, data warehouse, data marts
Strong understanding of source to target mapping, data lineage, data reconciliation