Sara G
ETL /SQL DEVELOPER
- Role
- Sr Sql Bi Developer at The Home Depot
- Location
- Baltimore, MD, US
- LinkedIn followers
- 500 followers
About Sara G
Over 7+ years of IT experience in Database Design, Development, Implementation, and…
Experience
Sr Sql Bi Developer
Feb 2020 — Present · US
Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes, and functions.• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.• Created complex T-SQL queries, Stored procedures for data extraction.• Applied various business logic to Scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user-defined functions, and ad-hoc queries.• Designed a number of SSIS packages for data transfer between flat files, XML, SalesForce, Oracle, MYSQL, and SQL Server using different transformations like Lookup, Derived Column, Conditional Split, Merge Join, Fuzzy Lookup, Script Component.• Involved with application team in developing VB Script, C#, and ASP.Net, VB.Net, and.Net framework creation in SSAS and SSIS.• Created SSIS Templates for developing SSIS Packages, Implemented SQL Server configurations, and error handling in SSIS Packages.• Deployed SSIS Projects/Packages to Testing and Production environments. Have performed scheduling and administrating SSIS Packages.• Enabled CDC on the existing OLTP tables for continuous integration into a data mart and created Power BI reports for stakeholders.• Involved in testing SQL Scripts for report development, SSRS, Dashboards, Scorecards and handled the performance issues effectively.• Involved in developing graphs using appropriate transformations for implementing the business logic in data loading• Created materialized views as per business requirements and wrote a number of the stored procedures and dynamic SQL.• Designed SSIS Packages to cleanse, remove duplicates, and matching data through Data Quality Services• Involved in Creating Back up Strategies and implementing Disaster Recovery
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.