SQL/ETL Developer
Alpharetta, GA, United States
Must Have Skills : SQL Server development in 2012, 2019 CTEs,
Stored procedures,
UDF,
Database development SSIS package development,
DB job debugging ETL
Job duties: Translate user business requirements into program specifications.
Create database objects Tables, Views, User defined functions, Store procedures, Joins, Dynamic SQL, Indexed Views, Daily Jobs and Workflow objects.
Developed business logic workflows in SQL Server using stored procedures, UDFs, views, temp tables, table variables, for loops, CTEs.
Performance tuning on database Objects to achieve optimal data retrieval/updates using SQL Profiler, Execution plan.
Execute SQL Task and Data Flow Tasks were used extensively as part of ETL packages.
Monitoring daily database jobs, data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting.
Prepare Unit, Integration and System test plans and execute and log results.
Analyze and fix bugs in the existing system.
Create documentations and follow standards and methodology as defined by the project manager.
Desired Skills : Google Cloud Platform (GCP) C# Scripting