ETL INFORMATICA TERADATA DEVELOPER

Capgemini
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 113K

Job location

Remote

Tech stack

Agile Methodologies
CA Workload Automation Ae
Unix
Databases
Information Engineering
ETL
Data Security
Data Warehousing
Database Schema
Dimensional Modeling
Job Scheduling
Shell
Microsoft SQL Server
Performance Tuning
SQL Databases
Teradata
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

Capgemini ist einer der weltweit führenden Anbieter von Management- und IT-Beratung, Technologie-Services und Digitaler Transformation. Als ein Wegbereiter für Innovation unterstützt das Unternehmen seine Kunden bei deren komplexen Herausforderungen rund um Cloud, Digital und Plattformen.

Apply for this position