Job Description
Strong SQL development skill in Oracle, Cloudera big data and AWS Redshift database, preferably in airline domain.
• Building queries and functions in Oracle and Redshift Database.
• Building packages/procedures/functions/triggers.
• In depth understanding and working experience in SQL.
• Query performance tuning.
• Data Architecture skills.
• Data modeling skills.
• Ability to understand the requirement and work independently.
• Understanding of database objects like table, view, trigger, etc.
• Understanding of ETL process.
Major areas of responsibility include:
• Develop the SQL and PL/SQL codes to automate the manual reporting works.
• Optimize the existing codes for better Performance.
• Integrate data between Oracle Database and SQL Server Database.
• Use PL/SQL for ETL works.
• Use as much as possible features available in procedures.