Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Rochester, NY
View more jobs in New York

Job Details

Database Developer MS SQL

Location
Rochester, NY

Apply for this job






5 hit(s)  

Profile

Database Developer (MS SQL)
in
Rochester
New York
Database Developer (MS SQL)
job details:
location:Rochester, NY
salary:$45 - $65 per hour
date posted:Tuesday, June 12, 2018
job type:Contract
industry:Professional, Scientific, and Technical Services
reference:626438
job description
Database Developer (MS SQL)
Are you looking to make a significant impact within an enterprise data warehouse? In this role, you will have the ability to get your hands on a clean slate data warehousing project! There is a lot going on within this growing global company!
Summary:
The ETL Developer responsibilities include designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company. This means that the ETL Developer needs to be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals. Candidates must have an advanced knowledge of SQL Server, SSIS Catalog, SSIS, T-SQL, and some data modeling experience. Database designs take on many forms, including dimension models and data vault models. The ETL Developer will work in a team with other ETL, BI and Database developers.
Responsibilities:
Design and implement scalable and appropriately normalized models depending on the database layer
Understand the various layers of the data warehouse and how data flows between them
Design and develop scalable and dynamic ETL code using SSIS/T-SQL that requires little overhead with the passing of time
Develop stored procedures that reflect business rules and properly handling transaction committing failures
Identify and test for bugs and bottlenecks in the ETL code in order to deploy the most performant code
Mindful of data quality and timeliness of data availability in the data warehouse
Work with other ETL, BI and Database developers to deliver the business the requested data warehouse solutions
Required Skills and Experience:
Proficiency with SQL Server, T-SQL and writing stored procedures
Proficiency with SSIS and the SSIS Catalog
Experience with Master Data and Data Quality services
Experience in identification of data quality
Dimensional modeling experience
Data Vault modeling experience
Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, PSA, Staging, and Data Warehousing including Data Marts and Data Vaults
Some knowledge of C#, PowerShell for scripting is a plus
Proficient in how to deploy to and debug a production SSIS environment
Exceptional problem solving skills
Excellen interpersonal, written, and oral communication skills
Strong technical documentation skills
Excellent business acumen
Self-motivated and directed, with good attention to detail
Required Education and/or Credentials:
BE or BS degree in one of the following subject areas: Computer Science, Computer Engineering, Information Technology, or related field preferred.
3-5 years of experience as a ETL Developer with strong understanding of data warehousing architectures, theories, principles, and practices.
3-5 years of experience with SQL Server, T-SQL, SSIS
Some scripting experience using C# and PowerShell preferred
Apply Now
Randstad
Randstad Jobs
Apply Now
Share

Company info

Sign Up Now - CPlusPlusCrossing.com

By using Employment Crossing, I was able to find a job that I was qualified for and a place that I wanted to work at.
Madison Currin - Greenville, NC
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
CPlusPlusCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
CPlusPlusCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 CPlusPlusCrossing - All rights reserved. 21