ETL Developer ( W2 only - no C2C, no 3rd parties )

System One Holdings, LLC

$90K — $110K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6-8 years of experience in relational database design with Oracle and Teradata.
  • Proficient in Informatica and knowledgeable in ETL development.
  • Strong skills in designing, building, and testing ETL applications.
  • Experience with enterprise data warehouses.
  • Familiar with data extraction from DB2, Oracle, and flat files.
  • Strong SQL experience and familiarity with stored procedures.
  • Experience in a Linux environment and Shell scripting.

Responsibilities

  • Serve as a technical expert on large-scale digital development projects.
  • Collaborate with Product Owners and Subject Matter Experts to build workflows.
  • Schedule jobs and manage data processes effectively.
  • Support end-users with business queries and requests.
  • Review deliverables to identify gaps and suggest improvements.
  • Maintain knowledge of standards and trends in Data Integration and Architectures.
  • Design and develop logical and physical data models.

Benefits

  • Opportunity to work on a substantial digital development project.
  • Collaborative environment with on-shore and off-shore teams.
  • Exposure to advanced tools like Informatica and Tableau.
  • Potential for ongoing professional development in a technology-rich setting.
Full Job Description
ETL Developer

This position requires someone to be onsite in an office work setting five days a week in Pittsburgh, PA, Cleveland, OH, or Dallas, TX.

Looking for an intermediate-level ETL developer. This candidate should seamlessly utilize Informatica, Oracle, Teradata and Tableau with the latest in responsive database, Informatica ETL and Tableau reports. The ideal candidate will have a can-do attitude, passion for technology, extensive development experience. This candidate will serve as a technical expert of a large-scale digital development project consisting of both on-shore and off-shore developers. The ETL Developer will work together with Product Owners, Subject Matter Experts and Technical Managers to build workflows and schedule jobs.

Qualifications :
. 6 - 8 years of experience working in relational database design with Oracle and Teradata
. Proficient in Informatica, with a good knowledge of ETL development
. Strong experience in design, building and testing the Extract, Transform, and Load (ETL) applications
. Experience working with enterprise data warehouses
. Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files
. Familiarity with database stored procedures
. Strong SQL experience required
. Experience working in Linux environment and Shell scripting
. Provide end-user support including business queries and requests.
. Provides reviews of the deliverables and identifies gaps and areas of improvement.
. Maintain in-depth and up-to-date knowledge of standards, guidelines, and industry trends for Data Integration, Data Migration and Architectures.
. Fulfil and design the development for logical data models as well as physical data models.
. Strong agile/scrum development experience

#LI-DP1

#M1

Ref: #404-IT Pittsburgh

Similar Jobs

More Jobs at System One Holdings, LLC

More Information Technology Jobs

Find similar ETL Developer ( W2 only - no C2C, no 3rd parties ) jobs: