Katie E. Email & Phone Number

Durham, North Carolina, United States

Remote

Performance tune, analyzes, designs, build, test, and implement integration technology solutions that meet the companies specifications - Perform data mappings and design of system ETL workflow solutions - Write SQL queries against MS SQL Server Azure databases and Datawarehouse databases - Provide production support for Data Warehouse issues such data load problems, transformation translation problems - Support and maintain existing ETL processes for Data Warehouse - Effectively utilize standard enterprise tools to develop or implement technical solutions; - Document ETL and data warehouse processes and flows - Adhere to standards and best practices, processes, and deliverables in accordance with modern standards - Develop automated data audit and validation processes - Work closely with business analysts to understand requirements and develop solutions.

Greensboro, Nc, United States

Design, model and implement Data Warehouse and Data Mart: tables, indexes, procedures, and packages Develop SSIS packages to load Data Warehouse and Data Mart tablesCreate and maintain reports meeting requirements of end users using SSRSCreated and Manage OLAP Cubes using SSAS Performance tune SQL queriesPerform index maintenance and backupsCreate PowerShell scripts to automate tasks

Greensboro, North Carolina

• Responsible for database support, troubleshooting, planning and migration• SQL Server Upgrades and Patching• Creation and scheduling of maintenance plans (database backups and log backups)• Implementation of SQL Logins, Roles and Authentication Modes • Set up and maintain high availability of databases using Replication/Mirroring• Use SSIS to extract data from multiple sources and use SSRS to create reports• Create PowerShell scripts to automate tasks• Create stored procedures, views, functions, triggers and synonyms to be used in new databases• Performance tuning• Design ETL processes for other developers to follow to ensure data is transformed and loaded into databases correctly