What are the responsibilities and job description for the ETL Developer position at Amtex Systems Inc?
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