Datastage

Reposted 20 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 and Information Server. Integrate data from mainframes, relational DBs, Netezza, Teradata, flat files and HDFS. Apply DW principles, perform production support, tune performance, and work with scheduling tools (Zeke/Autosys/Control-M).
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

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

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

 ** U.S. Citizens and those who are authorized to work independently in the United States 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 GC-EAD,& TN  can apply.
3.No  H4-EAD  L2-EAD  OPT-EAD, H1B  candidates please.
4.Please mention your Visa Status in your email or resume.

Skills Required

  • At least 2+ years ETL design and development using IBM DataStage (Designer, Director, Administrator) and IBM Information Server
  • Experience implementing performance enhancements in DataStage jobs (reduced runtime/CPU/memory management)
  • Hands-on integration from heterogeneous sources: 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, dimensional modeling (star/snowflake), OLTP and OLAP
  • Knowledge of other ETL technologies (Abinitio, SSIS)
  • At least 2 years experience in software development life cycle
  • At least 2 years experience translating functional/non-functional requirements to system requirements
  • Experience and understanding of production support and performance engineering
  • Bachelor's degree or foreign equivalent required (or progressive experience in lieu of education)
  • Authorized to work in the United States; employer unable to sponsor visas
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

Cloudera Logo Cloudera

Solutions Engineer

Artificial Intelligence • Cloud • Software • Big Data Analytics
In-Office or Remote
6 Locations
3092 Employees
150K-180K Annually

Citizens Logo Citizens

Data Engineer

Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
In-Office or Remote
2 Locations
17000 Employees
105K-158K Annually

Citizens Logo Citizens

Senior Data Engineer

Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
In-Office or Remote
2 Locations
17000 Employees

EROS Technologies Inc. Logo EROS Technologies Inc.

Talend Developer

Artificial Intelligence • HR Tech • Information Technology • Consulting
In-Office
Farmington, CT, USA
125 Employees

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
Artificial Intelligence • Fintech • Software
New York, New York
9 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