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.
