<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>
