Job Description

About Firstsource
Firstsource Solutions Limited, an RP-Sanjiv Goenka Group company (NSE: FSL, BSE: 532809, Reuters: FISO.BO, Bloomberg: FSOL:IN), is a specialized global business process services partner, providing transformational solutions and services spanning the customer lifecycle across Healthcare, Banking and Financial Services, Communications, Media and Technology, Retail, and other diverse industries. With an established presence in the US, the UK, India, Mexico, Australia, South Africa, and the Philippines, we make it happen for our clients, solving their biggest challenges with hyper-focused, domain-centered teams and cutting-edge tech, data, and analytics. Our real-world practitioners work collaboratively to deliver future-focused outcomes.
About the role:
FirstSource Solutions Limited is seeking a motivated and skilled Sr SQL Developer to join our dynamic team. As a Sr SQL Developer, you will play a crucial role in designing and developing database solutions using tables, stored procedures, functions, views, and indexes. You will be responsible for various tasks including data transfer from the development environment to production and other related environments, schema comparison, bulk operations, and server-side coding.
Responsibilities:

• 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.

Applicant Requirements / Qualifications:

• A graduate degree in a relevant field.
• Minimum 2-3 years of experience working with SQL databases in a similar role.
• Strong experience in designing data migration packages using SSIS, with the ability to read and write data from folders.

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.

If you are a highly motivated individual with a strong background in SQL development, data migration using SSIS, and a passion for data management, then we would love to hear from you. Join our team at FirstSource Solutions Limited and contribute to our success by creating robust and efficient database solutions. Apply now and be part of our innovative and dynamic organization!
Disclaimer: Firstsource follows a fair, transparent, and merit-based hiring process. We never ask for money at any stage. Beware of fraudulent offers and always verify through our official channels or @firstsource.com email addresses.