The Data Architect will design and implement data warehousing solutions, focusing on ETL processes using Informatica. Strong analytical skills and BI tools experience are essential.
Job Description
Role: Data Architect
Location : San Ramon, CA
Duration: 12+ Months Contract to Hire
(Non locals are fine)
Client is looking for a candidate to fulfill the role of Informatica ETL Architect. Candidate should be fully competent to work under general direction on complex projects that have an assigned goal and should be able to proactively work with senior associates and manager as required. Typically required 7-10 years of applicable experience. Knowledge of Compliance processes or investment banking experience is desirable.
Job Description:
• Strong experience with data warehousing and Big Data.
• experience with the System Development Life Cycle and Business Intelligence (BI) tools
• Solid experience with Oracle, PL/ SQL, Informatica, XML, MQ, Erwin, Visio, Unix/Linux Shell Scripting, Autosys.
Additional InformationAll your information will be kept confidential according to EEO guidelines.
Intelliswift Santa Clara, California, USA Office
Santa Clara, CA, United States
Similar Jobs
Artificial Intelligence • Machine Learning
Design and govern enterprise data architectures that make customer data secure, trustworthy, and AI-ready. Lead data modeling, ETL/ELT, integrations across cloud, ERP, CRM, and legacy systems, vector and retrieval data foundations, data quality, lineage, and compliance. Develop reusable architecture frameworks, evaluate tooling, mentor engineers, advise senior customers, and provide platform feedback. Support multiple concurrent forward-deployed customer engagements involving agentic AI, RAG, and LLM/SLM workflows.
Top Skills:
As/400AWSAzureCrewaiD365DatabricksGCPKafkaLangchainLanggraphLookerMicrosoft 365Nosql DatabasesOutlookPythonSalesforceSAPSnowflakeSQLTableauVector Databases
Information Technology
Designs and delivers Microsoft Fabric, Azure AI, Power BI, and generative AI architectures for enterprise clients. Leads solution design, prototyping, implementation readiness, governance, quality assurance, and client enablement across complex engagements. Develops AI solution patterns including RAG, vector search, embeddings, semantic search, and prompt orchestration. Leads project and client teams, supports business cases and proposals, reviews technical deliverables, manages risks, and serves as a trusted technical advisor.
Top Skills:
AzureAzure AiAzure Ai SearchAzure OpenaiCi/CdCopilotEltEmbeddingsGenerative AiMicrosoft FabricOnelakePower BIPrompt EngineeringPysparkPythonRbacRetrieval-Augmented GenerationSemantic SearchSparkSQLVector Search
Information Technology
Own the enterprise data architecture vision and roadmap for ALIP life insurance and annuity solutions. Define governance standards, data models, mapping frameworks, and reference architectures; guide client implementations and integrations with warehouses, lakes, reporting, regulatory, finance, and analytics platforms. Lead modernization toward event-driven, CDC-based, streaming, and real-time data consumption while partnering with product, engineering, delivery, and client stakeholders.
Top Skills:
AlipAlip StagingApi-Based ArchitecturesChange Data CaptureCloud-Native Data PlatformsCrm PlatformsData LakesData WarehousesDigital ConnectDistributed SystemsEnterprise Data PlatformsEvent-Driven ArchitecturesMetadata ManagementOperational Data StoresQ&IReal-Time Data ArchitecturesReporting PlatformsStreaming
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
