The following requirement is open with our client.
Client : TCS
Title : SQL Test Lead
Location : Stamford, CT/Southington, CT (Remote)
Duration : 12 Months
Rate : $60/hr on W2
Relevant Experience : 10
Detailed Job Description:
The SQL Test Lead is responsible for defining the testing strategy for enterprise-grade data systems. You will lead a global team of testers to ensure that data migrations, ETL processes, and database schemas meet strict business requirements.
Job Responsibilities:
· Define the scope for Unit, Integration, Regression, and User Acceptance Testing (UAT).
· Collaborate with DevOps and Data Engineers to ensure test environments mimic production scenarios with high-quality, masked test data.
· Identify opportunities to move from manual data checks to automated SQL validation scripts to increase coverage.
· Write and review sophisticated SQL queries (Joins, Subqueries, Stored Procedures, and Window Functions) to verify data transformations.
· Lead the team in verifying that business logic applied during the ETL process correctly aligns with the source data.
· Utilize tools like JMeter or LoadRunner to ensure the database can handle peak loads and concurrent queries without latency.
· Manage and mentor offshore and onshore testing teams, ensuring tasks are aligned with sprint goals.
· Own the defect management process in JIRA or ALM, ensuring bugs are caught early, analyzed for root cause, and re-tested upon fix.
· Standardize QA methodologies (Agile/Scrum) and implement industry best practices for data warehousing.
Must Have Skills:
· Mastery of SQL Server, Oracle, or DB2. You must be able to debug complex stored procedures and functions.
· Deep understanding of Data Warehousing concepts (Star/Snowflake schemas, Dimensions, and Fact tables).
· Proficiency in JIRA/ALM for tracking and Selenium or specialized data testing tools for automation.
· Experience working in both Agile/Scrum and traditional Waterfall environments.
Thanks and Regards,
Goutham Eluri
Technical Recruiter
ASCII Group LLC.
38345 W. 10 Mile Rd, Ste.#365; Farmington, MI 48335
Office:
Email: Website: