Snow Flake Architect Industry: Financial Services - Commercial Banking | Alabaster, AL

Detailed Information

  • Location: NY

  • Company: Vodastra

and are bold enough to reinvent it. Transformation happens here. Come, and be a part of our exciting journey! Job Responsibilities: Daily standup meeting with Genpact offshore team to discuss all development & test JIRA cards. Help developers with any technical issues related to AWS components (Lambdas, SNS, Athena, Step Functions, Glue Jobs & Triggers) Help developers with any technical issues related to Snowflake components (External Tables, Internal Tables, Tasks, Streams, Warehouses) Conduct Po Cs for new technology exploration e.

g. DBT for implementing SCD Type2 tables, Data Quality testing using DBT, Data Masking in Snowflake. Coordinate code merges to Sandbox Master and releases/deployments

to UAT & PROD (both AWS and Snowflake ), via Gitlab Understand business requirements for upcoming data ingestion work (Securities data, Master data, Positions data, etc.

) What’s the timeline for implementing the pipeline? What level of testing is required e. g. Source-to-Target reconciliation, Basic Data Quality vs Functional Testing) What volume of data are we dealing with? How will the data be consumed once it has been hosted in the Cloud Data Lake ( AWS S3 ) and Warehouse ( Snowflake )? Work with client Lead Architect/Leads to resolve dependencies, technical challenges, etc. Team includes 2 testers. So have to work with Test managers/Leads to understand the scope of ad-hoc testing

work that comes in (from other teams reporting to the client VP) For some components where Genpact is responsible for end-to-end development, publish WBS structure and delivery plan (doesn’t require MPP or such, basic Excel is fine).

Ensure proper documentation is created for the new pipelines, extracts, etc. being developed (Confluence). Qualifications: 10+ years of success in consultative/sophisticated deployment projects, architecture, design, implementation, and/or support of data and analytics solutions Experience working with a globally distributed team and managing offshore teams. Understanding of enterprise data management concepts ( Data Governance , Data Engineering , Data Science , Data Lake , Data Warehouse , Data Sharing , Data Applications ) Hands-on development Design and Develop applications using Snowflake (preferably on AWS ) In-depth understanding of Snowflake Architecture including Snow SQL , Performance tuning, Compute, and Storage Experience in creating tables, partitioning, bucketing, loading, and aggregating data using Snowflake.

Expertise with some of Snowflake's concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, zero-copy clone, and time travel and understanding how to use these features.

Experience in Data Migration from RDBMS to Snowflake cloud data warehouse Expertise in using various data sources like JSON , Parquet , ORC , etc. Provide technology architectural backssments, strategies, and roadmaps for one or more technology domains. Collaborate with the customer's operations and technology leadership on the future analytic goals of the organization and design a technical architecture to meet those goals. Participate in configuring the architecture and advise engineering teams on its efficient use. Lead a work stream or act as a team lead and manage non-complex components of the work plan/project.

Experience with CI/CD using Gitlab , Git Hub , etc. Experience with DBT and Airflow would be nice to have. Experience with Test Automation using Selenium is good to have. CANDIDATE DETAILS Minimum Education - bachelor’s degree Willingness to Travel - Occasionally Powered by Jazz HR

View Jobs by Category >>

Related Jobs