ETL Architect

 Job Description
We are seeking a highly skilled ETL (Extract, Transform, Load) Architect with expertise in Informatica Intelligent Cloud Services (IICS), SQL Server Integration Services (SSIS), and Snowflake to join our team. The ideal candidate will possess a strong understanding of ETL architecture and demonstrate proficiency in designing, implementing, and optimizing ETL processes.

Key Responsibilities:
Architect and design end-to-end ETL solutions using Informatica Intelligent Cloud Services (IICS) and SQL Server Integration Services (SSIS) to meet business requirements
Develop and maintain ETL processes, including data extraction, transformation, and loading, ensuring data accuracy, integrity, and efficiency
Utilize Snowflake features and architecture to design scalable and high-performing data warehouse solutions
Demonstrate fluency in SQL skills, including complex querying, optimization, and performance tuning
Develop and maintain Python scripts to automate ETL processes and enhance system functionality
Collaborate with cross-functional teams to understand business needs, gather requirements, and translate them into technical solutions
Provide expertise in cloud environments, including AWS or Azure, and recommend best practices for data integration and management
Conduct impact analysis and develop deployment strategies to minimize disruptions and ensure successful implementation of ETL solutions.
Stay current with industry trends and emerging technologies, proactively identifying opportunities to enhance ETL processes and improve system performance
Requirements:
Proven experience as an ETL Architect, with a strong background in designing and implementing ETL solutions using IICS, SSIS, and Snowflake
In-depth knowledge of Snowflake features and architecture, including data warehouse design, schema optimization, and performance tuning
Advanced proficiency in SQL programming, with the ability to write complex queries and optimize database performance.
Hands-on experience with Python scripting for ETL automation and system enhancement
Familiarity with cloud environments, particularly AWS or Azure, and experience with cloud-based ETL tools and services
Strong analytical and problem-solving skills, with the ability to conduct impact analysis and develop effective deployment strategies
Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment
Bachelor's degree in Computer Science, Information Technology, or related field; Master's degree preferred
Relevant certifications in Informatica, Snowflake, or cloud platforms are a plus