SQL & ETL Developer
Location
India
Posted
6 days ago
Salary
$20 - $21 / hour
Seniority
Mid Level
Job Description
SQL & ETL Developer
System Soft Technologies
Role Description We are seeking a mid-level SQL & ETL Developer to support offshore data operations and ensure the reliability of critical data pipelines. This role will focus on monitoring, maintaining, and enhancing ETL processes while collaborating closely with U.S.-based teams. - Monitor and support daily ETL processes to ensure successful and timely execution - Troubleshoot and resolve issues related to ETL workflows, data pipelines, and job failures - Work with SSIS packages and assist in transitioning ETL logic into SQL stored procedures - Develop, maintain, and optimize SQL queries, stored procedures, and data transformations - Collaborate with onshore teams to support data availability aligned with business timelines - Assist in evolving ETL processes toward Python-based solutions (training/upskilling supported) - Support data transformations within the SQL layer for downstream reporting tools - Contribute to data modeling efforts, particularly for reporting and analytics use cases - Follow development best practices and work independently within established standards - Participate in Agile ceremonies including standups, sprint planning, and retrospectives Qualifications - 3-5 years of experience in SQL development and ETL support - Strong SQL skills, including query writing, performance tuning, and stored procedures - Experience with ETL tools, preferably SSIS - Ability to monitor and troubleshoot batch data processes and pipelines - Understanding of data transformation and data modeling concepts - Ability to work independently in a support-oriented environment Preferred Qualifications - Exposure to Python for data processing (or willingness to learn) - Experience with Tableau, including understanding of data logic and reporting layers - Familiarity with Power BI and data modeling concepts - Experience transitioning ETL logic from tools (e.g., SSIS) into SQL or code-based solutions - Prior experience working in an offshore/onshore support model Work Environment & Schedule - Offshore support role with close collaboration with U.S. teams - Must be available to support ETL processes aligned with U.S. Eastern Time (ET) - Typical collaboration hours begin around: 11:00 AM PST / 2:00 PM EST - Participation in Agile ceremonies (standups, sprint planning, retrospectives) held twice weekly
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Principal Solutions Engineer – AI Readiness, Unstructured Data Platforms
Hire Hangar GlobalOffshoring as a service. Hire the top 1% of flexible, global talent. $0 fees to get started.
• Translate customer AI, compliance, and data governance goals into scalable technical architectures • Design phased deployment strategies across on-prem and cloud ecosystems • Execute and manage proof-of-value engagements with defined success metrics • Lead technical workshops and stakeholder alignment sessions • Optimize system performance, validate throughput, and ensure production readiness • Develop technical documentation and best practices for enterprise rollout • Provide structured customer insights to influence product roadmap decisions
• Develop data pipelines: develop code for data ingestion interfaces to meet specifications required by analytics teams, following best practices, company standards, and adhering to data models outlined by data architects – making design recommendations as appropriate. • Work alongside our business consultants and product managers in engaging and partnering with client stakeholders in order to create effective and strategic solutions. • Stay abreast of emerging technologies and industry trends, identifying new tools and practices that can help the company achieve its strategic goals. • Establish close communication with team members to align best practices, exchange information effectively, and collaborate for continuous improvement. • Quickly triage and diagnose system or performance issues and support the business during critical downtimes and releases. • Act as the technical expert, proposing solutions to roadblocks, outlining dependencies/constraints, and escalating problems as appropriate. • Establish consistent communication mechanisms with project delivery teams. • Establish relationships across the organization to build networks and leverage experts.
• Design, develop, test and deploy data integration solutions using IICS (Cloud Data Integration, Application Integration, Data Quality, Data Synchronization). • Build ETL/ELT pipelines to ingest, transform, and deliver data between cloud and onprem systems (SaaS, databases, data lakes, data warehouses). • Implement secure and performant integration patterns using IICS mapping tasks, mappings, tasks, and parameterization. • Develop and maintain reusable templates, mappings, and components to accelerate delivery. • Collaborate with architects, data engineers, analytics teams, and business stakeholders to define integration requirements and data contracts. • Troubleshoot and resolve production incidents; perform root cause analysis and implement fixes. • Automate deployments and CI/CD for IICS artifacts (Dev → Test → Prod), including versioning, changelogs, and release notes. • Implement monitoring, alerting, and operational runbooks for integrations. • Enforce data quality rules and profiling; work with business to remediate data quality issues. • Prepare technical documentation: design documents, runbooks, data flow diagrams, and support guides. • Support platform governance: connectivity, security, access controls, best practices, and cost optimization.
• Azure Data Engineering: Design and maintain data pipelines and solutions using Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Azure Data Lake, ensuring end-to-end reliability, scalability, and performance. • Analytics & Visualization: Build dashboards and analytical reports in Power BI and Tableau, translating infrastructure metrics, application performance data, and business KPIs into concrete, actionable recommendations. • Data Modeling & Integration: Develop data modeling, data mining, and integration processes across on-premises and cloud sources, creating reliable datasets to support analytical models and dashboards. • Queries & Large-Scale Processing: Write complex SQL and Kusto queries, as well as scripts and REST API calls for large-scale data collection and processing. • Cloud Cost Management: Operate with cost awareness in managing cloud compute and storage resources, proposing optimizations that balance performance and efficiency. • Technical Reference: Guide application and business teams on data usage and interpretation, proactively promoting best practices in data engineering, modeling, and BI tooling. • Agile Collaboration: Work within Agile/Scrum methodologies using project management tools such as Jira, with the ability to prioritize deliverables and manage tasks autonomously across onsite and offshore teams.



