1

Datastage Consultant Jobs (NOW HIRING)

At least 5 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks * At least 4 years of experience in IBM Datastage Skills * At least 3 years ...

At least 5 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks * At least 4 years of experience in IBM Datastage Skills * At least 3 years ...

At least 5 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks * At least 4 years of experience in IBM Datastage Skills * At least 3 years ...

At least 5 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks * At least 4 years of experience in IBM Datastage Skills * At least 3 years ...

At least 5 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks * At least 4 years of experience in IBM Datastage Skills * At least 3 years ...

Company Description Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of ...

Title: ETL DataStage Consultant. Location: Oakland, CA Duration: 6+ Months Contract Interview: Phone and Skype(Need local) TOP 2 REQUIREMENTS: DataStage PGP POSITION SUMMARY: Client is charged with ...

Company Description Xinnovit is a global leader in technology consulting, outsourcing, and ... Create ETL jobs using IBM DataStage and QualityStage Analyze and prepare reports on data systems ...

next page

Showing results 1-20

Datastage Consultant information

See salary details

$47

$62

$76

How much do datastage consultant jobs pay per hour?

As of Jun 17, 2026, the average hourly pay for datastage consultant in the United States is $62.50, according to ZipRecruiter salary data. Most workers in this role earn between $50.48 and $74.52 per hour, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive as a Datastage Consultant, and why are they important?

To thrive as a Datastage Consultant, you need expertise in ETL processes, data warehousing concepts, and strong SQL skills, typically supported by a degree in computer science or a related field. Proficiency in IBM InfoSphere DataStage, database management systems like Oracle or SQL Server, and relevant certifications such as IBM Certified Solution Developer are highly valuable. Strong analytical thinking, problem-solving abilities, and effective communication are crucial soft skills for translating business requirements into technical solutions. These skills ensure accurate, efficient data integration and enable the delivery of high-quality solutions that meet client needs.

What does a Datastage Consultant do?

A Datastage Consultant specializes in using IBM DataStage, an ETL (Extract, Transform, Load) tool, to help organizations manage and integrate large amounts of data across multiple sources. They design, develop, and implement data warehousing solutions to ensure data is efficiently processed and made available for analytics and reporting. Their responsibilities typically include gathering business requirements, creating ETL jobs, optimizing data flows, troubleshooting issues, and ensuring data quality and integrity.

What is the difference between Datastage Consultant vs Data Warehouse Developer?

AspectDatastage ConsultantData Warehouse Developer
Primary RoleDesigning, developing, and implementing ETL processes using IBM DataStageDesigning, building, and maintaining data warehouse solutions and schemas
Skills & CertificationsIBM DataStage certification, SQL, ETL tools knowledgeData modeling, SQL, ETL tools, sometimes IBM DataStage
Work EnvironmentConsulting firms, IT departments, project-basedData teams within organizations, enterprise environments
Industry UsageCommon in organizations using IBM DataStage for ETLUsed across industries for data warehousing and BI

While both roles involve data integration, a Datastage Consultant specializes in implementing ETL processes with IBM DataStage, whereas a Data Warehouse Developer focuses on designing and building data warehouses, often using various tools including DataStage. The roles often overlap but differ in scope and primary focus.

What are some typical challenges Datastage Consultants face when migrating legacy ETL processes to modern platforms?

Datastage Consultants often encounter challenges such as handling incompatible data formats, ensuring data quality during migration, and minimizing downtime for critical business operations. Legacy systems may have undocumented or complex data flows, requiring thorough analysis and testing to ensure successful replication on new platforms. Effective communication with business users and IT teams is essential to address unexpected issues and validate that migrated processes meet organizational requirements.
More about Datastage Consultant jobs
Who are the top companies hiring for Datastage Consultant jobs? The top employers for Datastage Consultant jobs are:
What job categories do people searching Datastage Consultant jobs look for? The top searched job categories for Datastage Consultant jobs are:
Datastage,Consultant (GC--USC)

Datastage,Consultant (GC--USC)

Sonsoft Inc

Plano, TX

Full-time

Posted 20 days ago


Job description

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, => Software Consultancy and Information Technology Enabled Services.

Job Description


Job Description:-

  • At least 4 years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
  • At least 4 years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
  • At least 3 years of experience in software development life cycle
  • At least 3 years of experience in DW/BI related technologies and tools - MUST
  • At least 3 years of experience in Project life cycle activities on DW/BI development and maintenance projects
  • At least 2 years of experience in Design and Architecture review
  • Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs
  • Knowledge of data loading techniques using Datastage
  • Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc
  • Using Datastage Director for running and monitoring the jobs.
  • Created Datastage sequences to run the batch jobs.
  • Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs
  • Understanding of Unix/Linux system, file systems, shell scripting
  • Strong understanding of scheduling tools such as Autosys, Control- M, Tivoli etc.
  • Good knowledge on MF file structures along with RDBMS.
  • Provides expertise in determining the strategic technical direction and system architecture for initiatives.
  • Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
  • Strong analytical skills
  • Extensive Experience in Oracle SQL, PL/SQL.
  • Good experience with database development tools (Oracle, Toad)
  • Good understanding partitioning, indexes, Bitmap indexes, triggers, materialized views.
  • Good experience in Query tuning, reading explain plans.
  • Experience in Financial domain
  • Experience and desire to work in a Global delivery environment
Qualifications

Basic Qualifications :-
Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
At least 4 years of experience within the Information Technologies.

Additional Information

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.



Sonsoft logo

About Sonsoft

Sourced by ZipRecruiter

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Industry

It services

Company size

51 - 200 Employees

Headquarters location

Alpharetta, GA, US

Year founded

2007