Job Description A US based client is looking for a Sr. Microsoft SQL/ETL Developer to join their India based team. This person will be responsible for designing, building, testing and deploying SQL Server and data integration solutions across on-premises and cloud environments. This is a development role, not mainly an incident support role. You'll own production ETL/ELT pipelines that bring ERP, MRP and operational data from databases, APIs and files into the enterprise data warehouse and analytics platforms. You'll also do advanced T-SQL work, including stored procedures, performance tuning, dimensional modeling and data marts. You'll partner with application owners, business teams, BI developers and infrastructure and architecture teams to define source-to-target requirements and deliver reliable, reporting-ready data. You'll build automated data validation and reconciliation, manage changes through Git with controlled releases, set development and monitoring standards, and mentor colleagues. You'll also help move the on-premises data warehouse toward a cloud platform such as Snowflake or Microsoft Fabric without disrupting reporting. Tableau dashboard and visualization development is not part of this role. Based on knowledge and years of experience, this position offers a salary range of 18-25 LPA. Skills and Requirements 5+ years of hands-on Microsoft SQL Server/T-SQL development and substantial enterprise ETL/ELT experience
Advanced SQL skills on your own: complex joins, CTEs, window functions, stored procedures, indexing, execution plans, transactions and error handling
Proven ownership of production ETL/ELT pipelines that combine different sources, including ERP/MRP or similar enterprise systems
Strong background in dimensional modeling, source-to-target mapping and data warehouse design
Thorough data validation,
reconciliation and regression testing
Experience with version control, change-impact analysis and safe deployments with rollback plans
Robust troubleshooting, documentation and collaboration skills, and the ability to explain your own solutions and design tradeoffs
Bachelor's degree in Computer Science, Information Systems, Data Engineering or a related field, or equivalent experience
Hands-on SSIS package development, deployment and modernization (strongly preferred; similar ETL tools accepted)
Direct experience integrating NetSuite ERP and Epicor manufacturing/MRP data
Experience with Boomi, Fivetran or other integration and orchestration platforms
Exposure to Snowflake, Microsoft Fabric or cloud data warehouse modernization
Familiarity with dbt, Azure Data Factory, Databricks, Python, or REST/SOAP APIs
Exposure to Tableau Cloud, Power BI or reporting-ready data models
Experience with manufacturing, supply chain, procurement, inventory, finance or order fulfillment data We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to
[email protected].
📌 Sr. SQL ETL Developer - INTL India (Pune)
🏢 Insight Global
📍 Pune