Source description
About the role
Location- Noida/Chennai/Hyderabad/Pune • Working experience with SSIS, SQL, T-SQL • Practical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggers • Experience with SSIS development and SSRS reports (preferred) • Experience building and troubleshooting complex pipelines in Snowflake • Ability to create Functions/Views/Stored Procs. • Experience with complex queries including use of CTEs, table variables, merge and dynamic SQL. • Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion. • Experience executing SSIS packages via SQL Server Job Agent • Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables, parameters, package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks. • Data processing on Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) • Working knowledge of Azure Synapse • Working knowledge of Snowflake • Airflow experience a bonus but not required Role: Database Developer / Engineer Industry Type: IT Services & Consulting Department: Engineering - Software & QA Employment Type: Full Time, Permanent Role Category: DBA / Data warehousing Education UG: Any Graduate
More at Innova solutinos