PTR Global
ETL Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an ETL Developer with 8–10 years of experience, focusing on IBM DataStage 11.7, Snowflake, and advanced SQL. It is a 12-month hybrid contract in Cincinnati, OH, with a pay rate of “$X/hour.”
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
August 7, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
Cincinnati, OH
-
🧠 - Skills detailed
#Snowflake #Data Pipeline #Scala #Data Lake #SQL Server #JSON (JavaScript Object Notation) #Agile #Shell Scripting #Data Engineering #Storage #DataStage #Computer Science #Metadata #Oracle #"ETL (Extract #Transform #Load)" #XML (eXtensible Markup Language) #DevOps #Data Warehouse #Deployment #Scripting #SQL (Structured Query Language) #GIT #Linux #Data Processing #Unix #Cloud #Batch #Migration #Data Integration
Role description
🚨 IBM DataStage ETL Developer | Hybrid – Cincinnati, OH
📍 Location: Cincinnati, OH (8500 Governors Hill Dr.)
🏢 Schedule: Hybrid | Monday–Friday | 8:00 AM – 5:00 PM ET
📄 Job Type: W2 Fulltime Contract
⏳ Duration: 12 Months (Possible Extension)
❌ No C2C
A leading financial services organization is seeking an experienced IBM DataStage ETL Developer to design, develop, and support enterprise-scale data integration solutions. This role focuses on building high-performance ETL/ELT pipelines, optimizing data movement, and supporting modern data warehouse, data lake, and Snowflake environments.
Key Responsibilities
Design, develop, test, and support scalable ETL/ELT solutions using IBM DataStage 11.7
• Build and maintain enterprise data pipelines for mission-critical applications.
• Develop reusable ETL frameworks, parameterized jobs, and metadata-driven solutions.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage.
• Develop and optimize SQL and PL/SQL code for high-performance data processing.
• Design cloud-native data pipelines and support migrations from on-premises platforms to Snowflake.
• Automate batch processes and operational workflows using Unix/Linux Shell Scripting.
• Support production deployments, performance tuning, troubleshooting, and root cause analysis.
• Collaborate with business and technology teams in an Agile environment to deliver scalable data integration solutions.
Required Qualifications
✅ 8–10 years of ETL/Data Engineering experience.
✅ Strong hands-on experience with IBM DataStage 11.7 or higher.
✅ Advanced SQL and PL/SQL development experience with Oracle and DB2.
✅ Experience designing enterprise ETL/ELT solutions and reusable DataStage frameworks.
✅ Strong experience with Snowflake, including Streams, Tasks, Dynamic Tables, Secure Views, Data Sharing, and query optimization.
✅ Experience building cloud-native data pipelines and migrating data to Snowflake.
✅ Strong Unix/Linux Shell Scripting skills.
✅ Experience with batch processing, incremental loads, and CDC-based data pipelines.
✅ Solid understanding of Data Warehousing, Dimensional Modeling, Data Lakes, and Lakehouse architectures.
✅ Experience with Git, CI/CD, Agile, and DevOps practices.
Preferred Qualifications
⭐ Experience supporting large-scale enterprise data integration platforms.
⭐ Strong production support, incident management, and performance tuning experience.⭐
Experience working with structured, semi-structured, and unstructured data.⭐ Bachelor's degree in Computer Science, Computer Engineering, or a related field.
Top Skills
IBM DataStage 11.7+
Snowflake
Oracle & DB2 (SQL/PLSQL)
Unix/Linux Shell Scripting
ETL/ELT Data Engineering
🚨 IBM DataStage ETL Developer | Hybrid – Cincinnati, OH
📍 Location: Cincinnati, OH (8500 Governors Hill Dr.)
🏢 Schedule: Hybrid | Monday–Friday | 8:00 AM – 5:00 PM ET
📄 Job Type: W2 Fulltime Contract
⏳ Duration: 12 Months (Possible Extension)
❌ No C2C
A leading financial services organization is seeking an experienced IBM DataStage ETL Developer to design, develop, and support enterprise-scale data integration solutions. This role focuses on building high-performance ETL/ELT pipelines, optimizing data movement, and supporting modern data warehouse, data lake, and Snowflake environments.
Key Responsibilities
Design, develop, test, and support scalable ETL/ELT solutions using IBM DataStage 11.7
• Build and maintain enterprise data pipelines for mission-critical applications.
• Develop reusable ETL frameworks, parameterized jobs, and metadata-driven solutions.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage.
• Develop and optimize SQL and PL/SQL code for high-performance data processing.
• Design cloud-native data pipelines and support migrations from on-premises platforms to Snowflake.
• Automate batch processes and operational workflows using Unix/Linux Shell Scripting.
• Support production deployments, performance tuning, troubleshooting, and root cause analysis.
• Collaborate with business and technology teams in an Agile environment to deliver scalable data integration solutions.
Required Qualifications
✅ 8–10 years of ETL/Data Engineering experience.
✅ Strong hands-on experience with IBM DataStage 11.7 or higher.
✅ Advanced SQL and PL/SQL development experience with Oracle and DB2.
✅ Experience designing enterprise ETL/ELT solutions and reusable DataStage frameworks.
✅ Strong experience with Snowflake, including Streams, Tasks, Dynamic Tables, Secure Views, Data Sharing, and query optimization.
✅ Experience building cloud-native data pipelines and migrating data to Snowflake.
✅ Strong Unix/Linux Shell Scripting skills.
✅ Experience with batch processing, incremental loads, and CDC-based data pipelines.
✅ Solid understanding of Data Warehousing, Dimensional Modeling, Data Lakes, and Lakehouse architectures.
✅ Experience with Git, CI/CD, Agile, and DevOps practices.
Preferred Qualifications
⭐ Experience supporting large-scale enterprise data integration platforms.
⭐ Strong production support, incident management, and performance tuning experience.⭐
Experience working with structured, semi-structured, and unstructured data.⭐ Bachelor's degree in Computer Science, Computer Engineering, or a related field.
Top Skills
IBM DataStage 11.7+
Snowflake
Oracle & DB2 (SQL/PLSQL)
Unix/Linux Shell Scripting
ETL/ELT Data Engineering
