Job Summary
We are seeking a highly skilled Architect with 10 to 14 years of experience to join our team. The ideal candidate will have extensive expertise in ETL Data Warehousing Concepts Data Lake Concepts Informatica Cloud Scheduler Cloud DWH SQL Data Integration Informatica Cloud and Unix Shell Scripting. This role involves designing and implementing robust data solutions to support our business objectives and drive innovation.
Responsibilities
Lead the design and implementation of ETL processes to ensure efficient data extraction transformation and loading.Oversee the development and maintenance of data warehousing solutions to support business intelligence and analytics.Provide expertise in Data Lake Concepts to architect scalable and flexible data storage solutions.Utilize Informatica Cloud Scheduler to automate and optimize data workflows.Implement and manage Cloud DWH solutions to ensure high performance and availability.Develop and optimize SQL queries to support data integration and reporting needs.Ensure seamless data integration across various platforms using Informatica Cloud.Create and maintain Unix Shell Scripts to automate routine data processing tasks.Collaborate with cross-functional teams to understand data requirements and deliver effective solutions.Monitor and troubleshoot data pipelines to ensure data quality and integrity.Provide technical guidance and mentorship to junior team members.Stay updated with the latest industry trends and technologies to drive continuous improvement.Document technical specifications and maintain comprehensive project documentation.
Qualifications
Possess a deep understanding of ETL processes and best practices.Demonstrate expertise in Data Warehousing Concepts and their practical applications.Have hands-on experience with Data Lake Concepts and architecture.Proficient in using Informatica Cloud Scheduler for workflow automation.Skilled in implementing and managing Cloud DWH solutions.Strong knowledge of SQL for data integration and reporting.Experienced in using Informatica Cloud for seamless data integration.Proficient in Unix Shell Scripting for automating data processing tasks.Excellent problem-solving skills and attention to detail.Strong communication and collaboration skills.Ability to mentor and guide junior team members.
Certifications Required
Informatica Certified Professional Certified Data Management Professional (CDMP) SQL Certification