Data Engineer
Summary
Develop and optimize SQL/PL-SQL code in Oracle and AWS Redshift, building packages, procedures, functions, and triggers for ETL automation and data integration between Oracle and SQL Server databases, with query performance tuning and data modeling responsibilities.
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.