Design, develop and troubleshoot Hadoop-based ETL/ELT solutions using Hive and Pig. Work on DW/BI projects, participate in design and architecture reviews, and support development, build and maintenance activities in a global delivery environment.
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.
Preferred:-
- Knowledge of HADOOP Framework and programming in Hive and Pig tools, Design, Best Practices and troubleshooting
- Understanding of Unix/Linux system, file systems, shell scripting
- Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
- Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
- Ability to work in team in diverse/ multiple stakeholder environment
- Experience in Financial domain
- 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 4 years with Information Technology.
- At least 2 years of experience with DW/BI and related tools, understanding of HADOOP Framework, Hive , Pig and NoSQL
- At least 3 years of experience in Software development life cycle
- At least 2 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks
- At least 2 years of experience in Design and Architecture review
- 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 DW/BI related technologies and HADOOP Framework and Hive and Pig tools - MUST
- At least 2 years of hands on experience in Design, Development & Build activities in HADOOP Framework Projects
** 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.
Similar Jobs
Professional Services • Consulting • Industrial
Contract Hadoop Developer/Admin to design, develop and administer data lake/Hadoop environments. Must have Talend integration experience and relevant certification. 24+ month contract based in Dearborn, IL; pharma experience is a plus.
Top Skills:
Data LakeHadoopTalend
Information Technology • Professional Services • Software • Consulting
Develop and implement data ingestion and asset creation processes on CDH 5; optimize Hadoop performance and availability; build data cleansing, security, profiling, and monitoring processes. Work analytically within a global delivery environment.
Top Skills:
Cdh 5Hadoop
Information Technology • Professional Services • Software • Consulting
Design, develop, and troubleshoot Hadoop-based DW/BI solutions using Hive and Pig. Build ETL/ELT frameworks, perform architecture and design reviews, work across teams in a global delivery model, and apply financial-domain knowledge throughout the software development lifecycle.
Top Skills:
Dw/BiEtl/EltHadoopHiveLinuxNoSQLPigShell ScriptingUnix
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

