Data/Sql Software Engineer

Job SummaryWe are seeking a seasoned SQL Developer/Data Warehouse Engineer to design, build, and manage robust data warehousing solutions and replication strategies.This role demands hands-on experience across both Oracle and SQL Server environments, with a strong command of Azure Fabric and data lake technologies.You'll be key in crafting reliable datasets for dashboarding, reporting, and analytical consumption, utilizing an AI-augmented approach to solutioning, and ensuring seamless data replication and synchronization using Oracle Golden Gate and similar tools.A commitment to collaborative problem solving, sophisticated design, and product quality is essential.Job DescriptionKey ResponsibilitiesDesign, implement, and maintain scalable data warehouse solutions, using AI tools (e.G., GitHub Copilot, Claude, Cursor)Develop, optimize, and manage SQL code across Oracle and SQL Server, with AI assistance for code completion, refactoring suggestions, and identifying potential bugs.Architect and monitor replication solutions using Oracle Golden Gate and SQL Server replication toolsLeverage Azure Fabric to support distributed data processingBuild data pipelines and curate datasets within data lakesCollaborate with BI teams to deliver clean, reliable data for Tableau, Power BI, Business Objects and other visualization toolsDrive performance optimization and ensure data integrity across systemsPartner with product and technical leads to review and finalize requirements; use AI summarization tools to rapidly synthesize documentation and user stories.Responsible for effectively and responsibly integrating AI coding assistants into their workflows.Own developer testing for assigned projects; use AI-powered test generation tools to achieve high coverage while reducing manual test-writing effort.Resolve technical issues in new and existing code through systematic debugging; apply AI-assisted root cause analysis to accelerate issue resolution.Required Qualifications5+ years of SQL development experience with Oracle and SQL ServerExperience designing and maintaining data warehouses and ETL pipelinesProven expertise with Oracle Golden Gate and SQL Server replicationSolid understanding of Azure services including Azure Fabric, Synapse, and Data FactoryHands-on with data lake solutions and file formats such as Parquet and DeltaFluency in data modeling techniques and schema designPreferred SkillsKnowledge of Power BI, Business Objects, Tableau or other visualization platformsExposure to AI DevOps practices and CI/CD automation for data workflowsFamiliarity with Python, Scala, or Spark for big data processingWorker TypeRegularNumber Of Openings Available1