Job Description :
Job title: SQL Server and ETL Lead Location: HMS Irving, TX ( Remote till COVID ) Duration: Long term Please find the JD for onshore lead 8+ years of experience in SQL Server and ETL tools (SSIS/Informatica/Talend Strong Experience in SQL Server database systems along with strong ETL developer experience Experience in T-SQL, including the ability to write stored procedures, triggers, functions etc. Experience in Developing, Testing, debugging SQL queries, stored procedures and error handling processes Experience in ETL development, deployment, optimization, support and defect fixes and data mapping documents preparation. Experience in data migration, data validation, data cleansing and data analysis. Strong experience in Extraction, Transformation, Loading (ETL) data from various heterogeneous source systems like SQL Server, DB2, Flat files, XML, Excel into Data Warehouses and Data Marts using SSIS Experience in performance tuning of sources, mappings, targets and sessions. Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment. Adopt integration standards, best practices while creating ETL jobs. Work as an independent contributor and collaborate with onshore/offshore/ team leads members other stake holders to understand business requirements, translate them into technical requirements Possess good knowledge of Agile methodologies. Excellent verbal and written communication skills Familiarity with CI/CD tools (Git)