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, develop and optimize ETL jobs using IBM DataStage/Information Server. Integrate heterogeneous sources (mainframe, RDBMS, Netezza, Teradata, HDFS), implement performance improvements, support production, schedule jobs (Zeke/Autosys/Control-M), translate requirements, and collaborate with clients and team members following SDLC.
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

  • 2+ years ETL design and development using IBM DataStage components (DataStage Designer, Director, Administrator) and IBM Information Server.
  • Experience implementing performance enhancements in DataStage jobs (runtime/CPU/memory optimization).
  • Hands-on experience integrating data from mainframes, relational databases, Netezza, Teradata, flat files, HDFS.
  • Strong Unix shell scripting and 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 experience in software development life cycle (SDLC) and translating functional/non-functional requirements to system requirements.
  • Experience in production support and performance engineering.
  • Bachelor's degree or foreign equivalent (or equivalent progressive experience).
  • Authorized to work in the U.S. (US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD).
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

Applied Systems Logo Applied Systems

Automation Engineer

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
United States
3079 Employees
80K-160K Annually

Applied Systems Logo Applied Systems

Senior Network Engineer

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
2 Locations
3079 Employees
90K-140K Annually

Applied Systems Logo Applied Systems

Automation Engineer

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
United States
3079 Employees
70K-125K 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