ETL DataStage Consultant

Immediate need for a talented ETL DataStage Consultant. This is an 18+ month contract opportunity with long-term potential and is located in Dallas, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested. Job ID: 26-04089 Pay Range: $70 - $72/hr. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Requirements and Technology Experience: Key skills: ETL, IBM DataStage, and SQL Demonstrate 5–8+ years of DataStage experience, proficiency in Agile/Scrum methodologies, and job scheduling tools like Autosys or Control‑M. Design, develop, test, and deploy robust ETL solutions using IBM InfoSphere DataStage (v11.x or higher) for banking, risk management, and regulatory reporting, moving high-volume data to data warehouses and data lakes. Create complex DataStage jobs, including Parallel, Server, and Sequence jobs to extract, transform, and load data from source systems. Optimize, troubleshoot, and tune existing ETL jobs for performance and scalability in high-volume environments. Write complex SQL, PL/SQL, or DB2 scripts for data manipulation, validation, and querying across relational databases like Oracle, DB2, and SQL Server. Develop Unix Shell scripts for ETL automation, scheduling, and task management. Collaborate with business analysts, data architects, and stakeholders to gather requirements and translate them into technical ETL specifications. Provide production support by monitoring daily ETL job executions, troubleshooting failures, and conducting root cause analysis. Maintain comprehensive technical documentation for ETL processes, data mappings, and system architecture. Lead junior or offshore developers through guidance, code reviews, and enforcement of ETL best practices. Our client is a leading Financial Industry , we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration. Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. By applying to our jobs, you agree to receive calls, AI‑generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here. #J-18808-Ljbffr Pyramid Consulting