Senior Data Engineer

Position:ETL Datastage Developer
Location: Cincinnati, Ohio
Duration: Contract
Job ID: 178780

Job Overview:
We are seeking a highly skilled and experienced Senior Data Engineer to design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications. The ideal candidate will collaborate with business and technology teams to deliver high-quality, performant, and reliable data integration solutions aligned with enterprise architecture standards. This role requires extensive experience working with multiple source and target systems, including Oracle, DB2, Snowflake, flat files, cloud storage, and structured, semi-structured, and unstructured data sources. The candidate should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, and PL/SQL.

Responsibilities:

• Design, develop, test, deploy, and support complex ETL/ELT solutions using IBM DataStage and enterprise data pipelines.
• Develop reusable ETL frameworks using IBM DataStage, parameterized jobs, metadata-driven solutions, and automated data processing workflows.
• Analyze business and technical requirements and translate them into scalable ETL designs and data integration solutions.
• Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes using DataStage.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
• Design and develop cloud-native data pipelines and migrate data from on-premises systems to Snowflake.
• Optimize data movement processes and support data warehouse, data lake, and Lakehouse platforms.
• Enable enterprise analytics and reporting solutions.
• Perform performance tuning, root cause analysis, production support, and incident management.
• Collaborate with stakeholders to understand business needs and deliver solutions independently after training.

Qualifications:

• Strong hands-on experience with IBM DataStage 11.7 or above, including Parallel Jobs, Sequencers, Parameter Sets, Job Monitoring, Administration, and Performance Tuning.
• Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
• Strong experience with Snowflake, including Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing, and Query Performance Optimization.
• Strong Unix/Linux Shell Scripting skills for process automation, file handling, batch scheduling, operational support, and production troubleshooting.
• Experience creating high-performance batch, incremental, and CDC-based data pipelines for large-volume data processing.
• Strong understanding of ETL/ELT architecture, Data Warehousing, Dimensional Modeling, Data Lakes, and Data Lakehouse architectures.
• Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices.
• 8-10 years of engineering experience (minimum 6 years required).
• Bachelor’s degree in computer engineering, computer science, or a related discipline.

Preferred Qualifications:

• CI/CD experience.
• Performance optimization in Snowflake.
• Previous payments industry experience.

Interview Process:

• Two rounds, panel style interviews.
• Interviews expected to start next week for qualified candidates.

About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $55 - $70/hour

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at Show phone number. To report any concerns, please email us at View email address on jobs.pinnacle1.com

During the hiring process, we may use artificial intelligence (AI) tools to assist in evaluating information related to your application. These tools may help analyze job-related qualifications or assist recruiters in reviewing applications and interview responses. AI-generated information is one factor considered in our hiring process. Final employment decisions are made by qualified hiring personnel and are not based solely on AI-generated recommendations.