ETL Architect

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