Full-Time

Solution Integration

ETL Consultant II

Posted on 10/31/2025

Jonas Software

Jonas Software

1,001-5,000 employees

Long-term ownership of vertical software

No salary listed

Bengaluru, Karnataka, India

Hybrid

Hybrid model; occasional travel of 5% or more.

Category
Data & Analytics (1)
Requirements
  • Overall 8-10 years of IT industry experience
  • Undergraduate / Graduate in Computer Science or Computer Applications such as B. Sc. / B.C.A. / B. Tech. / B. E. / M. Sc. / M. Tech. / M. E. / M.C.A.
  • Strong experience in understanding business requirements and converting those requirements into detailed functional and technical specifications
  • Minimum 4 years’ experience with Kettle ETL tool with knowledge on Metadata Injection, Kettle DB logging, Carte.
  • Minimum 4 years’ experience in writing PL/SQL or T-SQL programming and queries on Oracle / SQL Server
  • Strong knowledge on RDBMS concept and OLTP system architecture.
  • Minimum 2 years’ experience in writing shell scripts on UNIX Sun Solaris
  • Strong knowledge on source code control mechanism on any tool. Knowledge on GIT / BitBucket is added advantage.
  • Strong knowledge of XML and JSON structures and Jenkins.
  • Experience of job scheduling and working knowledge on at least one 3rd party scheduler
  • Ability to perform data research and root cause analysis on data issues/discrepancies.
  • Good communication skills including verbal and writing skills
  • Travel availability for traveling (5% or more)
Responsibilities
  • Single point of contact (SPOC) for the technical implementation.
  • End to end leading of projects (with a small team)
  • Focus on design aspects performance, re-startablity, logging, error handling, security for both on-premises and cloud customers
  • Getting the broader picture of the project and contributing accordingly.
  • Thought process to build reusable artefacts and to make use of them to reduce development / testing / deployment / maintenance efforts.
  • Ability to work with multiple customers at the same time.
  • Adaptability to work in SDLC, Iterative and Agile methodology.
  • Interact with onsite team member to understand project requirements and goals.
  • Report progress status to team manager and/or client for various projects.
  • Assist in developing detailed business and technical specifications based on project requirements from client and other team members.
  • Assist in turning business and technical specifications into data extraction/load programs.
  • Program ETL tool with business rules to be applied to data from source input to target data repository.
  • Develop and assist in implementing system and unit test programs ensuring correct application of transformation logic from source to target.
  • Develop and assist in automating data extraction/load programs to run on regular schedule.
  • Assist in managing daily, weekly, and monthly data operations and scheduled processes.
  • Perform data conversion, quality, and integrity checks for all programs/processes
  • In addition to these skills, the individual needs to be skilled in business analysis and knowledge acquisition.
  • An integration consultant interacts with clients (both business and technical personnel) on a constant basis. Hence, it is necessary that an Integration Consultant have extremely good communication skills, should be able to listen carefully to clients and facilitate information gathering sessions.
Desired Qualifications
  • Experience in Banking or Financial Industry is preferred
  • Experience in SSRS reports development is preferred
  • Working knowledge of Python scripting is preferred
  • Hands-on experience in AWS services like PostgreSQL, Aurora, Lambda is preferred

Jonas Software manages a decentralized portfolio of over 160 independent software companies across 40 different industries. The company operates by acquiring niche software businesses and providing them with financial security and strategic guidance while allowing them to keep their original branding and management teams. Unlike competitors that often restructure or resell their acquisitions, Jonas uses a "buy-and-hold-forever" strategy to ensure long-term stability for its brands. Its goal is to foster growth within specific vertical markets by maintaining a permanent home for specialized software businesses.

Company Size

1,001-5,000

Company Stage

N/A

Total Funding

N/A

Headquarters

Toronto, Canada

Founded

1990

Simplify Jobs

Simplify's Take

What believers are saying

  • Acquired Aava Software in 2025 to expand ERP and MES in manufacturing.
  • Grew to 200+ companies by 2025 through accelerated acquisitions like Wheatley and OnTap Data.
  • Parent Constellation Software offers $5B revenue and 30,000 employees for global scale.

What critics are saying

  • EU regulators force Constellation divestiture of Jonas in 12-24 months over antitrust.
  • Sage Group erodes 15-20% UK market share from Wheatley and Rock Solid by Q1 2026.
  • Vicinity Software captures 30% ANZ winery market from Ezy Systems in 6-12 months.

What makes Jonas Software unique

  • Jonas Software maintains decentralized portfolio of 200+ autonomous VMS companies across 40+ verticals.
  • Buy-and-hold-forever strategy ensures no resales since 2003 acquisitions.
  • Provides financial security and strategic guidance while preserving brands and management.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Remote Work Options

Flexible Work Hours

Company News

Jonas Software
Aug 22nd, 2025
Jonas Europe Acquires Aava Software

Jonas Europe has acquired Aava Ohjelmistot Oy, a leading developer of ERP and MES solutions for manufacturing and logistics. Aava Software, known for its low-code platform, aims to enhance its growth by leveraging Jonas's sales and marketing expertise. This acquisition marks a new phase for Aava, with plans to expand as a major ERP and MES provider.

Jonas Software
Jul 30th, 2025
Jonas Software ANZ Acquires RxOne

Jonas Software ANZ has acquired RxOne, a key provider of pharmacy management software in New Zealand. This acquisition enhances Jonas's presence in the pharmacy and healthcare technology sector. RxOne will continue to operate independently, maintaining its team and focus on innovation and customer service. Jeff McKee, CEO of Jonas Software ANZ, expressed excitement about supporting RxOne's growth, while RxOne's founder, Margie Peat, highlighted the benefits of joining Jonas.

Jonas Software
Jul 28th, 2025
Jonas Software ANZ Acquires MedAdvisor Solutions' ANZ Business

Jonas Software ANZ acquires MedAdvisor Solutions' ANZ business.

Jonas Software
May 1st, 2025
Jonas Europe Acquires Wheatley Software Solutions | Jonas Software UK & Europe

Wallingford, Oxfordshire, April 28th, 2025 – Jonas Europe (“Jonas”) is pleased to announce the acquisition of Wheatley Software Solutions.

Jonas Software
Dec 19th, 2024
Jonas Software Announces Acquisition of OnTap Data - Jonas Software

OnTap Data is a leading provider of data analytics and insights solutions tailored for the liquor, hospitality, and retail sectors.

INACTIVE