Sql Ssis Developer

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