22 days old
2017-11-022017-11-30

ETL Developer (SSIS)

Rolling Meadows, IL 60008
  • Job Code
    585797
  • Payrate
    $110,000 To $120,000

The Individual must demonstrate broad and deep knowledge of ETL development in a dimensional database environment while using the MS SQL Server SSIS and other BI tools (like Cognos Data Manager). Candidate will be responsible for designing, developing, testing and troubleshooting SSIS packages or Cognos Data Manager that implement complex ETL processes. Must be able to understand and analyze requirements and develop, deploy and configure ETL code. The individual will use their SQL Server 2012 experience to implement robust, maintainable solutions that meet business requirements.



  • Solidify and extend existing ETL SSIS Framework or Cognos Data Manager ETL code
  • Design of MS SQL Server 2012 SSIS jobs, and reusable components to implement specified business requirements
  • Troubleshoot and optimize ETL code; interpret ETL logs, perform data validation, dissect SSIS code, understand the benefits and drawbacks of parallelism, apply best practices using change data capture, expressions, scoping of variables, commonly used transforms, event handlers and logging providers, understand and optimize the surrogate key generation and inconsistent data type handling
  • Create technical specifications documents and design process diagrams
  • Develop functional specifications for data acquisition, transformation and load processes
  • Develop scripts for data file processing and process integration tasks
  • Define job parameters, reference lookups, filter criteria
  • Conduct code reviews and participate in technical design
  • Conduct performance analysis and optimize SSIS jobs, custom SQL and T-SQL jobs
  • Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results
  • Support BI Team during functional, UAT, regression, and performance testing


Qualifications


Required:



  • 5+ years experience implementing ETL for Data Warehouse and Business intelligence solutions
  • Familiarity with Cognos Data Manager ETL tool
  • 10 year experience in RDBMS design and development, and performance tuning
  • Deep familiarity with MS SQL Server 2008 R2 to MS SQL Server 2012 database technologies
  • 3+ years with SSIS, 5+ years with DTS and T-SQL/ stored procedures required
  • 5 years experience with scheduling ETL jobs using SQL Agent, and external scheduling tool

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

ETL Developer (SSIS)

Randstad Technologies
Rolling Meadows, IL 60008

Share this job

ETL Developer (SSIS)

Randstad Technologies
Rolling Meadows, IL
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast