Responsibilities
* Migrate legacy Oracle ETL and reporting systems to Snowflake, improving data accuracy, scalability and maintainability while ensuring zero-downtime deployment.
* Optimize Snowflake performance through query tuning, clustering and efficient resource management, improving system reliability and query efficiency.
* Built scalable data models and transformation pipelines using SQL and dbt on Snowflake, streamlining reporting processes and improving data quality across multiple business domains.
* Leveraged AWS services (S3, IAM) to support secure cloud data storage and access management, enabling seamless integration between source systems and Snowflake data warehouse.
* Configure and manage Fivetran connectors to automate data ingestion from multiple source systems into Snowflake, reducing manual data loading effort and ensuring reliable, scheduled pipeline execution.
* Maintain and support CI/CD pipelines for dbt projects using GitHub Actions and Git, ensuring reliable and consistent deployments across development, testing and production environments.
* Collaborate cross-functionally with data analysts, business stakeholders and developers to deliver end-to-end data solutions, integrating cloud-native and traditional Oracle systems.
* Design, develop and maintain Oracle PL/SQL stored procedures, triggers and packages for enterprise applications used by 500+ business users.
* Develop and customize Oracle Forms and Reports, enhancing user experience and optimizing critical reporting workflows.
* Provide application support for the OEMs Online Order Management, ensuring smooth daily operations, maintaining 99%+ uptime and resolving issues within agreed SLAs.
* Develop and modify the packages, forms, and XML reports for processing EDI invoice files, updating AP invoice tables and automating notifications through Shell Scripts.
* Create Excel template reports for Cisco payment registers, enabling multi-sheet downloads and report distribution using bursting control files. Migrated jobs from Dollar U to Tidal, developed OATS POC and created Kintana packages for code deployment, ensuring smooth component migrations.
J-18808-Ljbffr