Informatica ETL Developer

DTEL Engineering & Consultants Inc

United States

13 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Agile Methodology CA Workload Automation Ae Data Cleansing Data Integration Extract Transform Load (ETL) Data Transformation Data Warehousing Database Queries Apache Hadoop Hadoop Distributed File System MapReduce JSON

+14 more

Job Scheduling Oracle (Applications) Parsing Performance Tuning PL-SQL SQL Databases System Testing Extensible Markup Language (XML) Data Processing Data Storage Technologies Informatica Powercenter Information Technology Bitbucket Software Version Control

Job description

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.

Requirements

Secondary: Oracle, Hadoop

Experience: Minimum 10 years

Roles & Responsibilities

Bachelor s or master s degree in computer science or related field.
Minimum 2 years experience in IDMC migration projects.
ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
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
Experience with HDFS, MapReduce, and Hadoop ecosystems.
Understanding data storage and data processing techniques in Hadoop
Data Integration: Integrate data from various sources, ensuring data consistency and quality.