Sr. SQL/SSIS Developer

Role: Sr. SQL/SSIS Developer
Location: NYC, NY (Hybrid)
Final Round F2F Interview
Required Minimum Exp: 12+ Yrs 
 
Description:
Strong relational database skills, MS SQL Server and PostgreSQL in particular.
Write and modify complex stored procedures, to be able to properly handle transactions and manage errors.
SQL code/queries optimization.
Strong SSIS skills. To be able to develop new packages with some C# code and transformations.
Create and maintain APIs
Proficient in data analysis. Proficient in scripting.
Strong analytical skills and ability to learn.
Looking for very experienced person with 10+ years of experience but would also
consider less for a really strong person with strong set of skills and relevant experience.
Experience with Agile methodologies.
Good communication and presentation skills: ability to communicate in a clear and concise manner, across all stakeholder groups.
Understanding of requirements of large enterprise applications (security, entitlements, etc.)
Experience with task management tools such as JIRA.
 
Required Skills:
Very strong in Transact-SQL, SQL
Ability to write complex queries, functions and stored procedures
Should have solid database concepts
Very strong in Data Migration. Extensively worked on SSIS or any other integration tool
Experience in Data Warehouse projects
Experience with Postgress SQL would be a big plus
Experience with Dell boomi