Experienced Data Warehouse Developer with a proven track record in software development, specializing in data modeling, data ingestion, transformation, and consumption patterns. Expertise in SQL, Oracle SQL/PL-SQL, and Snowflake scripting, with strong hands-on experience in migrating databases from Oracle to Snowflake. Proficient in building and optimizing complex queries, developing UDFs (User Defined Functions), and automating ETL processes. Familiar with cloud technologies and ETL tools to manage large-scale data pipelines. Adept in Agile and Scrum methodologies, with a focus on developing robust unit tests and integration tests to ensure high-quality deliverables.

Key Responsibilities:

• Data Warehousing:

  • Design the structure of the data warehouse, ensuring efficient storage, retrieval, and scalability of information.
  • Implement data ingestion processes, extracting data from various sources and ensuring clean and consistent loading into the data warehouse.
  • Transform raw data into usable formats, ensuring data integrity, consistency, and usability across different platforms.
  • Understand and implement data consumption patterns, ensuring data can be accessed efficiently by stakeholders.

• Database Management:

  • Write complex SQL queries to retrieve specific data, ensuring high performance and optimization for large datasets.
  • Develop and maintain user-defined functions (UDFs) to extend database functionalities.
  • Utilize Oracle SQL/PL-SQL to develop stored procedures, triggers, and scripts, with a particular focus on Cortex (Oracle's data management tool).
  • Experience in migrating data and processes from Oracle SQL/PL-SQL to Snowflake, ensuring smooth transitions and optimal performance post-migration.
  • Work with other RDBMS platforms like Teradata to ensure compatibility and efficiency within the data pipeline.

• Cloud Technologies and ETL Tools:

  • Leverage cloud technologies for data storage, processing, and analysis, with a focus on cloud-based data warehouses like Snowflake.
  • Use ETL tools for data pipeline automation, ensuring data is efficiently transformed, loaded, and stored across systems.

• Software Development:

  • Actively participate in migration projects, with at least 2 years of experience in migrating databases and processes from Oracle to Snowflake.
  • Develop and maintain unit tests, integration tests, and test automation scripts to ensure code quality and reliable performance across environments.

• Methodology:

  • Work within Agile and Scrum development teams, participating in iterative development cycles and collaborating with cross-functional teams to deliver high-quality solutions.
  • Engage in sprint planning, backlog grooming, and daily stand-ups, ensuring effective communication and timely delivery of features.

Must Haves:

• Experience:

  • 4+ years of experience in data warehousing, including data modeling, ingestion, transformation, and consumption.
  • At least 2 years of hands-on experience with migration projects, particularly in migrating Oracle SQL/PL-SQL to Snowflake scripting.
  • Strong knowledge of Oracle SQL/PL-SQL and experience with the Cortex data management tool.
  • Familiarity with RDBMS like Teradata and cloud technologies for data processing and storage.

• Technical Skills:

  • Expertise in SQL, complex query development, and UDF creation for database functionality.
  • Experience with Snowflake scripting and data migration best practices.
  • Familiarity with ETL tools and cloud-based data platforms.
  • Solid understanding of data modeling, ETL processes, and automation best practices.

• Development Methodologies:

  • Experience working in Agile and Scrum environments.
  • Strong ability to work collaboratively within cross-functional teams.

• Testing:

  • Ability to develop and maintain unit tests and integration tests for ensuring code quality and functionality.

• Communication:

  • Excellent logical thinking, debugging, and problem-solving skills.
  • Strong communication skills, able to interact with both technical and business stakeholders.