ETL Developer / SSIS Developer - Chicago, IL (Currently Remote)

ETL Developer / SSIS Developer - Chicago, IL (Currently Remote)

09 Jun 2024
Illinois, Chicago, 60290 Chicago USA

ETL Developer / SSIS Developer - Chicago, IL (Currently Remote)

Vacancy expired!

Job Title: ETL SQL Developer / SSIS Developer

Location: Chicago, IL (Currently Remote)

Exp: 8+yrs

Job Description:

Requirements:
  • Min 8-10 yrs. of SSIS, ETL & SQL Development
  • Knowledge of MS SQL Server 2012 or later
  • Experience with SSRS, SSIS, T-SQL; develop SSIS packages
  • Strong Data analysis and data migration script creation experience
  • Min. 1-2 ERP Data Conversion experience
  • Good to have a person who has previously worked on some ERP Master data conversion specially from iSeries / IBM Mainframe flat files as source to SQL Server tables
  • Experience with data conversion, transformation, and query optimizations
  • Proficient in system analysis, debugging and defect fixing.
  • Excellent written and verbal communications
  • Ability to work in a team environment and client interfacing skills

Responsibilities:
  • Design and implementation of SSIS, and ETL based on business requirements
  • Strong problem-solving and analytical skills. Able to understand business requirements and develop SQL Server solutions that work within the technical boundaries
  • Good understanding of data warehouse and ERP / financial applications
  • Analyzes large data sets. Develops ETL mapping and logic.
  • Write SQL and T-SQL scripts/statements to analyze and translate legacy ERP data into new ERP platform
  • Interface directly with the business analysts, product owners to define mapping specifications based on data analysis
  • Create, debug, and execute T-SQL scripts and stored procedures that match data mapping specifications
  • Strong Knowledge of Microsoft SQL Server 2012 and 2014 (knowledge of Microsoft SQL Server 2005 and 2008 a plus)
  • Perform ETL (extract, transform, load) data imports, exports, and modifications
  • Perform quality assurance and database validation on all test and live conversions
  • Work on assigned tasks as a member of a project team as required
  • Review data and database backups
  • Ability to deal with ambiguity. Make decisions based on the information you have, even if that is not the whole picture.
  • Ability to learn on the fly. Quickly and effectively integrates new information and skills to enhance personal performance or the performance of the organization. Learns from successes and failures, regards all experience as an opportunity to learn and improve
  • Creates jobs for batch and real time processing of data from internal and external sources.
  • Supports software applications/operating systems through data research and debugging.
  • Participates in the testing process through test review and analysis, test witnessing and certification of data.
  • Inserts, Exports and Queries in data in stream and data lake technologies.
  • Works with Relational DB and Data Object models.
  • Experience in relational database design, development, support, and maintenance
  • Hands-on experience with MS SQL Server, SSMS, SSIS, SSRS
  • Strong Relational DB understanding
  • Intermediate to advanced SQL skills
  • Expert in SQL design, development, and automation
  • Conceptual, Logical and Physical data modeling
  • Experience handling large data files and datasets
  • Able to communicate with application technical leads and business users
  • Ability to roll up sleeves, dig in and figure out complex problems
  • Strong business acumen


Related jobs

Job Details

  • ID
    JC15275843
  • State
  • City
  • Job type
    Contract
  • Salary
    $50 - $60
  • Hiring Company
    Unicorn Technologies LLC
  • Date
    2021-06-07
  • Deadline
    2021-08-06
  • Category

Jocancy Online Job Portal by jobSearchi.