• 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