Informatica ETL Developer

ETL Development & Implementation:

• o Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter.
• o Extract, transform, and load data from multiple sources (SQL Server, Oracle, APIs, Flat Files, JSON, XML, etc.) into Data Warehouses or Data Lakes.
• o Optimize ETL jobs for performance and scalability.

Data Integration & Management:

• o Develop data pipelines to integrate structured and unstructured data sources.
• o Ensure data quality, data consistency, and data integrity during ETL processes.
• o Perform data profiling, cleansing, and transformation as per business requirements.
• Performance Tuning & Optimization:
• o Troubleshoot and optimize SQL queries, stored procedures, and ETL processes.
• o Optimize Informatica session performance using partitioning, pushdown optimization, indexing, and caching.
• o Monitor job execution and resolve performance bottlenecks.

Deployment & Support:

• o Deploy ETL solutions in development, testing, and production environments.
• o Collaborate with DBAs, BI teams, and Data Engineers to ensure data accuracy and availability.
• o Provide technical support, issue resolution, and documentation for ETL jobs.

Collaboration & Documentation:

• o Work closely with business analysts, data scientists, and stakeholders to gather requirements.
• o Maintain proper technical documentation for ETL processes, transformations, and mappings.
• o Follow data governance and compliance policies for data security and privacy.

Technical Skills

• o 5+ years of experience in ETL development using Informatica PowerCenter.
• o Strong knowledge of SQL, PL/SQL, and database development (Oracle, SQL Server, PostgreSQL, or MySQL).
• o Experience with Data Warehousing concepts, Star Schema, Snowflake Schema, and OLAP systems.
• o Hands-on experience with scripting languages (Python, Shell, or PowerShell).
• o Exposure to Big Data technologies (Hadoop, Spark, Data Lake, DataBricks) is a plus.
• o Experience working with APIs, JSON, XML, and RESTful services for data integration.
• o Knowledge of Cloud Data Platforms (AWS, Azure, or Google Cloud)