Responsibilities:
• Written complex SQL (Sub queries and Join conditions), in PL/SQL .
• Hands on Experienced in Database programming using Oracle PL/SQL.
• Troubleshoot and debug system and/or data errors.
• Ability to understand the business requirements and Data models
• Vast Experience in Oracle advance SQL Programming Using Analytical
functions,Sub Queries, indexes , triggers , cursors and Set Operators.
• Build analytics tools that utilize the data pipeline to provide actionable insights into
customer acquisition, operational efficiency and other key business performance
metrics.Developed forms and reports for internal reporting using oracle forms
builder/reports builder.
• Introduction to DBA ( Database Administrator).
Responsibilities:
• Worked with client to understand business needs and translate those business
needs into reports.
• Automated ETL processes across millions rows of data, which saved 35 hours of
manual hours per month.
• Hadoop ecosystem.
• Analytic Problem-Solving.
• Integration of ETL approaches on big structured/unstructured data.
• Create ETL procedures and functions process.
• Create and modify ETL using SSIS.
• Create full loading jobs.
• MSBI (SSIS , SSRS).
• Microsoft Power BI
• Development for new requirements upon business teams requests.
• Telecom / IT business experience.
• Data Migration.
Responsibilities:
• Developed and implemented data pipelines using AWS services such as Kinesis
, S3 , Athena to process terabyte-scale data in real time.
• Analyzed the business requirements and translate them into technical specifications
that can be used by developers to implement new features or enhancements.
• Analytic Problem-Solving.
• Built ETL process in python and SQL to transform unstructured data into structured
datasets.
• create conceptual and logical data model/schema designs, design, improve and
optimize data pipeline and workflows in terms of robustness and performance.
• Work through all stages of a data solution life cycle: analyze the problem domain
and derive data modeling solutions.
• Build analytics tools that utilize the data pipeline to provide actionable insights into
customer acquisition, operational efficiency and other key business performance
metrics.
• Development for new requirements upon business teams requests.
• Identify gaps and invent processes, automated scripts, and tools to efficiently
carry out data processing tasks in a scalable fashion.
• Establish testing strategy and best practices.
التعمق في مجال علم الحاسوب و لغات البرمجة و تصميم المواقع وهندسية البيانات و الداتا بيس