## Lead Data Engineer10-11-2026 12:50:55Job\\_3050018 - 15 years* Chennai, Tamil Nadu, India (CHN)Job Title : Senior Data Engineer / Data Architect (AI & Data Integration)Location : Offshore (India) Pune, Bangalore , ChennaiExperience : 8-12+ YearsEmployment Type : Full-TimeAbout the RoleWe are seeking a highly skilled Senior Data Engineer/Data Architect to design, develop, and support enterprise-scale data integration and AI-ready data platforms. The ideal candidate will possess deep expertise in Informatica, SQL Server, Vector Databases, REST APIs, and modern data integration patterns. This role will work closely with business and technology stakeholders to build scalable data pipelines, enable AI/LLM solutions, and support enterprise application modernization initiatives.Key ResponsibilitiesData Engineering & IntegrationDesign, develop, and maintain enterprise data pipelines using Informatica.Build and optimize ETL/ELT workflows for large-volume data processing.Integrate data from multiple enterprise applications, databases, APIs, and third-party platforms.Develop data ingestion frameworks for structured, semi-structured, and unstructured data.Implement data quality, validation, reconciliation, and monitoring mechanisms.Database & Data ModelingDesign and manage SQL Server databases.Develop complex SQL queries, stored procedures, views, and performance tuning solutions.Design logical and physical data models supporting operational and analytical workloads.Optimize database performance, scalability, and reliability.AI & Vector Database EnablementBuild and manage vector-based data stores for GenAI and semantic search use cases.Work with embeddings, vector indexes, and Retrieval Augmented Generation (RAG) architectures.Integrate enterprise data sources with AI/LLM platforms.Support document intelligence, knowledge management, and AI search solutions.API Development & IntegrationDevelop and consume REST APIs for enterprise integrations.Implement API security using OAuth, JWT, and token-based authentication.Integrate cloud and on-premise applications through API-based architectures.Support event-driven and microservices-based integration patterns.Architecture & GovernanceDefine data architecture standards and integration best practices.Ensure data security, governance, and compliance requirements are met.Collaborate with business analysts, architects, data scientists, and application teams.Drive technical design reviews and solution recommendations.Mandatory SkillsData IntegrationInformatica PowerCenter and/or Informatica IICSETL/ELT DevelopmentData Warehousing ConceptsData Migration and Data SynchronizationDatabaseMicrosoft SQL ServerQuery OptimizationStored ProceduresPerformance TuningData ModelingAPI & IntegrationREST APIsJSON/XMLOAuth AuthenticationAPI Integration FrameworksAI/Data ModernizationVector Databases (Pinecone, Weaviate, Milvus, Qdrant, Azure AI Search, PgVector)Embedding ConceptsSemantic SearchRAG ArchitecturesDevelopmentPython preferredGitAgile/ScrumDevOps CI/CD PracticesPreferred SkillsAzure Data Factory (ADF)DatabricksAzure SynapseSnowflakeKafka/Event HubLangChainOpenAI/Azure OpenAIDocument AI platformsKnowledge GraphsData Lake ArchitectureRequired Experience8+ years of Data Engineering experience.5+ years of Informatica development experience.Strong hands-on SQL Server expertise.Experience building enterprise data integration solutions.Experience working with cloud-based data platforms.Experience supporting AI/GenAI initiatives is highly desirable.Strong customer-facing communication skills.Nice-to-Have ExperienceDocument Processing SolutionsIntelligent Search PlatformsLLM Integration ProjectsAI-powered Knowledge Management PlatformsHealthcare, Manufacturing, Distribution, or Enterprise IT domains