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
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
Datastage Analyst
Plano, TX · On-site
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
Datastage Analyst
Plano, TX · On-site
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
DataStage Administrator
Pennington, NJ · On-site
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
DataStage Administrator
Pennington, NJ · On-site
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
Datastage, HP Vertica
Plano, TX · On-site
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
Datastage, HP Vertica
Plano, TX · On-site
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
IBM Datastage Developer / Lead
Pennington, NJ · On-site
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
IBM Datastage Developer / Lead
Pennington, NJ · On-site
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
ETL Datastage Analyst
Pennington, NJ · On-site
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
ETL Datastage Analyst
Pennington, NJ · On-site
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
ETL Datastage Developer / Lead
Newark, DE · On-site
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
ETL Datastage Developer / Lead
Newark, DE · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
IBM Datastage
Plano, TX · On-site
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 ...
IBM Datastage
Plano, TX · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
Datastage Architect
Plano, TX · On-site
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 ...
ETL DataStage Admin Architect
Charlotte, NC · On-site
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
ETL DataStage Admin Architect
Charlotte, NC · On-site
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 ... Experience and desire to work in a management consulting environment that requires regular travel ...
Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development ... Experience and desire to work in a management consulting environment that requires regular travel ...
ETL Datastage Developer
Charlotte, NC · On-site
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
ETL Datastage Developer
Charlotte, NC · On-site
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
Datastage Admin
Houston, TX · On-site
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 ...
Datastage Admin
Houston, TX · On-site
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 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?
| Aspect | Datastage Consultant | Data Warehouse Developer |
|---|---|---|
| Primary Role | Designing, developing, and implementing ETL processes using IBM DataStage | Designing, building, and maintaining data warehouse solutions and schemas |
| Skills & Certifications | IBM DataStage certification, SQL, ETL tools knowledge | Data modeling, SQL, ETL tools, sometimes IBM DataStage |
| Work Environment | Consulting firms, IT departments, project-based | Data teams within organizations, enterprise environments |
| Industry Usage | Common in organizations using IBM DataStage for ETL | Used 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 the most popular jobs at Sonsoft?
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:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
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