We are seeking a highly skilled and experienced Informatica Developer with a solid background in data integration, ETL development, and data warehousing. The ideal candidate should have at least 3 years of hands-on experience in Informatica and a strong grasp of related big data technologies.
Key Responsibilities:
- ETL Development: Design, implement, and maintain ETL workflows using Informatica PowerCenter, Informatica Cloud, and related tools.
- Data Integration: Integrate data from multiple sources, ensuring data quality, consistency, and accuracy.
- Performance Optimization: Tune ETL processes for efficiency and scalability.
- Collaboration: Work closely with business analysts, data architects, and other stakeholders to gather and understand data requirements.
- Documentation: Develop and maintain comprehensive technical documentation for all ETL processes and data pipelines.
- Support & Maintenance: Monitor, support, and troubleshoot ETL jobs, resolving production issues as they arise.
- Mentorship: Guide and mentor junior developers, offering technical leadership and support.
Technical Skills Required:
- Informatica Suite: Proficiency in Informatica PowerCenter, Informatica Cloud, and other Informatica tools.
- SQL & Scripting: Strong command of SQL, PL/SQL, Hive, and Impala.
- Big Data Frameworks: Hands-on experience with Hadoop, Sqoop, Spark, Hive, and Impala.
- Programming: Proficiency in Python (including PySpark) and Airflow for workflow orchestration.
- Operating Systems: Good working knowledge of Unix/Linux environments.
- Data Warehousing & BI: Understanding of data warehousing concepts and exposure to BI tools.
Ideal Candidate Profile:
- Strong problem-solving and analytical skills.
- Excellent communication and teamwork abilities.
- Self-motivated, proactive, and quick to adapt to changing environments.
- Demonstrates ownership of deliverables and the ability to work independently.