ETL Developer

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 engineering
• Create/Maintain - machine learning/artificial intelligence data pipelines
• designing scalable data models like handling slowly changing dimensions (SCDs) and performance tuning.
• Cleanse/transform data
• ETL/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 platform
• 2 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