ZipRecruiter

Log In

1

Datastage Consultant Jobs (NOW HIRING)

Sonsoft Inc

Datastage Consultant

Agoura Hills, CA · On-site

Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc

DataStage Consultant

Agoura Hills, CA · On-site

Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs * Knowledge of data loading techniques using Datastage * Develop Datastage Parallel Extender jobs ...

Sonsoft Inc

Datastage Consultant

Agoura Hills, CA

Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc

Datastage Consultant

Plano, TX · On-site

Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc

DataStage Consultant

Agoura Hills, CA · On-site

Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs * Knowledge of data loading techniques using Datastage * Develop Datastage Parallel Extender jobs ...

Sonsoft Inc

Datastage Consultant

Plano, TX · On-site

Strong in Datastage * Strong anatical skills * Expertiese in Data Analysis & Managment ... Experience and desire to work in a management consulting environment that requires regular travel ...

Sonsoft Inc

DataStage Consultant

Pennington, NJ · On-site

Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs * Knowledge of data loading techniques using Datastage * Develop Datastage Parallel Extender jobs ...

Sonsoft Inc

Datastage Consultant

Hartford, CT · On-site

At least 2+ years of experience in ETL design and development using IBM DataStage components - DataStage Designer, DataStage Director, DataStage Administrator and IBM information server. * Experience ...

Sonsoft Inc

Datastage Consultant

Hartford, CT

At least 2+ years of experience in ETL design and development using IBM DataStage components - DataStage Designer, DataStage Director, DataStage Administrator and IBM information server. * Experience ...

Sonsoft Inc

IBM Datastage Consultant

Charlotte, NC · On-site

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 ...

Sonsoft Inc

IBM Datastage Consultant

Charlotte, NC · On-site

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 ...

Sonsoft Inc

IBM Datastage Consultant

Charlotte, NC

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 ...

Sonsoft Inc

IBM Datastage Consultant

Plano, TX · On-site

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 ...

Sonsoft Inc

Datastage,Consultant (GC--USC)

Plano, TX · On-site

Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc

IBM Datastage Consultant

Agoura Hills, CA · On-site

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 ...

Sonsoft Inc

Datastage,Consultant (GC--USC)

Plano, TX · On-site

Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

next page

Showing results 1-20

All JobsDatastage Consultant Jobs

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:
What are popular job titles related to Datastage Consultant jobs? For Datastage Consultant jobs, the most frequently searched job titles are:
Datastage Consultant jobs near you
Datastage Consultant

Datastage Consultant

Sonsoft Inc

Agoura Hills, CA • On-site

Full-time

Posted 9 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

View All Sonsoft Jobs

Apply