Client: Telecom

Job Title: SQL/ETL Developer

Duration: 6-12 Months Assignment with possible extension

Location: 5055 North Point Pkwy, Alpharetta, GA 30022

Notes: Hybrid

Job Description:

• SQL/ETL Developer To support Employee Engagement Platforms

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.

MUST HAVE SKILLS:

• SQL Server development in 2012, 2019 CTEs, Stored procedures, UDF, Database development SSIS package development, DB job debugging ETL

DESIRED SKILLS:

Google Cloud Platform (GCP) C# Scripting.