SQL Developer

Qualification/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.