SSIS Developer

ERGO Technologies and Services IndiaERGO Technology & Services India (ET&S India) is the newest part of the ERGO Technology & Services Management the main outsourcing provider of IT for ERGO worldwide. It is backed up by ERGO an 18 Billion Euro Organization with a presence in 15+ countries have a charter to provide technology services to the ERGO countries in multiple countries.

Role Description:

• Looking for SSIS Developer, should have 5+yrs of experience in SSIS, SQL Server and DWH.
• Bachelor s degree in IT/Computer Science/equivalent
• 5 to 10 years of , MS SQL Server,SSIS ,ETL developer experience.
• Extensive knowledge of MS SQL Server **2016 or later** is required.
• Hands on skills in *design, develop and troubleshoot t-SQL stored procedures, functions, tables, views, triggers, indexes and constraints.
• Experience in **Data Warehouse and Data Mart structures, designs**
• Proven skills in **ETL principles and best practices* handling semi-structured datasets and data load strategies, error data handling
• Solid understanding of dimensional data modeling and tools,* star schema and reporting designs using reporting tools (eg.: SSRS)
• Hands on experience in SQL Server query performance tuning.
• Good knowledge of Power BI would be a plus
• Good knowledge of DevOps tools (TFS/Azure Git, JIRA, ServiceNow) and processes (Source code /version control, Agile development, Incident management, process management) would be a plus.

Behavioral Skills:

• Fluency in English is mandatory, language skills, both verbally and in writing (Polish and/or German desirable)
• Service orientated and pro-active mind-set
• An energetic and goal-oriented style, combined with well-developed interpersonal skills
• Excellent communication and presentation skills as demonstrated in general conversation and written documents

Soft Skills:

• Very good knowledge in handling application support and maintenance projects with different skills.
• Good analytical and problem solving skills in a short time frame
• Detail orientation
• Initiative, reliability and dedication
• Very good communication and presentation skills
• Ability to work in a team
• Ability to deal with conflict
• Flexibility
• Ability to work under pressure