Sonsoft
Sonsoft

60 Sonsoft Datastage Consultant Jobs Hiring Near You

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... No OPT-EAD & H1B Consultants please. * Please mention your Visa Status in your email or resume

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... At least 5 years of experience in technology consulting, enterprise and solutions architecture and ...

Showing results 41-60

Sonsoft Jobs Information

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

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.

Infographic showing various Datastage Consultant job openings at Sonsoft in the United States as of May 2026, with employment types broken down into 94% Full Time, and 6% Contract. Highlights an 100% Physical job distribution.
Datastage Developer

Full-time

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

Preferred
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
Experience in Financial domain
Experience and desire to work in a Global delivery environment

Qualifications

Qualifications Basic
Bachelor's degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
At least 4 years of experience with DW/BI and related tools, understanding of ETL and ELT concepts
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

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