We are seeking a skilled Data Engineer with strong expertise in PL/SQL and data engineering practices. The ideal candidate will be responsible for designing, developing, and optimizing data pipelines, with a strong focus on database programming and performance tuning.
Key Responsibilities
• Design and develop scalable data pipelines and ETL processes.
• Write and optimize complex PL/SQL procedures, functions, and packages.
• Perform data extraction, transformation, and loading from multiple sources.
• Develop and maintain data models and database structures.
• Optimize database performance and query execution.
• Ensure data quality, integrity, and consistency.
• Work with large datasets and data warehouses.
• Collaborate with Data Analysts, Architects, and business teams.
Core Technical Skills (Mandatory)
• Strong experience with:
o Oracle Database
o PL/SQL (procedures, functions, triggers, packages)
• Advanced SQL skills:
o Complex joins, window functions, query optimization
• Strong knowledge of:
o Data Warehousing concepts (Star/Snowflake schema)
o Data modeling and ETL design
ETL & Data Tools
• Experience with ETL tools such as:
o Informatica PowerCenter
o Talend
o Microsoft SSIS
• Experience in building ETL/ELT pipelines.
Big Data & Modern Stack (Preferred)
• Exposure to:
o Apache Spark
o Hadoop
• Experience with:
o Apache Airflow