Senior Software Engineer

Job Summary

• 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