About kivishinfotech

kivishinfotech is a staffing and recruiting company.

company website →

Sr.Snowflakes Programmer← All Jobs

2020-10-01 | Secaucas, NJ | Open | 12 Months+ Contract


Description

"Basic Purpose:

Work as part of a small, agile team to design and implement in the Snowflake data warehouse utilizing an AWS data pipeline. This individual will work with stakeholders and other members of the information technology team to understand data requirements and deliver reporting and analytical solutions, including both the near real-time and batch processes used to populate the data warehouse from multiple sources.



Duties and Responsibilities:

Ability to develop ETL pipelines in and out of data warehouse using combination Python, Matillion and Snowflake’s SnowSQL

Ability to understand data pipelines and modern ways of automating data pipeline using AWS technologies such as Lamdba.

Ability to integrate on premise infrastructure with public cloud (AWS, AZURE) infrastructure

To work as part of a team to develop ETL and ELT code in Matillion for real-time data and batch.

Participate in the development of cloud data warehouses and business intelligence solutions

Experience with coding in visualization platforms such as Tableau or Cognos.

Communicate team and project status to project manager and director.

Prepare discovery documentation, functional and technical design specifications

Develop and test application software that is efficient and meets functional specifications

Program debugging and problem troubleshooting

Provide implementation and post implementation production support, including after hours

Provide effective technical leadership and expertise

Interact with vendors for co-development of solutions.

Proactive in communication and escalation of concerns

Maintain compliance with relevant departmental SOPs and provide updates as needed



Qualifications:

Education Preferred: Bachelor’s degree in Computer Science or equivalent required.

Work Experience: 3-5+ years’ experience developing ETL, ELT and Data Warehousing solutions

At least 6 months to 1 Year experience with Snowflake cloud-based data warehouse

6 months to 1 Year experience with Snowflake SnowSQL and writing use defined functions

Hands-on experience with at least one Snowflake implementation

3-5 years’ experience developing SQL scripts and stored procedures that processes data from databases

3-5 years’ experience AWS cloud

1+ years’ experience with coding in visualization platforms such as Tableau or Cognos.



Work Expectations:

No travel required

Occasional night/weekend work required for production implementation and post implementation support.



Physical and Mental:

Ability to multi-task, Analytical skills, Ability to follow verbal or written instructions, Thinking analytically, Communication, Using effective verbal communication, Using effective written communication, Handling stress & emotions, Concentrating on tasks, Making decisions, Adjusting to change, Examining/observing details, Sitting for long periods at a time

Good interpersonal skills presenting a positive attitude.

Good organizational and planning skills with attention to detail.

Innovative thinker with the ability to manage problems and unforeseen issues to minimize conflict



Other:

Hands on practical experience with Matillion ETL / ETL a plus.

Some prior knowledge of ETL tools preferred.."


Share:

Apply
Your Name here
Your Email Address
Enter your message to the company explaining why you are a fit for this job
Please use Microsoft Word format


Similar Jobs: