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.
