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
- ETL/ELT concepts
- Oracle
- DB2
- Autosys
Also useful
- Control-M
- Tivoli
- Unix shell scripting
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 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 & 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 (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 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 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
- ABInitio DeveloperComtech · Washington, DC
- SSIS DeveloperSaxon Global · Hoboken, NJ
- Sr ETL Developer - Full time perm jobSensiple · McLean, VA
- DataStage Senior Developer ( Canadian citizen can apply - we will sponser visa)system canada technologies · Warren, MI
- Informatica developer with Webservices / Power Exchange (Contrat-to-hire)STEM Expert · Herndon, VA · $60 – $65/hr
- ETL Developer, Sr.Quantix SCS · Alameda, CA
More at Sonsoft
All Sonsoft jobsCommon 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, ETL/ELT concepts, Oracle, DB2, Autosys. 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.