JOB SUMMARY
Work Location: Plano, TX [100% Onsite]
Required Qualifications
• 6+ years of database or data-engineering experience, including at least 2 years of hands-on Snowflake development and strong Oracle SQL/PLSQL expertise
• Develop complex Snowflake SQL, tables, views, stored procedures, UDFs, and reusable data-transformation components
• Design and implement scalable ETL/ELT pipelines using Snowflake stages, file formats, COPY INTO, Snowpipe, Streams, Tasks, and Dynamic Tables
• Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers, collections, dynamic SQL, and bulk-processing routines
• Migrate or modernize existing Oracle/PLSQL workloads by converting procedural and row-by-row processing into efficient, set-based Snowflake solutions
• Implement full, incremental, CDC, and restorable data loads using staging tables, MERGE, audit controls, exception handling, and source-to-target reconciliation
• Work with structured and semi-structured data, including CSV, JSON, and Parquet, using Snowflake VARIANT, path expressions, and FLATTEN
• Troubleshoot and optimize Snowflake and Oracle workloads using execution plans, Query Profile, micro-partition pruning, clustering, warehouse sizing, and SQL performance-tuning techniques
• Manage database code through Git and CI/CD pipelines using tools such as Jenkins, Azure DevOps, GitHub Actions, Liquibase, Flyway, SnowSQL, or Snowflake CLI
• Collaborate with architects, developers, analysts, and production-support teams
• Participate in design and code reviews
• Document solutions
• Support deployments
• Resolve production data and performance issues
