SQL Data Integration Developer, 100% REMOTE
Company: CGS Business Solutions - INC 5000 Company
Location: Las Vegas
Posted on: June 24, 2022
Job Description:
CGS Business Solutions is committed to helping you, as an
esteemed IT Professional, find the next right step in your career.
We match professionals like you to rewarding consulting or
full-time opportunities in your area of expertise. We are currently
seeking Technical Professionals who are searching for challenging
and rewarding jobs for the following opportunity:Our Financial
client in Southern California is looking for a 100% REMOTE
(nationwide) PERM SQL Data Integration Developer to join a highly
skilled team of DW & BI Developers who are responsible for the
design, development, and maintenance of the company's databases and
data integration (ETL) systems that support business applications
and business intelligence for the nationwide company. This is a
Senior position to be performed under minimal supervision and
direction.Location: 100% remote Client highly prefers candidates to
work PST or MTN, may be willing to consider Central timezone hours
SKILLS and EXPERIENCE:
- 5+ years of SQL and SSIS Data Integration with a strong focus
on Relational databases, application and data integration (ETL)
(Data Warehousing and Business Intelligence preferred)
- 3+ years' strong working knowledge of ETL applications such as
Microsoft SSIS experience with ETL tools - SSIS.
- Strong with troubleshooting Production support issues and has
Integration/ Migration up to 2019 in SSIS and SSMS
- Previous experience with software development - Microsoft .NET.
desired
- Any experience with Scripting eg C#, JSON preferred; Python or
PowerShell would be a plus
- Strong working knowledge of enterprise database solutions using
Microsoft SQL Server
- Strong working knowledge of T-SQL programming and scripting, as
well as optimization techniques
- Working knowledge of C# programming and scripting
- Working knowledge of integrating applications using APIs -
worked with 3rd party SSIS integration tools such as CData,
Kingswaysoft or cozyroc and experience creating and utilizing WEB
API's with C# or JSON required
- Knowledge of Microsoft PowerApps and previous experience
building them out highly desired to help automate and create
workflows
- Worked with larger data sets and 100's of databases but focused
on 5 main ones themselves
- Someone who has experience enhancing and optimizing existing
processes
- Strong analytical, problem solving, collaboration and technical
skills
- Strong communication skills in order to gather requirements
from the business user groups and PMO and create solutions highly
desired
- In-depth knowledge of Software Development Life Cycle
(SDLC)
- Ability to understand, remember, and apply oral and/or written
instructions or other information
- Bachelor's degree or equivalence experience, preferably in
Information Systems or Computer Science.ESSENTIAL DUTIES AND
RESPONSIBILITIES:
- Work closely with management and end-users to create and
evaluate business requirements to support the delivery of effective
data solutions.
- Design, develop, optimize, maintain and support ETL processes
using Stored Procedures, SQL scripts, C# script and data
integration tools such as Microsoft SSIS
- Create technical designs and functional specifications for
backend and front-end information systems.
- Participate in the development and testing of database and
back-end processes to support system integration and ETL to
facilitate the creation and population of repository databases,
data marts, and other data integration solutions.
- Design, develop and deploy solutions to support integration
with enterprise applications, SaaS applications and other vendor
data.
- Create and maintain documentation of processes, databases,
applications, and procedures as per department policy.
- Support the design, planning, implementation, administration
and maintenance of the database and ETL platform.
- Participate in process automation projects by working with
users to understand their business process, designing and
developing solutions
- Maintain ETL process jobs and respond to critical data load
issues during off hours.About CGS Business Solutions:CGS
specializes in IT business solutions, staffing and consulting
services. With a strong focus in IT Applications, Network
Infrastructure, Information Security, and Engineering. CGS is an
INC 5000 company and is honored to be selected as one of the Best
IT Recruitment Firms in California. After five consecutive Fastest
Growing Company titles, CGS continues to break into new markets
across the USA. Companies are counting on CGS to attract and help
retain these resource pools in order to gain a competitive
advantage the rapidly changing business environments.
Keywords: CGS Business Solutions - INC 5000 Company, Las Vegas , SQL Data Integration Developer, 100% REMOTE, IT / Software / Systems , Las Vegas, Nevada
Didn't find what you're looking for? Search again!
Loading more jobs...