ETL INFORMATICA TERADATA DEVELOPER

Capgemini
United States
2 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Compensation
$72,550.0 - $113,360.0
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology CA Workload Automation Ae Unix Databases Information Engineering Extract Transform Load (ETL) Data Security Data Warehousing Database Schema Dimensional Modeling Job Scheduling Unix Shell
+12 more
Microsoft SQL Server Performance Tuning SQL Databases Teradata SQL Enterprise Data Management Freeform SQL Data Ingestion Informatica Powercenter Information Technology Star Schema Data Pipelines Control M

Job description

  • Design, develop, and maintain ETL workflows using Informatica.
  • Perform data ingestion from multiple sources into enterprise data platforms.
  • Work with Teradata to develop, optimize, and manage database objects and queries.
  • Develop and maintain Unix shell scripts to support ETL processes.
  • Write and optimize queries in SQL (Teradata / SQL Server).
  • Ensure data quality, integrity, and performance across ETL pipelines.
  • Analyze and troubleshoot data-related issues and performance bottlenecks.
  • Collaborate with data architects, analysts, and business stakeholders to understand data requirements.
  • Support deployment, maintenance, and monitoring of ETL jobs in production environments.
  • Contribute to documentation of ETL processes and data workflows., in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Requirements

Do you have experience in UNIX?, We are seeking an experienced ETL - Informatica Teradata Developer to join our data engineering team. The ideal candidate will have a strong background in ETL processes, data ingestion, and database technologies, with hands-on expertise in Informatica and Teradata. This role involves designing, developing, and maintaining scalable data pipelines to support enterprise data solutions., * 4+ years of overall experience in data engineering or ETL development.

  • Strong hands-on experience with:
  • ETL development and data ingestion
  • Informatica PowerCenter (or equivalent)
  • Teradata database
  • Unix / Linux environments
  • SQL (including SQL Server)
  • Good understanding of the overall ETL landscape, including data warehousing concepts and best practices.
  • Experience in writing and optimizing complex SQL queries.
  • Strong problem-solving and analytical skills.
  • Ability to work independently and in a team-oriented environment.

Preferred Qualifications

  • Experience with performance tuning in Informatica and Teradata.
  • Knowledge of data warehousing concepts such as star schema, dimensional modeling.
  • Familiarity with job scheduling tools (e.g., Control-M, Autosys)., * Experience working in Agile environments.

Benefits & conditions

3.73.7 out of 5 stars Remote $34.88 - $54.50 an hour - Contract, Pulled from the full job description

  • Health insurance
  • Retirement plan
  • Vision insurance
  • Dental insurance, The pay range that the employer in good faith reasonably expects to pay for this position is $34.88/hour - $54.50/hour.

About the company

Our offered benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:49 min

Scaling technical teams to achieve enterprise software transformation

Torben Schramme · WWC 2021

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:03 min

Microsoft integrating native Unix coreutils into Windows environments

Chris Heilmann +2 · LIVE

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · WWC Europe 2026

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

2:04 min

Defining timestamps and the international standard format

Denny Biasiolli Denny Biasiolli · Europe 2026 Virtual

Videos

See all

Related articles

See all