SQL Developer

Firstsource; Bengaluru; On-site; USD 5,685 - 10,233; Full time

Job summary

An established industry player is seeking a skilled database professional to join their dynamic team. This role involves designing and implementing efficient database solutions, executing data migration, and optimizing data processing. The ideal candidate will have a strong background in SQL, SSIS, and ETL processes, with a focus on delivering high-quality data management. With a commitment to excellence, you will collaborate closely with cross-functional teams to ensure data integrity and consistency. This is a fantastic opportunity to grow in a supportive environment while working on exciting projects that make a real impact in the software development and IT services sector.

Qualifications

• Minimum 3 years of experience with SQL databases and data migration.
• Strong understanding of normalization, primary keys, and ACID principles.

Responsibilities

• Design and develop scalable database solutions using SQL.
• Collaborate with Database Administration for creating physical tables.

Skills

SQL

SSIS

Data Migration

ETL Processes

Data Analysis

Excel Proficiency

Tools

SQL Server 2014

SSRS

VS (Visual Studio)

BCP

DTS

Job description

Direct message the job poster from Firstsource

Job Responsibilities:

• Minimum 3 years of experience working with SQL databases.
• Strong experience in designing data migration packages using SSIS, with the ability to read and write data from folders.
• Design and develop efficient and scalable database solutions using tables, stored procedures, functions, views, and indexes.
• Transfer data from the development environment to production and other related environments.
• Perform schema comparison to ensure data consistency and integrity.
• Execute bulk operations to optimize data processing.
• Implement server-side coding for effective data manipulation and retrieval.
• Demonstrate a strong understanding of normalization, denormalization, primary keys, foreign keys, constraints, transactions, ACID principles, indexes as optimization tools, and views.
• Collaborate with the Database Administration team to create physical tables from logical models.
• Design and implement data migration packages using SSIS, ensuring efficient read and write operations from folders.
• Execute ETL processes and data migration using CSV, Excel, and TXT files.
• Generate ad hoc reports based on business requirements.
• Possess a good knowledge of SQL Server 2014 and Above.
• Experience with cloud-based deployment and management of SQL Server.
• Experience with SSIS, VS and SSRS for efficient data integration and reporting.
• Familiarity with BULK copy tools such as BCP, DTS, etc.
• Proficient in DML (Data Manipulation Language), DDL (Data Definition Language), ETL processes, table-level backups, and system objects.
• Excel proficiency for data pivoting and analysis.

Shift Timings:

• The shift is for a US project in the US Eastern Standard Time (EST) zone.
• The working hours are from 5 PM to 2 AM Indian Standard Time (IST).
• This position follows a 5-day working schedule.

Seniority Level:

• Associate

Employment Type:

• Full-time

Job Function:

• Information Technology
• Industries: Software Development and IT Services and IT Consulting