Required Skills:
- Data Management.
- Snowflake cloud warehouse.
- ETL pipelines in and out of data warehouse.
- Python and Snowflake SQL.
- Scripts using Unix shell.
- Data Lineage Analysis.
- Data Profiling Mapping Integration.
- ETL Validation Cleansing Masking Subsetting
Note: This role has been re-opened. Previous candidates were rejected due to a lack of specific skills for the Snowflake database. We are looking for a senior Snowflake engineer!
Additional Information:
- This role is Contract to Hire.
- Please submit only W2 Candidates.
- Candidates with Financial Services Industry experience will be preferred.
Must Have:
- Minimum 8 years of experience in Data Management and specialized in Analytical data warehouse.
- Minimum 3 years hands-on experience with Snowflake cloud warehouse and its features.
- Good knowledge of cloud AWS architecture and its services.
- Experience in creating and analyzing SQL and PL/SQL procedures for data integration.
- Developing ETL pipelines in and out of the data warehouse using a combination of Python and Snowflake SQL.
- Developing scripts using Unix shell to extract and load data.
- Good understanding of logical and physical data models to support analytics and business intelligence.
- Experience in creating SQL-based processes to build slowly changing dimensions and various types of facts.
- Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL
Validation Cleansing Masking Subsetting, Profiling Archiving, Purging Virtualization,
Metadata Management, Performing Unit Test, System integration test Support, UAT. - Involved in SQL performance tuning, root causing failures, and resolving technical issues.
- Engaged in projects using Agile methodology and documentation using Jira.
- Strong verbal and written communication skills.
Job Features
Experience Level | Mid-senior |
Experience Required | 8 Years |
Education Level | Bachelor’s degree |
Job Function | Information Technology |
Industry | Financial Services |
Relocation Assistance | No |
Visa Sponsorship Eligibility | No |