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.

ET&S India will be fueling the Digital aspirations of ERGO world in years to come. With ambitious plan to build a large offshore development centers in multiple cities of the country ETS India shall be at the forefront in developing capabilities and providing career opportunities to employees in diverse technologies across domains of Insurance.

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