ETL Informatica/Hadoop Developer
jconnect infotechPlano, TX
About the role
ETL Informatica/Hadoop Developer
Title: ETL Informatica/Hadoop Developer
Location: Plano, TX / Charlotte, NC
Duration: Fulltime
Job Description:
- Must Have Technical/Functional Skills
- Primary Skill: ETL Informatica Developer
- Secondary: Oracle, SQL
Experience: Minimum 10 years
Roles & Responsibilities:
- Bachelor’s or master’s degree in computer science or related field.
- ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
- Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie.
- Experience with Spark, Kafka, NoSQL databases.
- Experience in Agile Methodology
- Experience with code versioning tools like Bit-BucketSQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
- Exposure to advanced transformations like data transformations, Parsing JSON/XML messages
- Experience in Job scheduling tools Like Autosys
- Data Integration: Integrate data from various sources, ensuring data consistency and quality.
- Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities.
- Performance Optimization: Optimize SQL script/queries for speed and efficiency.
- Troubleshooting: Identify and resolve issues in ETL processes.
- Documentation: Create and maintain technical documentation for ETL processes.
- Testing: Perform unit, integration, and system testing on ETL processes.
- Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.
- Data Quality: Ensure data quality by implementing data cleansing and transformation processes.
- Data Modeling: Develop and maintain relational and dimensional data models.
Matching similar jobs
JOB OVERVIEW
Experience level
Lead
Location
Plano, TX
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
today
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)