Job Description: Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest\egress integrations with Financial Risk Mart Solution.
Contractor’s Role: The role will revolve around the building and supporting of the Snowflake processes as well as working with current application development team to drive superior business value, enhanced customer experience and compliance with standards.
Experience Level: Senior resource: 5+ years
Qualifications: • Expertise in design/development in Snowflake on Azure • Experience in ETL tools like SnowSQL from design/development and implementing data ingestion and processing pipelines
Expertise with the following skills: 1) Snowflake 2) SQL 3) Python 4) Data Analysis 5) Good problem Solving skills
Nice to have: Datastage ETL experience
Job Description: • Design and Develop ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL • Deep understanding of relational as well as NoSQL data stores methods and approaches star and snowflake dimensional modelling • Experience in designing and deploying virtual warehouse, schema, views, zero-copy clone in Snowflake cloud data warehouse • Work with data analyst in mapping documents and design/build IBM DataStage jobs to the requirements. • Participate in peer design reviews and provide recommendations.
• Ensure runbooks are fully up-to date and consistently improving the efficiency derived from automation. • Hands-on experience to improve operational stability via automation, such as auto-healing where possible, and raise design changes SMEs and/or architects, as well as opportunities to application /service managers. • Work some off hours as demanded by projects, operations, and need of the on-shore team and stakeholders, such as release, testing and/or critical bug resolutions.
This is to support the new work forthcoming in Risk Consolidation project, Financial Risk Mart in Snowflake.
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation. At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $60.00/monthly.
