An accomplished Data Engineer with 5+ years of hands-on experience in designing, building, and optimizing data warehouse solutions across on-premise Oracle and cloud-based Snowflake platforms. Proficient in developing an…
An accomplished Data Engineer with 5+ years of hands-on experience in designing, building, and optimizing data warehouse solutions across on-premise Oracle and cloud-based Snowflake platforms. Proficient in developing and tuning complex PL/SQL packages and leveraging key Snowflake features such as Snow pipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, and Secure Data Sharing for efficient data automation. Skilled in developing Stored Procedures, UDFs, and SQL scripts for complex business transformations Proven track record of improving data processing efficiency and performance by implementing scalable solutions .Experience implementing CI/CD pipelines for Snowflake GitHub for automated deployment and version control
الخبرة
K
Oracle Database Specialist
Kanoo Elite Private Limited·Riyadh, KSA
Mar 2023 - Dec 2025 · 2 سنوات 9 أشهر
<p>Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.</p><p> Developed and implemented Oracle stored procedures, triggers, functions, and packages for multiple databases.</p><p> Utilized Oracle database tools such as SQL Developer, PL/SQL Developer, Toad to develop solutions.</p><p> Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.</p><p> Develop scripts using business rules for data matching, data cleansing.</p><p> Analyze and validate customer data to meet Workday requirements.</p><p> Analyzing the business information needs of Global News and mapping this to their existing and new systems.</p><p> Ensuring the Business Information needs are developed in the migration solution.</p><p> Building intermediate database extract and transformation scripts.</p><p> Responsible for managing data sourcing, cleansing and reconciliation efforts with other workstream teams and business units.</p><p> Provide support during production implementation and Go-live activities.</p><p> Prepare detailed technical impact analysis and test data preparation for testing team if need.</p>
K
Data Engineer
Kanoo Elite Private Limited·Riyadh, KSA
Mar 2023 - Dec 2025 · 2 سنوات 9 أشهر
<p>Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.</p><p> Developed and implemented Oracle stored procedures, triggers, functions, and packages for multiple databases.</p><p> Utilized Oracle database tools such as SQL Developer, PL/SQL Developer, Toad to develop solutions.</p><p> Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.</p><p> Develop scripts using business rules for data matching, data cleansing.</p><p> Analyze and validate customer data to meet Workday requirements.</p><p> Analyzing the business information needs of Global News and mapping this to their existing and new systems.</p><p> Ensuring the Business Information needs are developed in the migration solution.</p><p> Building intermediate database extract and transformation scripts.</p><p> Responsible for managing data sourcing, cleansing and reconciliation efforts with other workstream teams and business units.</p><p> Provide support during production implementation and Go-live activities.</p><p> Prepare detailed technical impact analysis and test data preparation for testing team if need.</p>
I
Data Engineer
Ivaan Tech Pvt Ltd·Chennai
Mar 2020 - Sep 2022 · 2 سنوات 6 أشهر
<p>Created and maintained Oracle database objects like tables, views, materialized views, indexes, constraints, sequence, synonyms and database link using SQL.</p><p> Developed complex Oracle PL/SQL queries and stored procedures for data migration and integration.</p><p> Designed and developed database objects including tables, views, packages, functions, and triggers.</p><p> Built and maintained complex database queries, stored procedures and packages.</p><p> Developed data models to support new business requirements.</p><p> Data extracting in multiple table for the testing purpose.</p><p> Data validation between source and target environment.</p>
I
Data Engineer
Ivaan Tech Pvt Ltd·Chennai
Mar 2020 - Sep 2022 · 2 سنوات 6 أشهر
<p>Created and maintained Oracle database objects like tables, views, materialized views, indexes, constraints, sequence, synonyms and database link using SQL.</p><p> Developed complex Oracle PL/SQL queries and stored procedures for data migration and integration.</p><p> Designed and developed database objects including tables, views, packages, functions, and triggers.</p><p> Built and maintained complex database queries, stored procedures and packages.</p><p> Developed data models to support new business requirements.</p><p> Data extracting in multiple table for the testing purpose.</p><p> Data validation between source and target environment.</p>
المشاريع
C
Core banking System
BSF
المدة : 01-Mar-2023 - 08-Sep-2026
<p> Created Oracle database objects tables, views, synonyms, materialized views, stored procedures, and packages —</p><p>using PL/SQL Developer to support a core banking data migration program.</p><p>• Developed and implemented Oracle stored procedures, triggers, functions, and packages across multiple</p><p>databases.</p><p>• Performed SQL and PL/SQL performance tuning using indexes, execution plans, BULK COLLECT, FORALL, collections,</p><p>partitioning, and optimized SQL queries</p><p>• Used SQL Developer, PL/SQL Developer, and TOAD to design, build, and troubleshoot data solutions.</p><p>• Worked on end-to-end integration of banking transactions from Core Banking system to Oracle FAH.</p><p>• Designed and developed staging and interface processes of extracting, validating, transforming, enriching, and</p><p>loading core banking transaction data into FAH</p><p>• Built indexes on high-volume tables to eliminate full table scans and created views to abstract underlying tables</p><p>and reduce query complexity.</p><p>• Wrote business-rule-driven scripts for data matching and data cleansing across source systems.</p><p>• Analysed and validated customer data to meet Workday integration requirements.</p><p>• Assessed business information needs and mapped them to existing and new systems as part of the migration</p><p>solution.</p><p>• Built intermediate database extract and transformation scripts to support downstream processing.• Managed data sourcing, cleansing, and reconciliation efforts in coordination with cross-functional workstream</p><p>teams.</p><p>• Supported production implementation and go-live activities, including issue triage and resolution.</p><p></p>
