What are the responsibilities and job description for the SQL ETL Developer position at Pyramid Consulting, Inc?
Immediate need for a talented SQL ETL Developer. This is a 09 months contract opportunity with long-term potential and is located in Alpharetta GA (Hybrid). Please review the job description below and contact me ASAP if you are interested.
Job ID:25-63094
Pay Range: $55 - $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy [Link available when viewing the job].
#tel J2W:CB3
Job ID:25-63094
Pay Range: $55 - $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
- 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 SQLProfiler, 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.
- Key Skills:SQL, ETL, GCP .
- SQL Server development in 2012, 2019 CTEs, Stored procedures, UDF, Database development SSIS package development, DB job debugging ETL.
- Client Cloud Platform (GCP) C# Scripting.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy [Link available when viewing the job].
#tel J2W:CB3
Salary : $55 - $60
