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:

    Sr. ETL Application Developer

  • Location:

    Dallas,TX

  • Duration:

    6 Months

  • Domain Exposure:

    Insurance, Telecom, Aerospace/ Airlines, Education, Real Estate, IT/Software, Media/ Entertainment

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

Your daily activities include providing technical direction in the development and support of the Extract, Transform and Load (ETL) aspects of the data warehouse. Maintains an understanding of the inputs received from the data source providers. Performs analysis, design, development, and implementation of new ETL requirements. Supports testing and validation of the new data conversion processes. Responsible for planning, estimation and monitoring schedule milestones and deliverables for assignments. Possesses strong SDLC experience and manages appropriate levels of systems documentation as required. Create Data Pipeline and ETL solutions, delivering trusted, high quality data to the business.

 

Responsibilities



    • Collaborate with business analysts and subject matter experts to design and implement data integration solutions
    • Create solutions using standards, best practices to increase reliability, performance, simplicity, and overall quality of Data Pipelines
    • Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface.
    • Performance tuning of ETL jobs and related components
    • Report on, Measure, and Monitor Data Pipeline availability and performance to ensure KPIs and SLAs are met
    • Identify application bottlenecks and opportunities to optimize performance
    • Informatica PowerCenter 10.x configuration and support including installation, upgrades, performance tuning, etc.
    • Perform code version control activities



Qualifications 



    • 7+ years of work experience in delivering data integration solutions using ETL tools such as Informatica PowerCenter on Unix platforms
    • 5+ years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning
    • 3+ years of current and hands-on UNIX shell scripting experience.
    • 3+ years of current and hands-on experience with an enterprise job scheduler (Control-M, Autosys, Redwood, etc).
    • Experience with AWS Redshift, S3, EC2
    • Expert understanding of BI/DW system architectures, methodologies and data modeling
    • Current and hands-on experience with Informatica PowerCenter 9.x and higher on Unix platforms
    • Hands-on experience with AWS Redshift
    • Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshooting
    • Informatica Cloud
    • Informatica Big Data Edition
    • Informatica PowerCenter Adminstration
  • Big Data (Hadoop and Hive/Impala) Cloudera Distribution

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