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:

    ETL

  • Job Title:

    ETL Developer

  • Location:

    Lawrence,KS

  • Duration:

    10 Months

  • Domain Exposure:

    Healthcare, Aerospace/ Airlines, Oil & Gas

  • 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

Responsibilities



    • Create, modify or reuse the Informatica Mapping, session, workflows and transformations
    • Create reusable component in informatica like mapplet, worklet, re-usable transformations etc.
    • Proven experience in working with different Informatica transformations like Joiner, lookup, aggregator, sorter, Normalizer, Java transformation, XML Transformations etc.



    • Deploy Informatica code and database objects to Higher environment.
    • Troubleshoot existing Informatica mappings for errors and suggest for its improvement.
    • Create and maintain database script for database design and deployment.
    • Create Audit Control Tables to track the ETL load and ETL load issues.
    • Write complex Sql queries with multiple joins for loading data into EDW and DataMart’s
    • Troubleshoot and suggest improvement in sql queries for better performance
    • Work individually with client BA and Data Architect team without any or very minimum help
    • Support and enhance existing ETLs and backfill issues that are fixed
    • Should be able to individually design an ETL Solution with Informatica, Oracle and Unix And can work on end to end implementation of the ETL project with no or minimal help

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