ETL Informatica/Hadoop Developer
Core
Design, develop, and maintain ETL processes using Informatica and SQL to extract, transform, and load data from multiple sources into data warehouses for business intelligence.
Role type
Senior ETL Informatica/Hadoop Developer
Builds
Data warehouses and ETL pipelines supporting business intelligence activities
Domain
Data Engineering / Big Data
Required skills
Informatica ETL development, SQL/PLSQL, HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, ZooKeeper, Oozie, Spark, Kafka, NoSQL databases, JSON/XML parsing, Agile methodologies, Bitbucket, AutoSys
Technologies
Informatica PowerCenter, BitBucket, Hive, Kafka, Spark, Yarn, ZooKeeper, Oozie, Sqoop, Flume, HBase, Pig, NoSQL
Responsibilities
Design and develop ETL processes using Informatica PowerCenter, optimize SQL scripts and queries, integrate data from multiple sources, maintain data warehouses, resolve ETL process issues, create technical documentation, perform unit/integration/system testing, implement data-cleansing and transformation processes, develop relational and dimensional data models
Seniority
Senior, hands-on IC