Data Engineer
letzbizz
Job Description
- Design, develop, and maintain complex Oracle PL/SQL objects including:
- Stored Procedures
- Functions
- Packages
- Triggers
- Cursors
- Collections
- Materialized Views
- Develop and support robust ETL pipelines for data extraction, transformation, and loading from multiple source systems.
- Perform data modeling activities including:
- Logical Data Modeling
- Physical Data Modeling
- Database Normalization
- Dimensional Modeling
- Optimize SQL and PL/SQL code for performance, scalability, and maintainability.
- Design and implement data validation, reconciliation, and error-handling frameworks.
- Analyze business requirements and translate them into technical data solutions.
- Troubleshoot production data issues and provide root-cause analysis.
- Develop batch processing solutions and automate data workflows.
- Work closely with Business Analysts, Architects, Application Teams, and Data Analysts.
- Ensure data quality, governance, security, and compliance standards are met.
- Participate in code reviews, design discussions, and CI/CD deployment activities.