Full-Time

Solution Integration

ETL Consultant II

Confirmed live in the last 24 hours

Jonas Software

Jonas Software

1,001-5,000 employees

No salary listed

Senior, Expert

Bengaluru, Karnataka, India

Hybrid model of working.

Category
Data Management
Data Engineering
Data & Analytics
Required Skills
Agile
Git
Postgres
RDBMS
AWS
Jenkins
Oracle
Linux/Unix
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
  • Hands-on experience in AWS services like PostgreSQL, Aurora, Lambda is preferred
  • Ability to perform data research and root cause analysis on data issues/discrepancies
  • Good communication skills including verbal and writing skills
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
Desired Qualifications
  • Experience in either the Banking or Financial Industry is preferred
  • Experience in SSRS reports development is preferred
  • Working knowledge of Python scripting is preferred

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

  • Increased demand for data analytics in hospitality boosts Jonas's growth potential.
  • ERP market expansion for niche industries offers new verticals for Jonas.
  • AI integration in car rental software aligns with Jonas's strategic acquisitions.

What critics are saying

  • Integration challenges from multiple acquisitions may lead to operational inefficiencies.
  • Diverse sector acquisitions could dilute Jonas Software's core competencies.
  • Rapid market expansion may expose Jonas to unfamiliar regulatory environments.

What makes Jonas Software unique

  • Jonas Software focuses on acquiring niche market software providers.
  • The company has expanded into diverse sectors like liquor, hospitality, and car rental.
  • Jonas Software leverages acquisitions to enhance product offerings and customer service.

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

Benefits

Remote Work Options

Flexible Work Hours

Company News

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.

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

Brisbane, Australia, December 19, 2024 - Jonas Software ANZ ("Jonas") proudly announces its acquisition of OnTap Data Australia, a leading provider of data analytics and insights solutions tailored for the liquor, hospitality, and retail sectors.

Jonas Software
Dec 16th, 2024
Jonas Software Acquires Rock Solid Knowledge | Jonas Software UK & Europe

Wallingford, Oxfordshire, December 16th, 2024 – Jonas Software (“Jonas”) is pleased to announce the acquisition of Rock Solid Knowledge, a

Jonas Software
Jun 17th, 2024
Jonas Software Acquires Ezy Systems

Jonas Software has acquired Ezy Systems, a leading ERP provider for wineries and related industries. This acquisition aims to enhance Jonas's product offerings and deepen service to customers. Ezy Systems, founded in 1993, will leverage Jonas's resources to better serve its market. Jeff McKee, Group CEO at Jonas Software ANZ, highlighted that this acquisition marks a new market vertical for Jonas in the region, promising increased innovation and value for customers.

Jonas Software
Jun 17th, 2024
Jonas Software Acquires Ezy Systems

Brisbane, Australia, June 18, 2024 - Jonas Software ("Jonas"), is thrilled to announce the acquisition of Ezy Systems, a leading player in the enterprise resource planning (ERP) market, focussing on wineries, and wine production, with application to a raft of related industries such as juice, oil and spirits production.