dreamwork_

•    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