DataStage Developer

Cloud Hybrid Technologies LLC; Plano, Northern (TX, KY); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Equal opportunity employer

Job summary

Cloud Hybrid Technologies LLC seeks an experienced ETL/Data Integration Engineer to design and implement data integration solutions using IBM DataStage. You will optimize ETL processes, ensure data quality, and collaborate with cross-functional teams to meet business requirements.

Responsibilities include troubleshooting, maintaining batch jobs, and scripting automation with Shell and SQL, while leveraging Splunk for monitoring and performance tuning in high-volume environments.

Qualifications

• Experience designing and implementing data integration solutions using IBM DataStage.
• Strong data quality and validation skills with high-volume loads.
• Ability to tune performance and troubleshoot ETL processes.
• Ability to document procedures and configurations clearly.
• Familiarity with monitoring tools like Splunk and scripting in Shell/SQL.

Responsibilities

• Develop and implement data integration solutions using IBM DataStage.
• Collaborate with cross-functional teams to ensure successful application delivery.
• Optimize ETL processes to enhance data quality and performance.
• Troubleshoot and resolve issues related to data integration and application functionality.
• Maintain batch jobs and propagate changes across environments per release.
• Work with project teams to discuss issues and provide solutions that meet requirements.
• Set up new jobs from configuration requests; maintain ETL jobs and troubleshoot.
• Identify system enhancements and automation opportunities; document procedures clearly.
• Work in process automation using Shell Scripts and SQL; monitor with Splunk.

Skills

ETL design

Cross-functional collaboration

Troubleshooting

Documentation

Automation

Data Quality

Performance Tuning

SQL

Shell scripting

DataStage

Splunk

Tools

IBM DataStage

Splunk

SQL

Shell scripting

Job description

• Develop and implement data integration solutions using IBM DataStage
• Collaborate with cross-functional teams to ensure successful application delivery
• Optimize ETL processes to enhance data quality and performance
• Troubleshoot and resolve issues related to data integration and application functionality
• Maintain the batch jobs and work with project teams towards propagation of changes to all environments as part of each release.
• Strong experience in Data Quality, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High-Volume Data Loads.
• Work closely with Project teams, QA/BA/SME’s/other teams to discuss & understand issues and to provide solutions to meet business and technical requirements.
• Must have prior experience and working knowledge in some or all activities: troubleshooting, operating, testing, planning and/or configuring in relevant technologies.
• Setting up of new jobs from the configuration request from developers/testers.
• ETL jobs maintenance and troubleshooting.
• Identify and implement system enhancements/improvements and Automation.
• Ability to clearly and concisely document procedures and processes.
• Work in process automation using Shell Scripts and SQL.
• Knowledge on Splunk and other monitoring tools

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract