Job Description
Primary Skill
ETL Informatica Developer
Secondary skills: Oracle, SQL
Experience: Minimum 10 years
Roles & Responsibilities
- 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 such as 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 scripts/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–$120,000 a year
Qualifications
Bachelor of Computer Science
#J-18808-Ljbffr