data engineer.

• charlotte , north carolina

• posted 3 days ago

job details

summary

• $50 - $55 per hour

• contract

• bachelor degree

• category computer and mathematical occupations

• reference1056719

job details

job summary:

location: CHARLOTTE, North Carolina

job type: Contract

salary: $50 - 55 per hour

work hours: 8am to 4pm

education: Bachelors

responsibilities:

• Demonstrate strong and hands-on experience and background in database principles and concepts

• Solid understanding of data modeling, data warehousing principles, best practices

• Expertise in SQL writing by incorporating Joins, Aggregations, Common Table expressions, Analytical functions etc.

• At least 8 years of hands-on experience with at least one of the databases including Postgres, Oracle, DB2, Sybase etc.

• Ability to write efficient code in Python.

• Proficient in database performance tuning including indexing, partitioning, analyzing SQL plans etc.

• Expertise in Extract-Transform-Load(ETL)/Extract-Load-Transform(ELT) concepts with clear understanding in each of the stages

• Consulting with data management teams to get a big-picture idea of the company's data storage needs.

• Data Analysis

• Data Science

• Ability to read diagrams and create models.

• Designing and coding the data warehousing system to desired company specifications.

• Conducting preliminary testing of the warehousing environment before data is extracted.

• Extracting company data and transferring it into the new warehousing environment.

• Testing the new storage system once all the data has been transferred.

• Troubleshooting any issues that may arise.

• Design and Development of various database objects like tables, stored procedures, functions, jobs, ETL routines, etc.

qualifications:

• Experience level: Experienced

• Minimum 5 years of experience

• Education: Bachelors

skills:

• UNIX (7 years of experience is required)

• SQL Server (6 years of experience is required)

• Oracle (6 years of experience is required)

• ETL (6 years of experience is required)

• Python (6 years of experience is required)

• SQL (6 years of experience is required)

• Cloud SQLEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.