W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    Data Analyst

  • Job Title:

    Data Analyst

  • Location:

    Johnston,IA

  • Duration:

    6 Months

  • Domain Exposure:

    Healthcare, Banking & Finance, Telecom

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Job Description:

Overview of Position:

  • Translates Business Rules and Requirements into analytical models
  • Analyze, document and communicate source system data structures as well as explicit and implicit dependencies within and between data sources
  • Works with Requirements Analyst, Data Architect, Data Modeler and the ETL Team to translate Business Rules into Technical Requirements for ETL processes
  • Ability to drive the Source to Target Mapping Specifications process
  • Drive the understanding/validation of data
  • Discover/Mitigate/Validate problematic data and communicate with Source Teams and Data Warehouse Team
  • Develop Data Migration solutions for disparate data sources
  • Define and communicate cleaning and filtering requirements on data sources
  • Identify integration points of new data sources with existing data and define integration mappings
  • Develop ETL Mappings using SQL, Informatica, AWS, MPP Databases like Teradata, Exasol, Snowflake, Redshift or others.

Required Skills:

  • Data Warehouse Development & Design Experience
  • Experience writing Source To Target mapping documents for ETL/ELT logic
  • Experience with SQL and Python
  • Experience working on ELT Technologies like Informatica
  • Cloud Data Warehousing experience on AWS and any MPP Databases like Teradata, Snowflake, Exasol, Redshift etc.
  • Strong understanding of scientific data and translating them to SQL Logic to load the data to our Cloud Data Warehousing platform.
 

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract