ETL DataStage Analyst
- Location
- Pennington, NJ · On-site
- Work authorization
- US citizens or permanent residents only
- Job type
- Full-time
- Level
- Mid-level
- Experience
- 2+ years
- Education
- Bachelor's degree
- Listed
- Yesterday
Skills & highlights for this role
- IBM DataStage
- Oracle
- DB2
- advanced SQL
- Unix shell scripting
Also useful
- Autosys
- Control-M
- Tivoli
- mainframe file structures
How well does your resume fit this job?
Upload your resume to see your score for this Sonsoft role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
- 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 & Requirements
- 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 2 years of experience with DW/BI and related tools, understanding of ETL and ELT concepts
- At least 2 years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
- At least 2 years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
- At least 2 years of experience in software development life cycle
- At least 2 years of experience in DW/BI related technologies and tools - MUST
- At least 2 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 job oppurtunity.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
- No OPT-EAD & H1-B for this position.
- Please mention your email id in your email or resume..
About the Company
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.
From Sonsoft's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this ETL DataStage Analyst role at Sonsoft, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Database Developer jobs- Application Developer-RDBMSIBM · Paramus
- Data & AI Internship Program (She/He/They)Accenture · United States
- Supply Chain Management (JDA Manugistics)TestingXperts · Westchester, IL
- PeopleSoft DeveloperComtech · Arlington, VA
- Senior DataBase developerSensiple · Culver City, CA
- Sr database developer - Must have worked on teradata & DB2 ( Corp to Corp ) - 3 Positionssystem canada technologies · New York, NY
Common questions
Where is the ETL DataStage Analyst job at Sonsoft located?
This ETL DataStage Analyst position at Sonsoft is located in Pennington, NJ (On-site). Always check Sonsoft's application page for specific state eligibility or relocation policies.
What qualifications are required for ETL DataStage Analyst at Sonsoft?
For the ETL DataStage Analyst role, Sonsoft highlights 2+ years of relevant experience; a bachelor's degree; experience with IBM DataStage, Oracle, DB2, advanced SQL, Unix shell scripting. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the ETL DataStage Analyst position at Sonsoft?
This listing links directly to Sonsoft's SmartRecruiters application page. You can apply directly on Sonsoft's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.