ETL / Datastage Developer
Clayton, MO - Onsite from Day 1
Fulltime Opportunity
Must Have :
Datastage, ETL, Snowflake, Python, IBM Cloud Pak, Azure, Fivetran, Talend or Informatica
Backgroud :
- Datastage is our main ETL tool which is on IBM Cloud Pak (platform).
- We will eventually shift to a different ETL tool but not at the very near future.
- We are also using Fivetran as our data replication tool.
- Familiarity with OOP and scripting tools will be helpful.
- Familiarity with cloud-based technology is helpful.
- Familiarity with concepts in logistics (transportation and warehousing) is a plus since this is DOT’s business.
- DB2 is our current database platform, but we will be switching to Snowflake soon.
Required
5+ years SQL, data warehousing / analytics, data engineeringCreate / Maintain - machine learning / artificial intelligence data pipelinesdesigning scalable data models like handling slowly changing dimensions (SCDs) and performance tuning.Cleanse / transform dataETL / ELT tools (IBM Cloud Pak, DataStage, Fivetran, Talend, or Informatica)Moving away from DataStage and I believe moving to IBM Cloud Pak)Very important to have DataStage to maintain old jobs and help transition jobs to new platform2+ years of Snowflake (Desired Snowflake Data Engineer Certification)3+ years Python OO programming (also would be useful Java, or C#)2+ years Azure (or similar Cloud with AWS, GCP)Bachelor’s degree in Business Analytics, Computer Science, Mathematics, Statistics, or related field