kivishinfotech is a staffing and recruiting company.
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
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.
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
Hands on practical experience with Matillion ETL / ETL a plus.
Some prior knowledge of ETL tools preferred.."