Data Engineer

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