Snowflake Developer

Hybrid - Onsite 1 day a week

Snowflake developer will work with Mizuho team both onshore and off shore for the integration of the Bank data with existing the Snowflake environment, leveraging all existing process and procedures already in place.

Activities shall include:

• Participate in and support Azure / Snow Flake infrastructure configuration and setup tasks including but not limited to Data Factory, Tidal, network connectivity, database connectivity, etc.
• Perform Extract and Load activities leveraging generic pipeline infrastructure previously developed and extend the functionality to support Mizuho Bank related data sources.
• Develop transformation code modules utilizing data mapping provided by Mizuho to integrate staging data into Mizuho Core Data Model and extend the data model when required.
• Input to Data Model modifications and new design elements as they relate to transformation targets
• Develop enhancements to and participate in testing, automation and operational activities related to the components developed within the scope that does not require any additional special skills.
• Participate in daily scrums, project related meetings, backlog grooming, sprint planning and retrospective sessions. Must understand the Agile development process and be committed to delivering assignments as planned and agreed.
• Key knowledge and technology skills required: CI/CD, Azure Cloud Dev Ops, Azure Data Bricks, Data Factory, GIT, Snowflake / SNOW SQL, Python, TIDAL, Data Integration tools (such as Informatica, SSIS) Microsoft SQL Server, Oracle, and process automation. Database model and design constructs for Star and Snow Flake schemas.

Preferred candidates will have background / experience working with data in Financial Services Industry, specifically Banking and some product related knowledge including but not limited to Securities and Banking domains (OTC Derivatives, Cash, Finance, Commercial Paper, Collateral, Loans, Commitment).
Knowledge and understanding of Risk and Regulatory reporting also a plus.
Skills:

• Preferred candidates will have background / experience working with data in Financial Services Industry, specifically Banking and some product related knowledge including but not limited to Securities and Banking domains (OTC Derivatives, Cash, Finance, Commercial Paper, Collateral, Loans, Commitment).
• Knowledge and understanding of Risk and Regulatory reporting also a plus.

Required Skills

• PROCESS AUTOMATION
• REGULATORY REPORTING
• DATA SOURCES
• NETWORK CONNECTIVITY
• LOANS

Additional

• FINANCE
• INFORMATICA
• DERIVATIVES
• SQL
• DATA MAPPING
• DATA INTEGRATION
• DATA MODEL
• GIT
• DEV OPS
• DATABASE
• AGILE
• ORACLE
• SECURITIES
• PYTHON
• CONTINUOUS INTEGRATION/DELIVERY
• FINANCIAL SERVICES
• DATABASE MODELING
• MS SQL SERVER