IT SQL SSIS SSRS Developer

As a SQL Database Developer, you will be responsible for designing and developing efficient database solutions and ensuring data integrity and consistency. Your qualifications and responsibilities include: - 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. - Designing and developing efficient and scalable database solutions using tables, stored procedures, functions, views, and indexes. - Transferring data from the development environment to production and other related environments. - Performing schema comparison to ensure data consistency and integrity. - Executing bulk operations to optimize data processing. - Implementing server-side coding for effective data manipulation and retrieval. - Demonstrating a strong understanding of normalization, denormalization, primary keys, foreign keys, constraints, transactions, ACID principles, indexes as optimization tools, and views. - Collaborating with the Database Administration team to create physical tables from logical models. - Designing and implementing data migration packages using SSIS, ensuring efficient read and write operations from folders. - Executing ETL processes and data migration using CSV, Excel, and TXT files. - Generating ad hoc reports based on business requirements. - Possessing 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. The shift for this position 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. As a SQL Database Developer, you will be responsible for designing and developing efficient database solutions and ensuring data integrity and consistency. Your qualifications and responsibilities include: - 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. - Designing and developing efficient and scalable database solutions using tables, stored procedures, functions, views, and indexes. - Transferring data from the development environment to production and other related environments. - Performing schema comparison to ensure data consistency and integrity. - Executing bulk operations to optimize data processing. - Implementing server-side coding for effective data manipulation and retrieval. - Demonstrating a strong understanding of normalization, denormalization, primary keys, foreign keys, constraints, transactions, ACID principles, indexes as optimization tools, and views. - Collaborating with the Database Administration team to create physical tables from logical models. - Designing and implementing data migration packages using SSIS, ensuring efficient read and write operations from folders. - Executing ETL processes and data migration using CSV, Excel, and TXT files. - Generating ad hoc reports based on business requirements. - Possessing 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. The shift for this position 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.