• Strong Database knowledge and experience (Advanced SQL, PLSQL)
• Knowledge in BI Platform such as Crystal Reports, MicroStrategy
• Data Warehouse, Star Schema knowledge and experience
• DB - Oracle, Amazon Redshift (preferable)
Advanced SQL and PL/SQL Knowledge:
- Strong skills in writing, optimizing, and debugging complex SQL queries and stored procedures.
- Experience in bulk data processing using advanced SQL and PL/SQL techniques.
- Proficiency in data modeling, schema design, and query optimization.
- Hands on knowledge on Oracle, Amazon Redshift databases
- Develop, and Implement Data Integration Requirements:
- Expertise in gathering and analyzing data integration requirements to create scalable solutions.
- Ability to design modular and reusable ETL components for large-scale data pipelines.
- Problem-Solving and Debugging Skills:
- Strong aptitude for identifying and resolving ETL and data-related issues efficiently.
- Proven experience in performance tuning of Data flows and SQL queries.
Other Skills:
- Strong communication and collaboration skills for working with cross-functional teams.
- Prefer to have experience working with Hadoop, Hive, Spark frameworks, AWS cloud
- Airlines domain experience preferred
- Good to Have:
- Airline experience.
- Amazon Cloud Services,
- - MicroStrategy BI platform
- Primary responsibility of this role is to design and build database solutions
- Work with complex, disparate data sources and perform data transformation, data analysis.
- Design and build data integration & warehouse solutions.
- Collaborate with other IT and business departments as per project needs to deliver common goals
Skills Required
- Strong Database knowledge and experience
- Advanced SQL and PL/SQL knowledge
- Experience in BI Platforms (Crystal Reports, MicroStrategy)
- Knowledge of Data Warehousing and Star Schema
- Hands-on experience with Oracle and Amazon Redshift
- Strong problem-solving and debugging skills
What We Do
IBS Software is a leading SaaS solutions provider to the travel industry globally, managing mission-critical operations for customers in the aviation, tour & cruise, hospitality and energy resources industries. IBS Software's solutions for the aviation industry cover fleet and crew operations, aircraft maintenance, passenger services, loyalty programs, staff travel & air-cargo management. IBS Software also runs a real-time B2B and B2C distribution platform providing hotel room inventory, rates, and availability to a global network of hospitality companies and channels. For the tour and cruise industry, IBS provides a comprehensive customer-centric, digital platform that covers onshore, online and on-board solutions. The Consulting and Digital Transformation (CDx) business focuses on driving digital transformation initiatives of its customers, leveraging its domain knowledge, digital technologies and engineering excellence. IBS Software operates from 16 offices across the world.
