SSIS Developer in El Paso, TX at BCforward

Date Posted: 3/25/2020

Job Snapshot

Job Description

SSIS Developer

BCforward is currently seeking highly motivated SSIS Developer(Remote)

Title: SSIS Developer

Expected contract duration: 06+ months(Contract) with extension or permanent depending on performance of the candidate and client needs

Location: Remote

Job Responsibilities:

  • 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 ER/Studio.
  • Develops new code to obtain data from sources and move it through the data warehouse layers using the MS BI stack including SSIS, T-SQL/stored 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:
  • How to receive, load and archive text data files;
  • How to ingest/unpack 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
  • 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.

Required Experience:

  • 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 Server/T-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 (Kimball/Inmon), 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 distributed/remote team environment
  • Proven strong problem-solving skills, troubleshooting, and root cause analysis.

About BCforward:

BCforward began as an IT business solution and staffing firm. Founded in 1998, BCforward has grown with our customers' needs inta full-service personnel solution's organization. Headquartered in Indianapolis, Indiana, BCforward alsoperates numerous delivery centers across North America and India. We are currently the largest consulting firm and largest MBE certified firm in Indiana. Our uninterrupted growth has allowed BCforward tdeliver uniquely configured IT staffing and project solutions for over years of catering tour customers' specific needs. BCforward currently maintains a team of over 5000 global resources. With our additional brand, Stafforward, together we have the capabilities tdeliver services for a variety of industries in both public and private sectors which allows us taddress your most challenging needs.

www.BCforward.com

Interested candidates please send resume in Word format Please reference job code 104975 when responding to this ad.


CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs