Description

Design, develop, and maintain scalable ETL/ELT workflows using Informatica PowerCenter/IICS, DBT, and Teradata.

This role is remote.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT workflows using Informatica PowerCenter/IICS and DBT.
• Develop and optimize data integration solutions across Teradata, cloud, and enterprise data platforms.
• Create, manage, and enhance DBT models, transformations, testing, and deployment processes.
• Design and implement complex data mappings, workflows, sessions, and reusable components.
• Optimize Teradata queries, data models, and workloads for high performance data processing.

Required Skills

• 5+ years of experience in Informatica PowerCenter/IICS.
• Hands-on expertise in Teradata database development and performance tuning.
• Experience with DBT (Data Build Tool) for ELT transformations and data modeling.
• Strong SQL programming and query optimization skills.
• Experience with data warehousing concepts, dimensional modeling (Star/Snowflake schemas).
• Knowledge of ETL/ELT design patterns and data integration best practices.
• Experience with Git, CI/CD pipelines, and Agile methodologies.

Preferred Skills

• Exposure to cloud platforms such as AWS, Azure, or GCP.
• Experience with Snowflake, Databricks, or BigQuery.
• Knowledge of Python or Shell scripting for automation.

Key Skills

Education

Bachelor's degree