Demonstrated experience working with Microsoft SQL Server Integration Services (SSIS) with hands on development experience using the Microsoft SQL Server T-SQL Programming Language
Solid understanding of relational database concepts
Working knowledge of data structures, algorithms and SQL queries
Deep SQL Experience on ETL or database that supports ANSI compliant SQL or HIVE/Spark SQL
Experience working in a fast paced agile environment
Experience modeling data
preferred
ERWIN or other Data Modeling tool experience preferred
Experiencing developing KSQL for use in streaming analytics is a plus
Responsibilities
Develop, implement Database Objects like Tables, Views, Functions, Stored procedures using T-SQL
Analyze existing SQL queries for performance improvements
Developing complex SQL for use in ETL/ELT applications.
Developing SSIS for moving data between Oracle and SQL Server
Creating estimates for sprints to accurately reflect the effort required
Unit testing SQL Code/SSIS
Writing source to target documentation Qualifications