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.
Show the full description
Design and build data integration & warehouse solutions.
Collaborate with other IT and business departments as per project needs to deliver common goals
