New York City, NY – and upgrades across different environments Apply data modelling techniques and generate custom ETL scripts using cdc and SSIS. Translate business requirements into ETL designs and mapping specifications. ETL of data from various sources, including structured (replicated SQL tables, txt/csv/xls, etc), semi-structured (xml, json), and unstructured (doc, pdf) data into fact/Dimension tables. Design, tune and maintain existing ETL processes. Leverage T-SQL and other data querying tools to assist end-users… warehouse structure and dataflow, including its data warehouse management (DWM) and reporting (DWR) tools Communicate with business users on various data administrative projects and tasks, such as data and system integration into DW, day-to-day master data management, DW reporting enquiries, etc. Provide support and guidance to other software developers and team members on SQL tools, techniques, and best practices Basic Qualifications: 5+ years of experience in SQL Server database administration…