
SSIS Developer
- Gurgaon, Haryana
- Permanent
- Full-time
- Have a continuous improvement mindset.
- Take part in software design activities & discussions.
- Write production-quality code.
- Work collaboratively in the team.
- 5+ SQL Server Integration Services (SSIS) experience and ETL skills - SQL Server 2016.
- You should have excellent knowledge of SQL queries and SSIS.
- The expectation is to get the existing complex queries/SSIS understood and improve performance wherever required.
- Software: SQL Server 2012/2016/2017/onwards, SQL Integration Services 2008/2012/2016/2017.
- Tools: Jira, TeamCity, Git.
- Programming Languages: C#, VB.NET.
- Exceptional understanding of and experience with relational datasets, data warehouses, and ETL techniques.
- Experience in developing stored procedures.
- Performance tuning SQL Server databases.
- Extensive knowledge and experience developing stored procedures, views, and functions using Microsoft SQL Server.
- Light database administration skills (indexing, tuning, optimization, etc.
- Ability to write efficient, complex queries against very large data sets.
- Ability to model, analyze, and manage large volumes of data.
- Create jobs and schedules to automate ETL packages within SSIS.
- Strong analytical and quantitative skills.
- Experience in different phases of Software Development Life Cycle (SDLC), including Planning, Design, Development, and Testing during the development of software applications.
- Experience in Cloud computing and Amazon Web Services.
- Working knowledge of using GitHub, Rally/Jira, and Artifactory.
- Basic knowledge of click view and control M is beneficial but not mandatory. • A track record working as a developer in the Financial Services Industry and/or Treasury function or exposure to loans, interest rates, and balance sheet-related applications/datasets is desirable but not mandatory.