An ETL Developer develops, tests and maintains the process of data extraction, transformation and loading (ETL), a data warehousing process used for pull data out of source systems and load them into a data warehouse solution.
Analyst (part of Tata group) 3.9 3.9 out of 5 stars Addison, TX $90,000•$125,000 a year Tata Consultancy Services 23,598 reviews $90,000•$125,000 a year
Primary Skill:
ETL Informatica Developer Secondary:
Oracle, SQL Experience:
Minimum 10 years
Roles & Responsibilities 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-Bucket SQL 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. Salary Range•$90,000•125,000 a year Location Addison, TX Job Function
TECHNOLOGY
Role Analyst Job Id 416974 Desired Skills Hadoop | Informatica | Oracle Salary Range $90,000•125,000 a year
