Role: Snowflake Developer

Location: Coppell, TX (Onsite)

Duration: 6 months CTH

U.S. Citizens will be considered.

Job Description:

Candidates with Financial Services Industry experience will be preferred over others!

Please Note: To effectively evaluate and present suitable candidates for this role, it is crucial to thoroughly review the outlined Must-Have Skills provided in the job insights section. The candidate's resume should comprehensively highlight their qualifications and showcase hands-on experience with the required skills. Additionally, it's essential to verify the credentials listed (i.e. employment details, education) on the resume. To facilitate easy assessment, the resume should be well-formatted in a Word document, featuring a concise and organized summary on the first page, presenting the candidate's skills and experience in bullet points. Thanks !

Job Description:

• 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 on cloud AWS architecture and its services.
• Experience in creating and analysing SQL and PL/SQL procedures for data integration.
• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflake SQL. Developing scripts using Unix shell to do 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 dimension and various type of facts.
• Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting, Profiling Archiving, Purging Virtualization, Metadata Management, Performing Unit Test, System integration test Support, UAT.
• Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them.
• Engaged in project using Agile methodology and documentation using Jira.
• Strong verbal and written communication skills.

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 on cloud AWS architecture and its services.
• Experience in creating and analysing SQL and PL/SQL procedures for data integration.
• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflake SQL. Developing scripts using Unix shell to do 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 dimension and various type of facts.
• Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting,
• Profiling Archiving, Purging Virtualization, Metadata Management, Performing Unit Test, System integration test Support, UAT.
• Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them.
• Engaged in project using Agile methodology and documentation using Jira.
• Strong verbal and written communication skills.