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:

    New York,NY

  • Duration:

    6 Months

  • Domain Exposure:

    Healthcare, Aerospace/ Airlines, Real Estate

  • 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:

  • Deploys code across Dev, QA and Production environments using central repositories
  • Develops/Maintains/Supports new and existing data flows from multiple source systems
  • Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc.
  • Troubleshoots/debugs ETL and SQL query issues and provides solutions
  • Develop views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data and as required by the functional team
  • Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture, etc.
  • Assists in the design and creation of logical and physical data models for reporting databases
  • Produces data flow diagrams and other documentations and diagrams as needed
  • Works with Director and Project Manager to develop and follow project plans and resource estimates. Works with Reporting team and data integration team to define and develop user data requirements
  • Integrates, collaborates and leads projects, working hand in hand with Business Analysts, Data Warehouse team and DBA and the infrastructure team
  • Works with functional team to assist in the preparation of source to target data maps. Work with project team and collaborate with both reporting application developers and OLTP technical leads.
  • Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope

Required Skills:

  • Expert in SQL and stored procedure for development, debugging and implementing complex transformation
  • Needs to be a self-starter and able to lead ETL projects or ETL activities within a project
  • Familiarity with Systems Development Life Cycle (SDLC) and software development best practices
  • Development experience with two ore more of the following: SQL, PL/SQL, TSQL, PERL, SQL Server, Oracle
  • Experience in the implementation of Web applications in a Unix/Linux environment, including knowledge of scripting languages and standard tools and utilities
  • Demonstrated ability to work in a fast-paced, deadline driven environment
  • Demonstrated excellence in a variety of competencies including teamwork/collaboration, analytical thinking, communication and influencing skills, and technical expertise
  • Experience collaborating with DevOps, Security, Network, Systems and other IT teams
  • Excellent written and verbal communication skills
  • Ability to work with changing priorities and with multiple projects
  • Ability to be precise and attentive to detail is essential
  • Ability to work with minimal supervision
  • Ability to work weekend and off-hour work

Preferred Skills:

  • Experience in Higher Education a plus
  • Knowledge in Perl, C or Python to create ETL solutions
  • Knowledge in SAP Business Objects Web Intelligence and Crystal Reports
  • Knowledge in emerging technologies, such as Big Data, Cloud computing (AWS or Azure)
  • Experience in agile software development methodology
  • Experience with Django framework

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