A free Jobstore account is required to proceed to the employer site.
Description
About the job :
Key Responsibilities
Lead the design, development, and optimization of end-to-end data pipelines and ETL workflows.
Architect data integration solutions leveraging Snowflake, Informatica PowerCenter, and Teradata.
Collaborate with business and technical teams to gather requirements and translate them into technical designs.
Drive performance tuning, error handling, and automation across ETL and data warehouse layers.
Provide technical leadership to developers, mentor junior engineers, and enforce best practices.
Ensure data quality, consistency, and security across data environments.
Support migration and modernization initiatives from legacy systems to cloud-based data platforms.
Participate in Agile/Scrum ceremonies, sprint planning, and code reviews.
Required Skills & Experience
Core Expertise (Must-Have) :
Snowflake (3+ years) : Hands-on experience with SnowSQL, Time Travel, cloning, query profiling and optimization, and secure Data Sharing. Able to design schemas and implement performance-tuned solutions.
Informatica PowerCenter (3+ years) : Proficient with Designer, Workflow Manager/Monitor, mappings and transformations, session/workflow tuning, error handling and deployments.
Teradata (3+ years) : Strong SQL skills including BTEQ scripting, stored procedures, performance-tuned joins, indexing/collect stats, and utilities such as FastLoad, MultiLoad, TPT.
SQL & Data Modeling : Demonstrated ability to design normalized and dimensional models (3NF, Star, Snowflake) and write complex, performance-oriented SQL for analytics.