•    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