Description
Informatica Developer Overview
- Role summary: Hands‑on engineer who designs, develops, tests, and deploys ETL/ELT solutions to move and transform enterprise data.
- Core platform expertise: Deep experience with Informatica PowerCenter, Cloud Data Integration, Repository Manager, Workflow Manager, and Secure Agents.
- Mapping and transformation design: Build complex mappings using Source Qualifier, Expression, Aggregator, Router, Joiner, Lookup, and mapplets for reusable logic.
- Data ingestion patterns: Implement batch loads, incremental CDC, streaming ingestion, and API‑based integrations depending on latency and consistency needs.
- Performance tuning: Optimize sessions with partitioning, pushdown optimization, memory tuning, and efficient SQL generation to meet SLAs.
- Error handling and recovery: Design robust checkpointing, restartability, and exception‑handling patterns for resilient pipelines.
- Testing and validation: Create unit, integration, regression, and data quality tests; validate row counts, checksums, and business rules.
- Metadata and lineage: Maintain metadata, document mappings, and enable lineage for impact analysis and auditability.
- Version control and CI/CD: Integrate ETL artifacts with Git/CI pipelines, automate deployments, and manage environment promotions.
- Connectivity and adapters: Configure and troubleshoot connectors for relational DBs, cloud storage, message queues, and SaaS endpoints.
- Security and governance: Apply role‑based access, credential management, encryption, and data masking to protect sensitive data.
- Monitoring and operations: Implement job monitoring, alerting, SLA tracking, and runbooks for on‑call support.
- Collaboration and handoffs: Work with architects, DBAs, data stewards, and QA to translate requirements into production solutions.
- Advanced topics: Support MDM and Data Quality integrations, enable real‑time APIs, and contribute to platform roadmap decisions.
- Troubleshooting skills: Analyze session logs, repository issues, and performance bottlenecks; perform root cause analysis.
- Capacity planning: Estimate resource needs, plan scaling strategies, and optimize licensing and cloud costs.
- Mentorship and governance: Mentor junior developers, enforce coding standards, and participate in architecture reviews.
