1. Develop SQL, TSQL & SSIS packages.
2. Data Modeling and Data Architecture and hands-on with some tools
3. DWH Concepts and Implementation
4. Understanding on all aspects of Software Development Lifecyle (SDLC) in-line with Agile and IT craftsmanship principles
5. Understanding of data management – roles & permission
6. Should be able to design database solutions that are functional & stable
7. Analyze and resolve databases issues
8. Deliver high-quality clean code and design that can be re-used.

- Actively, work with other Development teams to define and implement API's and rules for data access.

1. Perform bug-free release validations and produce test and defect reports.
2. Contribute to developing scripts, configuring quality, and automating framework usage.
3. Run and maintain test suites with the guidance of seniors.
4. Support existing data models, data dictionary, data pipeline standards, storage of source, process, and consumer metadata
5. Deliver new and enhance existing standards, processes and procedures for database environments using industry experiences, and business needs
6. Understanding of database design practices including database normalization
7. Strong Problem Solving and Communication skills
8.



Ability to work independently and as part of team
9. Prepare technical design and implement on complex requirement
10. Ability to simplify complex requirements

Profile

SQL Server 2019+ & above, SQL Server Integration Service

- 2-6 years of experience in developing enterprise applications
- Clear understanding of Software Development life cycle and process Oriented

1. Expertise in TSQL writing complex stored procedures, functions & views
2. Expert in understanding of query execution plan
3. Expert in writing complex queries, indexes
4. Should have knowledge of disk optimization and data compression
5. Should have knowledge of Migration of SQL Server from one version to another.
6. Must have good knowledge of Performance tuning and should be able to analyze existing SQL queries for performance improvement.
7. Should have knowledge of basic DBA activities like taking Backup, restore & partitioning.
8. Design and implementation of SSIS ETL based on business requirement

- Should have positive knowledge on different data sources & destination, transformation in SSIS and best way to implement the solution.

📌 SQL Developer - ( SSIS ) Only 4 to 5 Years exp candidates (Bengaluru)
🏢 Coforge
📍 Bengaluru