Informatica ETL Developer / Data Engineer

Position: Informatica ETL Developer / Data Engineer Experience: 10 Years Location: RTP/Sanjose CA

Skills: Informatica, Teradata & DBT Developer

Key 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. Perform data analysis, cleansing, profiling, and reconciliation activities to ensure data quality. Optimize Teradata queries, data models, and workloads for high performance data processing. Collaborate with business analysts, data architects, and stakeholders to gather requirements and deliver data solutions. Implement data governance, metadata management, and ETL best practices. Support production deployments, performance tuning, troubleshooting, and incident resolution. Develop technical documentation and ensure adherence to security and compliance standards. Required Skills: Strong 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. Cisco experienced with iACV domain 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. Familiarity with data quality and data governance frameworks.