24159 jobs - 663 added today
Recruiting? Call us on 786-433-7120
Email me newest jobs similar to this one
3 months ago
Salary band: $10k - $15k
Location: North America, United States, Texas, Dallas
Job type: Permanent
Contact: Ayava Staffing Professionals
Category: Engineer
Job Description:

Job: Junior ETL Engineer Salary range: $80,000 to $90,000 Summary: Responsible for analyzing, configuring, maintaining and building existing and to-be-developed extract/transform/load processes for an existing data warehouse and daily data file exchanges with clients. Job roles:Design SSIS jobs and create reusable components to support the data exchange with our clientsConduct performance analysis and optimize SSIS jobs, custom SQL and T-SQL jobsWork with the data analyst team to understand the business requirements and in the validation of data that supports reportingDevelop scripts for data file processing and process integration tasks Skills we are looking for. Not all are required. 2+ years' experience implementing ETL for Data Warehouse and Business intelligence solutions 2+ years' experience in RDBMS design and development, and performance tuning 2+ years' experience with SSIS, 5+ years with DTS and T-SQL/ stored procedures required 2+ years' experience with scheduling ETL jobs using SQL Agent, and external scheduling tools Experience with MS SQL Server 2008 R2 database technologies Ability to read and write effective, modular, dynamic (parameterized) and robust code, establish and follow already established code standards, and ETL framework Experience using Business Intelligence Development Studio to build SSIS packages Excellent troubleshooting and optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, experience with change data capture, using expressions, scoping of variables, commonly used transforms, event handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling Solid understanding of fuzzy grouping, fuzzy lookup transforms, import and export column transforms Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS, and replacing ActiveX script tasks in DTS with the script task in SSIS. Familiarity with .NET and C# framework is a plus. Experience in designing jobs that can be easily promoted from one (development) environment to another (staging to production) seamlessly Familiarity with Web Services (Restful, WSDL, SOAP, RSS, XML) Accurate time estimation for completion of tasks Excellent written and verbal communication skills for team development and client relations Excellent analytical abilities and problem-solving skills Handle multiple projects concurrently while meeting deadlines without compromising quality

Company Description:

Ayava Staffing is helping it's client, a Dallas based company, named by The Dallas Morning News one of the Top 100 Places to Work in the Dallas Ft. Worth Metroplex in 2011, 2013, 2014 and 2015.

Here are some similar jobs for you to consider...

13 days ago
only 15 days until close
Jr. Construction Engineer (on site)
North America, United States, New Jersey
$10k - $15k
12 days ago
only 16 days until close
Sales Engineer - South Central
North America, United States, Texas, Dallas
$10k - $15k
12 days ago
only 16 days until close
VDC/ BIM Engineer
North America, United States, Texas, Houston
$10k - $15k

Email me newest jobs similar to this one

  Back to the top