Data Engineer

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.