Must have skills: DataStage Expert, Unix, SQL programming, Datawarehousing concepts, DBT, Snowflake
Nice to have: Python, Shell Scripting
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