- Role: Build and optimize data pipelines and data warehouse solutions.
- Experience Required: Typically 3 to 6+ years of ETL and database experience.
- Core Tools: Informatica PowerCenter, Informatica Developer Job Description Template , SQL, and Unix/Linux shell scripting.
- Advanced SQL and database knowledge (Oracle, SQL Server, Teradata).
Key Responsibilities
- ETL Development: Design and build complex Informatica mappings, sessions, and workflows to move data from various sources to target data warehouses.
- Performance Tuning: Optimize slow-running queries, mappings, and database loads using partitioning and indexing.
- Data Quality & Cleansing: Perform data profiling, validation, and de-duplication to ensure data accuracy.
- Troubleshooting: Monitor daily data loads and fix extraction or loading failures.
- Documentation: Write technical design specs, mapping documents, and operational runbooks