Informatica ETL Developer
Core
Design, develop, and maintain ETL processes and data warehouses using Informatica tools to support business intelligence.
Role type
Senior Informatica ETL Developer (via careerplan.io/jobs/Centraprise-Informatica-ETL-Developer-informatica-etl-developer-at-centraprise)
Builds
Data warehouses and ETL pipelines for business intelligence
Domain
Data Engineering / Data Warehousing
Required skills
Informatica IDMC, SQL/PLSQL, JSON/XML parsing, Hadoop ecosystems (HDFS, MapReduce), job-scheduling (AutoSys), data modeling, unit/integration testing
Preferred skills
Agile methodologies, code versioning (Bitbucket), data cleansing
Technologies
Informatica PowerCenter, IDMC, BitBucket, Hadoop, HDFS, MapReduce, AutoSys, SQL, PLSQL, JSON, XML
Responsibilities
Design and develop ETL processes using Informatica PowerCenter; Optimize SQL scripts and queries for performance; Troubleshoot and resolve ETL process issues; Create and maintain technical documentation for ETL processes; Conduct unit, integration, and system testing of ETL processes; Develop and maintain relational and dimensional data models
Seniority
Senior, hands-on IC
