ecsme
Data Engineer
Designs and optimizes SQL/PLSQL code for reporting and ETL in Oracle, Redshift, and Cloudera, primarily for airline data.
- Compensation
- Not disclosed
- Location
- Telangana, Hyderabad, India
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Full description
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.