SSIS Developer

ETL SSIS JD

Job Summary:

The experienced ETL Developer is a member of the project team who takes responsibility for implementing parts of the system architecture using best practices in an agile development environment. This will include coding, unit testing, using design patterns, learning new technologies, and becoming an expert in one part of the system.

Primary Responsibilities:

Responsible for design, development, and implementation of solutions to exchange data using the required ETL tool, Azure Data Factory and DataBricks.Recent experience with SSIS is mandateAt least 1.5-2 years of hands-on experience in Azure ADF.Coding in Pysense for DataBricks will be added advantage.Overall knowledge of modern Azure ecosystem.6-8 years of delivering end to end ETL projects in SSIS or any such equivalent tools.Strong verbal and written communication and shall be able to work directly with client and business to understand the domain/requirements.Must be able to start a conversation with client directly and suggest the best approach on his/her own.Strong in DWH concepts and good understanding of modern analytics tools and processes.Strong in SQL/ TSQL/PL/SQL, writing effective SQL codes and stored procedures.Experience in DBMS like SQL Server and knowledge of know-hows of the same and troubleshooting experience.Develop new code and/or support operations, maintenance, and enhancements of existing codeConduct multiple levels of testing including unit, system, integration and performanceEstimate and plan releases.Understand the best practices and coding standards.

Key Skills

• SQL
• Azure