Job title: data architect and etl specialistabout the rolewe are seeking a highly skilled data architect and etl specialist to lead our data warehousing solutions. As a key member of our team, you will be responsible for designing and implementing data integration strategies that support business intelligence and analytics needs.key responsibilitiesdata warehouse design: lead the design and implementation of data warehousing solutions to ensure seamless data flow across systems.etl process management: oversee the creation and testing of etl processes using informatica powercenter to ensure timely and accurate data delivery.sql query development: develop and optimize sql queries for data extraction, transformation, and loading.automation and efficiency: utilize unix shell scripting to automate data processing tasks and improve efficiency.collaboration and communication: collaborate with business analysts and stakeholders to understand data requirements and deliver solutions.data quality and integrity: ensure data quality and integrity by implementing robust validation and error-handling mechanisms.troubleshooting and maintenance:maintenance of documentation: maintain documentation of data models, etl processes, and data integration workflows.staying up-to-date: stay updated with industry trends and best practices in data warehousing and etl technologies.requirementsdata warehousing experience: must have strong experience in data warehousing concepts and etl processes.technical skills: must be proficient in informatica scheduler and informatica powercenter, and must have advanced sql skills for data manipulation and querying.automation experience: must have experience with unix shell scripting for automation.