IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
13820 New York, NY 11435 DW / ETL Developer: OWB, Data Marts, data modeling, SSIS DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
1187-MH2857@apply.maxhire.net    

Subject=IIT Career Site/Resume for JobID=13820 (DW / ETL Developer: OWB, Data Marts, data modeling, SSIS) in New York NY 11435 (SJU)

Estimated Length: 12 Months Work hours:40.00 Est. OT Hrs/Wk:

*PLEASE NOTE THAT THIS POSITION WILL INITIALLY ALLOW FOR WORK TO BE PERFORMED REMOTELY. HOWEVER, CONSULTANT MAY BE REQUIRED TO WORK ON-SITE/IN-OFFICE ONCE COVID RESTRICTIONS ARE LIFTED AT A FUTURE TIME. QUALIFIED CANDIDATES SHOULD BE MADE AWARE BEFORE APPLYING.

Requirements

Develop ETL jobs to move data between source systems and data warehouse to meet the data requirements. Build into the pipelines, the required data transformations. Rewrite Oracle Warehouse builder package code in currently supported set of tools including SSIS, Azure Data factory, Python in the effort to migrate on-prem Oracle based data warehouse to Azure SQL Managed instance/Synapse Analytics. The ideal candidate would have the following skill sets:

  • A deep understanding of relational database technologies, dimensional Modeling, Operational Data Stores, Enterprise Data Warehouses and Data Marts.
  • Significant experience with data modeling (conceptual, logical and physical model design), architecture, and performance optimization.
  • Expert level understanding of ETL fundamentals and building efficient data pipelines using Extract Transform Load (ETL) tools such as SSIS.
  • Experience with cloud data movement and compute technologies including Azure Data Factory, Logic App, Data Bricks and storage technologies including Azure Managed instance, Azure Data Lake, Azure synapse analytics.
  • Experience with major database platforms including Oracle, SQL Server as well as Cloud databases. NOSQL experience is a plus.
  • Advanced data processing, programming skills using SQL-based technologies, as well as other languages like Python.
  • Experience in modern DevOps practices (including Git, CI/CD)
  • Experience designing, enhancing, and/or modifying data warehouses
  • Functional knowledge of Microsoft Power BI
 
Submit Resume For This Job (via email)
 
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
 
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer