Modaxo - Trellint
Senior SQL Developer
Modaxo - Trellint - New London, Connecticut, us, 06320
Work at Modaxo - Trellint
Overview
- View job
Overview
Job Summary:
We 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, while ensuring seamless data replication and synchronization using Oracle GoldenGate and similar tools.
Job Description:
Key Responsibilities: Design, implement, and maintain scalable data warehouse solutions Develop, optimize, and manage SQL code across Oracle and SQL Server Architect and monitor replication solutions using Oracle GoldenGate and SQL Server replication tools Leverage Azure Fabric to support distributed data processing Build data pipelines and curate datasets within data lakes Collaborate with BI teams to deliver clean, reliable data for Tableau, PowerBI, Business Objects and other visualization tools Drive performance optimization and ensure data integrity across systems Required Qualifications:
5+ years of SQL development experience with Oracle and SQL Server Experience designing and maintaining data warehouses and ETL pipelines Proven expertise with Oracle GoldenGate and SQL Server replication Solid understanding of Azure services including Azure Fabric, Synapse, and Data Factory Hands-on with data lake solutions and file formats such as Parquet and Delta Fluency in data modeling techniques and schema design Preferred Skills:
Knowledge of Power BI, Business Objects, Tableau or other visualization platforms Exposure to DevOps practices and CI/CD automation for data workflows Familiarity with Python, Scala, or Spark for big data processing
Worker Type: Regular
Number of Openings Available: 1
Job Description:
Key Responsibilities: Design, implement, and maintain scalable data warehouse solutions Develop, optimize, and manage SQL code across Oracle and SQL Server Architect and monitor replication solutions using Oracle GoldenGate and SQL Server replication tools Leverage Azure Fabric to support distributed data processing Build data pipelines and curate datasets within data lakes Collaborate with BI teams to deliver clean, reliable data for Tableau, PowerBI, Business Objects and other visualization tools Drive performance optimization and ensure data integrity across systems Required Qualifications:
5+ years of SQL development experience with Oracle and SQL Server Experience designing and maintaining data warehouses and ETL pipelines Proven expertise with Oracle GoldenGate and SQL Server replication Solid understanding of Azure services including Azure Fabric, Synapse, and Data Factory Hands-on with data lake solutions and file formats such as Parquet and Delta Fluency in data modeling techniques and schema design Preferred Skills:
Knowledge of Power BI, Business Objects, Tableau or other visualization platforms Exposure to DevOps practices and CI/CD automation for data workflows Familiarity with Python, Scala, or Spark for big data processing
Worker Type: Regular
Number of Openings Available: 1