Datastage Consultant

Reposted 10 Days Ago
Be an Early Applicant
Hartford, CT, USA
In-Office
Junior
Information Technology • Professional Services • Software • Consulting
The Role
Design and develop ETL solutions using IBM DataStage components, optimize job performance, integrate data from heterogeneous sources (mainframe, Netezza, Teradata, HDFS, flat files), use Unix shell scripting and SQL, work with schedulers, support production and translate requirements to system design while interfacing with clients.
Summary Generated by Built In
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 2+ years of experience in ETL design and development using IBM DataStage components - DataStage Designer, DataStage Director, DataStage Administrator and IBM information server.
  • Experience in implementing performance enhancements in existing DataStage jobs for reduced runtime/CPU time/memory management etc.
  • Hands-on experience in integrating data from heterogeneous data sources spanning across mainframes, relational databases, appliances like Netezza, Teradata, flat files, HDFS etc. Strong Unix shell scripting and SQL knowledge.
  • Exposure to scheduling tools like Zeke, Autosys, Control-M.
  • Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema, OLTP, OLAP and Data Warehousing concepts).
  • Knowledge of other ETL technologies (Abinitio, SSIS) will be a plus.
  • At least 2 years of experience in software development life cycle.
  • At least 2 years of experience in translating functional/non-functional requirements to system requirements.
  • Experience and understanding of in Production support and performance engineering.
  • Technical Skills.
  • Ability to work in team environment and client interfacing skills.
  • Excellent Communication and Analytical skills

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 2 years of experience within the Information Technologies.

Additional Information

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

Skills Required

  • At least 2+ years of experience in ETL design and development using IBM DataStage components (Designer, Director, Administrator) and IBM Information Server
  • Experience implementing performance enhancements in DataStage jobs to reduce runtime, CPU, and manage memory
  • Hands-on experience integrating data from mainframes, relational databases, Netezza, Teradata, flat files and HDFS
  • Strong Unix shell scripting skills
  • Strong SQL knowledge
  • Exposure to scheduling tools such as Zeke, Autosys, Control-M
  • Thorough understanding of data warehousing principles (fact/dimension tables, star/snowflake schemas, OLTP/OLAP)
  • Knowledge of other ETL technologies (Abinitio, SSIS)
  • At least 2 years of experience in software development lifecycle (SDLC)
  • At least 2 years of experience translating functional/non-functional requirements to system requirements
  • Experience with production support and performance engineering
  • Ability to work in a team environment and client interfacing skills; excellent communication and analytical skills
  • Bachelor's degree or equivalent (or three years progressive experience in lieu of each year of education)
  • Eligibility: Only US Citizen, Green Card Holder, GC-EAD, H4-EAD or L2-EAD may apply (No OPT-EAD, H1B or TN candidates)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Hartford, CT, USA
87 Employees

PwC Logo PwC

Consultant

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Remote or Hybrid
US
370000 Employees
63K-140K Annually

General Motors Logo General Motors

Software Engineer

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
160K-246K Annually

General Motors Logo General Motors

Finance Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
112K-175K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account