Data Engineer
ecsme · Telangana, Hyderabad, India ·
- Category
- Data engineering
- Company size
- 11-50
Designs and optimizes SQL/PLSQL code for reporting and ETL in Oracle, Redshift, and Cloudera, primarily for airline data.
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.