ETL Informatica & Hadoop Engineer — Data Warehousing & Big Data

Envision Technology Solutions

Plano (TX)

On-site

USD 90,000 - 150,000

Full time

39 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Envision Technology Solutions in Plano, TX seeks an experienced ETL Informatica Developer to design, implement, and optimize ETL pipelines. The role requires hands-on experience with Informatica PowerCenter, Oracle, SQL, and modern Big Data tools.

You will work in an Agile environment, integrate diverse data sources, and ensure data quality for BI initiatives. The candidate should have a strong foundation in data warehousing, JSON/XML transformations, and job scheduling with AutoSys.

Qualifications

  • Bachelors or Masters in computer science or related field.
  • Demonstrated extensive experience in ETL development using Informatica, Oracle, and SQL.
  • Design, develop, and maintain ETL processes using PowerCenter or other Informatica tools.
  • Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, and Oozie.
  • Apply experience with Spark, Kafka, and NoSQL databases.
  • Work effectively within Agile methodology.
  • Use code-versioning tools such as Bitbucket.
  • Use SQL/PLSQL to extract, transform, and load data.
  • Apply advanced transformations, including data transformations and parsing JSON/XML messages.
  • Use job-scheduling tools such as AutoSys.
  • Integrate data from various sources while ensuring data consistency and quality.
  • Design and maintain data warehouses to support business intelligence activities.
  • Optimize SQL scripts and queries for speed and efficiency.
  • Identify and resolve issues in ETL processes.
  • Create and maintain technical documentation for ETL processes.

Responsibilities

  • Design, develop, and maintain robust ETL pipelines.
  • Collaborate with cross-functional teams to implement data integration solutions.
  • Optimize queries and ETL performance for large datasets.
  • Ensure data quality and provide documentation for ETL processes.
  • Support BI activities by designing data warehouses.

Skills

ETL Development
Informatica
SQL
Oracle
Spark
Kafka
NoSQL
Agile
Data Modeling
JSON/XML Parsing

Education

Bachelors/Masters in CS

Tools

Informatica PowerCenter
Bitbucket
AutoSys
Hadoop
Spark
Kafka
Oozie
Sqoop
Zookeeper

Job description

Envision Technology Solutions in Plano, TX seeks an experienced ETL Informatica Developer to design, implement, and optimize ETL pipelines. The role requires hands-on experience with Informatica PowerCenter, Oracle, SQL, and modern Big Data tools.

You will work in an Agile environment, integrate diverse data sources, and ensure data quality for BI initiatives. The candidate should have a strong foundation in data warehousing, JSON/XML transformations, and job scheduling with AutoSys.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Informatica & Hadoop Engineer | Big Data Innovation
ETL Informatica & Hadoop Engineer | Big Data Innovation

Tata Consultancy Services Limited • Plano (TX)

On-site
USD 95,000 - 120,000
Senior ETL Informatica Engineer
Senior ETL Informatica Engineer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
ETL Informatica/Hadoop Developer
ETL Informatica/Hadoop Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 90,000 - 150,000
Informatica PowerCenter ETL & BI/DW Developer
Informatica PowerCenter ETL & BI/DW Developer

Eros Technologies Inc. • King of Prussia (PA)

On-site
USD 95,000 - 135,000
ETL Data Warehouse Engineer - Informatica & PL/SQL
ETL Data Warehouse Engineer - Informatica & PL/SQL

Orabase Solutions • Florida

On-site
USD 80,000 - 120,000
ETL/Informatica Admin - PowerCenter & DataStage
ETL/Informatica Admin - PowerCenter & DataStage

kozmetickesluzby.vecnakraska.sk - Jobboard • Dallas (TX)

Hybrid
USD 110,000 - 130,000
Etl Informatica/hadoop Developer
Etl Informatica/hadoop Developer

Tata Consultancy Services Limited • Plano (TX)

On-site
USD 95,000 - 120,000
Senior ETL Developer – Informatica & Data Warehouse
Senior ETL Developer – Informatica & Data Warehouse

Valiant Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL & Data Warehouse Engineer — Informatica PowerCenter
ETL & Data Warehouse Engineer — Informatica PowerCenter

Jobsbridge • Pleasanton (CA)

On-site
USD 80,000 - 100,000