Etl Developer

TEKsystems; Newport Beach (CA); On-site; USD 114,616,320 - 128,943,360; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Short and long-term disability

Health Spending Account (HSA)

Transportation benefits

Employee Assistance Program

Time Off/Leave (PTO, Vacation or Sick)

Job summary

TEKsystems is seeking an Entry Level ETL Developer to join a data engineering team in Newport Beach, CA. You will develop and maintain enterprise-scale data integration pipelines using Informatica PowerCenter/IDMC, AWS services, and Python/Perl scripting.

The role emphasizes building reliable data moves, scheduling, testing, and production readiness. The position offers a contract arrangement with onsite work and a pay range of $40.00–$45.00 per hour, with a comprehensive benefits package.

Qualifications

• 3-7+ years of ETL development experience.
• Experience with Informatica PowerCenter and/or IDMC/IICS.
• Experience building data integration and ETL solutions.
• Strong Python and/or Perl scripting skills.
• Experience with Oracle and Snowflake.
• Familiarity with AWS services and cloud-based data environments.
• Experience working with SFTP and API integrations.
• Knowledge of enterprise scheduling and batch processing tools.

Responsibilities

• Develop and maintain reliable data integration pipelines and data movement processes.
• Support and optimize data pipelines across enterprise data environments (Oracle, Snowflake).
• Assist with enterprise job scheduling and orchestration activities (job creation, dependencies, batch monitoring).
• Participate in unit, integration, and regression testing and data validation.
• Ensure solutions are production-ready and thoroughly tested.

Skills

ETL development

Informatica PowerCenter

Informatica IDMC/IICS

Python scripting

Perl scripting

AWS services

SFTP integrations

REST/API integrations

Oracle

Snowflake

AWS Transfer Family

AWS Lambda

Metadata-driven ETL frameworks

Tools

AWS Transfer Family

REST API tooling

Metadata-driven ETL tooling

Job description

We're seeking a highly motivated Entry Level ETL Developer to join a dynamic data engineering team responsible for building, enhancing, and supporting enterprise-scale data integration solutions. This role offers the opportunity to work with modern cloud technologies, large-scale data platforms, automation tools, and cross-functional teams that drive critical business operations.

The Entry Level ETL Developer Develop and maintain reliable data integration pipelines and data movement processes using technologies such as:

• Informatica PowerCenter
• Informatica IDMC / IICS
• AWS Transfer Family
• AWS Lambda
• Python and Perl scripting
• SFTP-based integrations
• REST/API integrations
• Metadata-driven ETL frameworks
• Enterprise data processing pipelines

Work with Modern Data Platforms Support and optimize data pipelines across enterprise data environments, including:

• Oracle
• Snowflake

Scheduling & Batch Operations Assist with enterprise job scheduling and orchestration activities, including:

• Job creation and maintenance
• Dependency management
• Batch monitoring and validation
• Troubleshooting failed or delayed processes
• Root cause analysis and issue resolution

Testing & Quality Assurance Participate in:

• Unit testing
• Integration testing
• Regression testing
• Data validation
• Release readiness activities

Ensure solutions are thoroughly tested and production-ready.

Required Experience

• 3-7+ years of ETL development experience
• Experience with Informatica PowerCenter and/or IDMC/IICS
• Experience building data integration and ETL solutions
• Strong Python and/or Perl scripting skills
• Experience with Oracle and Snowflake
• Familiarity with AWS services and cloud-based data environments
• Experience working with SFTP and API integrations
• Knowledge of enterprise scheduling and batch processing tools

Preferred Qualifications

• AWS Transfer Family experience
• Experience supporting production environments
• Experience with metadata-driven ETL frameworks
• Exposure to modern cloud-native architectures

Job Type & Location

This is a Contract position based out of Newport Beach, CA.

Pay and Benefits

The pay range for this position is $40.00 - $45.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms.

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully onsite position in Newport Beach,CA.

Application Deadline

This position is anticipated to close on Jul 31, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance

Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI)

We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.