Datastage Analyst
- Location
- Charlotte, NC
- 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 SQL and PL/SQL
- data modeling
Also useful
- DB2
- Unix shell scripting
- Autosys
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
- 2+ years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
- 2+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
- 2+ years of experience in software development life cycle
- 2+ years of experience in DW/BI related technologies and tools – MUST
- 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
- 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
- Extensive Experience in Oracle SQL, PL/SQL.
- Good experience with database development tools (Oracle, Toad)
- Good understanding partitioning, indexes, Bitmap indexes, triggers, materialized views.
- Good experience in Query tuning, reading explain plans.
- Experience in Financial domain
- Ability to work in team environment and client interfacing skills.
- Strong analytical skills
- Experience and desire to work in a Global delivery environment
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
- 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 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- SQL DeveloperSaxon Global · Charlotte, NC
- Informatica DeveloperSensiple · Charlotte, NC
- Siebel / Oracle Developer ( Jacksonville FL / Charlotte NC )system canada technologies · Charlotte, NC
- Sr Oracle Pl/Sql, Forms & Reports DeveloperIdealforce · Phoenix, AZ
- Data Reporting Analyst IIISTEM Expert · Detroit, MI
- CKAN developerMapjects · Washington, DC
Common questions
Where is the Datastage Analyst job at Sonsoft located?
This Datastage Analyst position at Sonsoft is located in Charlotte, NC. Always check Sonsoft's application page for specific state eligibility or relocation policies.
What qualifications are required for Datastage Analyst at Sonsoft?
For the Datastage Analyst role, Sonsoft highlights 2+ years of relevant experience; a bachelor's degree; experience with IBM DataStage, Oracle SQL and PL/SQL, data modeling. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the 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.