ETL Informatica Developer

Envision Technology Solutions

Plano (TX)

On-site

USD 85,000 - 120,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Envision Technology Solutions seeks an experienced ETL Informatica Developer to design, build, and optimize ETL pipelines. You will work with Informatica PowerCenter and related tools to integrate diverse data sources, ensure data quality, and support BI initiatives.

The role requires hands-on experience with Hadoop ecosystem components, Spark, Kafka, and NoSQL databases in an Agile setting. The candidate will collaborate with cross-functional teams, implement data cleansing and transformations,

Qualifications

  • Demonstrated extensive experience in ETL development using Informatica, Oracle, and SQL.
  • Experience designing, developing, and maintaining ETL processes.
  • Proficient with advanced transformations and parsing JSON/XML messages.

Responsibilities

  • Design, develop, and maintain ETL processes using Informatica PowerCenter or other Informatica tools.
  • Demonstrate 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.
  • Integrate data from various sources while ensuring data quality.

Skills

ETL Informatica Development
Oracle
SQL

Tools

Informatica PowerCenter
Bitbucket
AutoSys
Spark
Kafka
NoSQL databases
Hadoop ecosystem

Job description

Primary skill: ETL Informatica Development

Secondary skills: Oracle and SQL

Experience: Demonstrated extensive experience in ETL development using Informatica, Oracle, and SQL, with the expertise required to perform the responsibilities of the role.

Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.

Demonstrate a 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.

Perform unit, integration, and system testing on ETL processes.

Collaborate with cross-functional teams to support the successful implementation of ETL processes.

Ensure data quality by implementing data-cleansing and transformation processes.

Develop and maintain relational and dimensional data models innovative solutions for the industry

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Informatica/Hadoop Developer
ETL Informatica/Hadoop Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 90,000 - 150,000
Informatica Developer
Informatica Developer

TechDigital Group • Purchase (NY)

On-site
USD 120,000 - 150,000
Etl Informatica/hadoop Developer
Etl Informatica/hadoop Developer

Tata Consultancy Services Limited • Plano (TX)

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

Ethereum Technologies LLC • Columbia (SC)

On-site
USD 95,000 - 135,000
ETL Engineer
ETL Engineer

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000
ETL Developer
ETL Developer

Valiant Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL Engineer
ETL Engineer

Quantum Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 140,000
ETL Developer
ETL Developer

Ethereum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 130,000
Informatica ETL
Informatica ETL

TechDigital Group • Richmond (VA)

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

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 130,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support
+5