Design and deliver Ab Initio ETL solutions: develop PDL scripts, handle varied data formats (including mainframe), perform performance tuning and troubleshooting, work with UNIX/AIX and DB2, collaborate with stakeholders, and support agile/CI delivery. Big Data and financial domain exposure preferred.
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:-
- Skills: – Ab initio ETL, UNIX shell scripting , DB2
- Must have strong hands on experience in the design and delivery of ETL solutions using Ab initio
- Hands on experience and knowledge in PDL scripting ( Parameter definition language)
- Experience using Ab initio continuous flow is a strong plus
- Experience handling different data file formats including mainframe files
- Knowledge and exposure to Ab initio Metaprogramming
- Good knowledge in UNIX AIX operating system and shell scripting
- Should have worked on Ab initio serial/multi file data sets and experience with Ab initio performance tuning and troubleshooting.
- Experience in agile project delivery and continuous integration is a plus
- Must have ability to analyze and understand ETL applications with complex source data integration
- Should have worked on large data sets and experience with performance tuning and troubleshooting
- Should be a strong communicator and be able to work independently with minimum involvement from client SMEs
- Should be able to work in team in diverse/ multiple stakeholder environment
Preferred
- Exposure to Big Data is preferred
- Experience to Financial domain is preferred
- Experience and desire to work in a Global delivery environment
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 5 years of Design and hands on development experience in Ab initio data warehousing ETL tool , UNIX shell scripting.
** 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 Visa Status in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Design and deliver ETL solutions using Ab Initio, write PDL scripts, handle varied file formats (including mainframe), perform Ab Initio performance tuning and troubleshooting, use UNIX/AIX shell scripting and DB2, work with large datasets, and collaborate with stakeholders. Agile/CI, Big Data, and financial domain experience are preferred.
Top Skills:
Ab InitioAb Initio Continuous FlowAb Initio MetaprogrammingAixDb2Pdl (Parameter Definition Language)Shell ScriptingUnix
Information Technology • Professional Services • Software • Consulting
Design and deliver Ab Initio ETL solutions, develop PDL scripts, handle mainframe and multi-file datasets, perform performance tuning and troubleshooting, use UNIX AIX shell scripting and DB2, analyze complex source integrations, work in Agile/CI teams and communicate with stakeholders.
Top Skills:
Ab InitioAb Initio MetaprogrammingDb2Mainframe File FormatsPdl (Parameter Definition Language)Serial/Multi-File Dataset HandlingUnix Shell Scripting (Aix)
Beauty • Robotics • Design • Appliances • Manufacturing
The Director, Merchandising will develop and lead the merchandising strategy for Shark and Ninja products, collaborating with various teams to ensure successful product launches and brand alignment, while establishing a strong merchandising function.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

