Database Developer

Description

• 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