We are seeking an experienced Senior Informatica Developer to design, develop, and optimize complex ETL solutions. The ideal candidate will have strong expertise in Informatica PowerCenter, SQL, Unix, and enterprise scheduling tools, with a focus on data quality, performance, and best practices.
Roles and Responsibilities
- Design, develop, and optimize complex ETL workflows using Informatica PowerCenter.
- Analyze source-to-target mappings and implement data transformation rules.
- Optimize ETL performance and troubleshoot production issues.
- Develop and tune SQL queries for large-scale datasets.
- Create and maintain Unix scripts for automation and workflow management.
- Integrate ETL jobs with Autosys or other enterprise schedulers.
- Ensure data quality, reconciliation, and validation across systems.
- Conduct ETL design reviews and enforce best practices.
- Collaborate with data architects, business teams, and stakeholders.
- Support deployments, production releases, and change management.
- Mentor junior developers and review technical deliverables.
Required Skills / Qualifications
- Strong experience with Informatica PowerCenter and ETL development.
- Proficient in SQL, Unix/Linux scripting, and data manipulation.
- Experience with Autosys or other job scheduling tools.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent collaboration, communication, and mentoring abilities.