ElPasoRecruiter Since 2001
the smart solution for El Paso jobs

SSIS Developer

Company: Cosmos IT Solutions
Location: El Paso
Posted on: March 28, 2020

Job Description:

The SSIS Developer will provide design and development expertise on a project to build and to deploy a new SQL Server data warehouse. Primary tasks include designing, building, and maintaining data and metadata models and complex ETL packages. -Hands-on data-modeling experience within a traditional data-warehouse environment. Must have examples of models designed in either Erwin data modeler or ERStudio. -Develops new code to obtain data from sources and move it through the data warehouse layers using the MS BI stack including SSIS, T-SQLstored procedures, and batch files. -Analyzes, improves, and tunes existing scripts, ETL, dashboards, and reports. -Provides design recommendations the data warehouse data-model and structures which support analytical applications. -Must demonstrate an understanding of how to use a variety of data sourcing methods. Including (1) How to receive, load and archive text data files (2) How to ingestunpack incoming emails (a semi-structured source), move the email to the DW application server, and successfully create loads to put that data into the warehouse tables and (3) How to receive Excel spreadsheets via email, move the XSLX attachment to the DW application server, and successfully load the file into a warehouse table. Qualifications BS Degree CS or MIS or equivalent experience in related roles 5+ years of experience delivering solutions utilizing the Microsoft BI stack, with a direct experience with SSIS and batch file creation required. 5+ years of experience with SQL ServerT-SQL programming in creation and optimization of stored procedures, triggers and user defined functions. 5+ years of Microsoft SQL Server database development (TSQL) experience 5+ years of demonstratable experience working in a data warehouse environment (KimballInmon), and ETL concepts as seen in a traditional data warehouse environment (landing zone, stage tables, warehouse, data-marts, presentation) Experience with scheduling and automation tools is desired, with CA Workload Automation (AutoSys) the preferred tool. Working experience with SSRS is desired. Ability to excel in a collaborative and distributedremote team environment Proven strong problem-solving skills, troubleshooting, and root cause analysis.

Keywords: Cosmos IT Solutions, El Paso , SSIS Developer, IT / Software / Systems , El Paso, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Software Engineer (C++ or Java)
Description: Job DescriptionPeraton has an immediate opening for a Software Engineer who will join our team at the White Sands Complex in Las Cruces, NM. Your role in this position will include software requirements (more...)
Company: Peraton
Location: Las Cruces
Posted on: 03/29/2020

Entry Level Software Engineer
Description: As a leader in recruiting emerging technology talent across the country, Revature is looking forward to hiring over 300 new Entry Level Software Engineers in the next 4 weeks.One day someone is going (more...)
Company: Revature
Location: El Paso
Posted on: 04/2/2020

Software Engineer IV
Description: OverviewPeraton is seeking Software Engineering to join our team in White Sands, New Mexico to support our Space Exploration Network Services and Evolution contract. The successful candidate will be responsible (more...)
Company: Peraton
Location: Las Cruces
Posted on: 04/1/2020


In-Home Usage Tester (Product Tester from home) Part-time
Description: American Consumer Panels--, located at One World Trade Center, 285 Fulton St., Suite 8500 New York, NY, 10007, is looking to fill the position listed below nationwide : In-Home Usage Tester Product (more...)
Company: American Consumer Panels
Location: El Paso
Posted on: 04/3/2020

Senior Business Analyst, Oracle Service Cloud
Description: Senior Business Analyst, Oracle Service Cloud at Helen of Troy Nevada Corporation in El Paso, TX br br Work with the IT Shared Service team and organization SMEs subject matter experts to plan, (more...)
Company: Helen of Troy
Location: El Paso
Posted on: 04/9/2020

Data and Process Management/Developer Lead
Description: Description The Data and Process ManagementDeveloper Lead will support through organization and problem solving skills by re-designing data through new processes and or creation of databases. This positon (more...)
Company: SAIC
Location: El Paso
Posted on: 04/4/2020

Entry Level Software Developer
Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 Entry Level Software Developers across the country in the next 4 weeks.One day someone is going to ask you (more...)
Company: Revature
Location: Las Cruces
Posted on: 04/8/2020

Entry Level Software Engineer
Description: Revature is the largest employer of entry level technology talent in the US. We will hire over 300 new Entry Level Software Engineers
Company: Revature
Location: Las Cruces
Posted on: 04/1/2020

Entry Level Software Engineer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: El Paso
Posted on: 04/3/2020

Systems Administrator (Linux & Windows)
Description: Peraton is looking for a System Administrator who will be responsible for maintaining MS Windows and Red Hat servers and workstations, as well as demonstrate best IT security concepts and practices for (more...)
Company: Peraton
Location: Las Cruces
Posted on: 03/30/2020

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

El Paso RSS job feeds