ETL - Datastage Lead Developer Job at Cloud Analytics Technologies LLC, Columbus, OH

K0N2YmdTQzV1SU54Yk5lZUUwOGw1WXdLSEE9PQ==
  • Cloud Analytics Technologies LLC
  • Columbus, OH

Job Description

Job Details


Position Summary

We are seeking a highly skilled  DataStage Lead with Python to join our IT Corporate Finance Regulatory Reporting team. This role will initially focus on IBM DataStage for ETL processes but will transition to Python development over the next 1 2 years. The ideal candidate will have strong experience in both technologies and a passion for building efficient, compliant data solutions.

Key Responsibilities
  • Lead the design, development, and maintenance of ETL processes using IBM DataStage and Python.
  • Collaborate with data architects, business analysts, and compliance teams to create and maintain technical design documents.
  • Develop and optimize SQL queries and scripts for Snowflake and other relational databases.
  • Write and maintain Unix shell scripts to support automation and data processing tasks.
  • Manage and resolve incidents promptly to minimize business impact.
  • Participate in change management processes, including planning, documentation, and execution.
  • Provide technical insights during project and team meetings.
  • Ensure compliance with internal standards, security policies, and regulatory requirements.
  • Mentor junior team members and provide technical leadership.
Required Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • 5+ years of experience in ETL development with IBM DataStage and Python.
  • Strong experience with Snowflake or other cloud-based data platforms.
  • Proficiency in Unix/Linux shell scripting.
  • Solid understanding of relational databases and SQL.
  • Experience with incident and change management processes (ITIL framework preferred).
  • Excellent problem-solving, analytical, and communication skills.
  • Ability to work onsite 4 days a week in Columbus, OH.
Preferred Qualifications
  • Experience in banking or financial services industry.
  • Familiarity with Agile methodologies and DevOps practices.
  • Knowledge of data governance and data quality best practices.

Job Tags

Similar Jobs

UMass Memorial Health

Patient Care Technician I-Inpatient 6 East, 32 Hour, Days Job at UMass Memorial Health

 ...Scheduled Hours: 7a-3:30p Shift: 1 - Day Shift, 8 Hours (United States of America)...  ...in restraints in accordance with training and education as directed. 4. Assists patient...  ...specimens for transport to lab. 9. Phlebotomy in certain locations. 10. Performs other... 

WestRock

Journeyman Electrician Job at WestRock

Smurfit Westrock (NYSE:SW) is a global leader in sustainable paper and packaging solutions. We are materials scientists, packaging designers, mechanical engineers and manufacturing experts with a shared purpose: Innovate Boldly. Package Sustainably. Guided by our values...

Washington University in St Louis

Administrative Professional - Pathology and Immunology Job at Washington University in St Louis

Scheduled Hours 40 Position Summary Assists department or division head in administration of department financial and operating procedures and programs. Coordinates and manages human resources, purchasing, and financial management for the department or division...

One World Parts, LLC

Automotive Parts Warehouse - ORDER PICKER Job at One World Parts, LLC

 ...- is seeking a motivated and detail-oriented Automotive Parts Warehouse Order Picker to join our dynamic team. As a Order Picker, you will...  ...once every 3-4 weeks (7:30AM-approx. 3PM)* Annual Inventory Weekend: Be part of our big event! (Friday night & Saturday)* All our... 

Openkyber

Salesforce Director of Technology Job at Openkyber

 ...clear IT scope and execution plans. Technology & Platform Acumen: Experience with SFDC programs and coordinating changes across CRM, finance systems, and data/reporting platforms to support GTM and financial use cases. Governance & Stakeholder Management: Demonstrated...