ETL Datastage Developer Job at Amtex Systems Inc, Columbus, OH

c2dmUUtRVUdxWGZlTHBPQmNuY1ArUTJFQ2c9PQ==
  • Amtex Systems Inc
  • Columbus, OH

Job Description

Title: DataStage ETL Lead Developer

Duration: 3-month contract to hire

Location: Onsite 4 days a week in Columbus Ohio

We are seeking a skilled DataStage ETL Lead Developer with experience in Python scripting and cloud-based data platforms . This role will be responsible for designing, developing, and maintaining ETL processes to support scalable and secure data pipelines across enterprise data systems.

Key Responsibilities:

  • Design and develop ETL workflows using IBM InfoSphere DataStage .
  • Build scalable data ingestion, transformation, and integration solutions.
  • Develop automation scripts using Python to optimize data processing and ETL jobs.
  • Deploy and support ETL solutions in cloud environments (e.g., AWS, Azure, GCP).
  • Collaborate with data architects, analysts, and other developers to ensure data quality and performance.
  • Troubleshoot and optimize existing ETL processes.
  • Document technical designs, processes, and data flows.

Required Qualifications:

  • 4+ years of hands-on experience with IBM DataStage .
  • Proficiency in Python for scripting and data transformation tasks.
  • Experience with cloud platforms such as AWS , Azure , or GCP .
  • Strong understanding of data warehousing , data modeling , and SQL .
  • Experience working with large datasets in structured and semi-structured formats (e.g., CSV, JSON, Parquet).
  • Strong problem-solving and debugging skills.

Preferred Qualifications:

  • Experience integrating DataStage with cloud-native data services (e.g., S3, Azure Data Lake, BigQuery).
  • Familiarity with CI/CD pipelines for data workflows.
  • Knowledge of DevOps or infrastructure-as-code tools (e.g., Terraform, CloudFormation).
  • Experience with data governance, metadata management, and data lineage tools
  • Preferred:
  • IBM DataStage11.7, Zena, Unix, Shell Scripting, Databases - Db2, SQL, Kafka, SoapUI, IBM Data replication
  • Experience calling SOAP/RestAPI's from DataStage.
  • MettleCI for DataStage Code deployment.
  • Infogix for system balancing.

Job Tags

Contract work,

Similar Jobs

Physicians Rehab Solution

Part-Time COTA with Gulf Coast Orthopedics Job at Physicians Rehab Solution

 ...Gulf Coast Orthopedics Physical Therapy (GCO) is seeking Part-Time (PT) Certified Occupational Therapy Assistant- Hand Experience...  ...Licensed Occupational Therapists provide integrated, state-of-the-art therapy care and rehabilitation to our patients. As a part of... 

Elevanta

Meeting Planner Job at Elevanta

 ...event. Manage complete financial details of an event during the planning process to ensure revenue and expense items are within budget....  ...beverage discounts, audio visual discounts, parking, meeting space, etc. Order gifts, awards, and other giveaways Assist... 

ProKatchers LLC

Research Assistant Job at ProKatchers LLC

 ...Job Title : Research Associate ( Research Assistant ) Location : South San Francisco - 94080 Duration : 12 Months Job Description : B.S. in Biology, Biochemistry, Molecular Biology, or a related discipline, with 1+ years of industry experience in pharmaceutical... 

Prosum

Senior Project Manager, Business Applications and Financial Systems Job at Prosum

 ...Program or project management experience in delivering business applications, such as HR systems, Financial systems, and Marketing systems Experience with ERP projects within Healthcare Systems Experience with HR processes and terminology RFI and RFP vendor... 

CTA Construction Managers

Project Superintendent Job at CTA Construction Managers

 ...CTA Construction Managers is an award-winning, ENR top 100 Green Contractor based in Waltham, MA.We are currently seeking Project Superintendents looking for a career opportunity to construct large scale, complex, state of the art, LEED certified buildings throughout...