Back to list

Vacancy description

Data Engineer - SQL Server in Ernakulam, भारत

Fragomen

Ernakulam, भारत

We are looking for an experienced Data Engineer with strong expertise in SQL Server, data integration, and structured data https://jobeax.com/link/SIEkrz4VgCkhRIDm role will focus primarily on building, supporting, and troubleshooting reliable data loads and integrations, including ServiceNow extracts and future data solutions using Microsoft https://jobeax.com/link/RpCOv52iCS68bM7C ideal candidate will have strong SQL skills, hands-on experience working with JSON and XML data, and an analytical mindset with the ability to investigate issues, evaluate different solutions, and quickly learn unfamiliar https://jobeax.com/link/86DscMukVX8p2VNe Responsibilities :- Design, develop, maintain, and troubleshoot complex SQL Server solutions and data processing workflows.- Develop and support data loads and extracts from enterprise platforms, including ServiceNow.- Work with complex SQL constructs, including :1. Stored procedures.2. Common Table Expressions.3. MERGE statements.4. Window functions such as ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG.5. Conditional branching and complex process flows.- Perform SQL query analysis and optimization and understand database locking considerations.- Process structured and semi-structured data, particularly JSON and XML, including parsing within SQL Server.- Develop and support SSIS solutions involving loops, derived columns, and script tasks.- Work with REST APIs and various authentication methods to support data extraction and integration.- Use tools such as PowerShell to troubleshoot API endpoints and inspect data returned from third-party applications.- Work with Git-based source control and Microsoft Fabric development environments.- Troubleshoot unexpected integration or platform changes by reviewing documentation, validating endpoints, analyzing returned data, and identifying appropriate https://jobeax.com/link/qVQYcn8zRo6FsrUo Skills & Experience :- 5 - 7 years of relevant experience in data engineering, database development, business intelligence data integration, or a related area.- Strong hands-on expertise in SQL Server and advanced SQL development.- Strong experience with :1. Stored procedures.2. Common Table Expressions.3. MERGE.4. Window functions.5. Query optimization.6. Complex SQL processing logic.- Strong working knowledge of JSON and XML, including schemas and parsing structured data.- Experience developing and supporting data integration and ETL solutions.- Experience with SSIS, including :1. For and ForEach loops.2. Derived columns.3. Script tasks.- Familiarity with C#, especially for SSIS script tasks.- Exposure to REST APIs, including :1. Basic and OAuth2 authentication.2. GET, POST, PUT, PATCH, and DELETE methods.- Good understanding of troubleshooting data-processing and integration issues.- Strong analytical and problem-solving skills.- Ability to independently investigate issues, consider alternative solutions, and learn new technologies as requirements change.- Strong SQL capability and comfort working with JSON and XML should be treated as essential requirements, consistent with the original skill https://jobeax.com/link/2QV9utHqS6GGHG1s / Good-to-Have Skills :- Experience with Microsoft Fabric, particularly :1. Warehouses.2. Gateways.3. Parameterized connections.4. Basic familiarity with semantic models.5. Git integration.- Build and support current and future data-loading solutions using Microsoft Fabric.- Experience using PowerShell for troubleshooting APIs and integration endpoints.- Familiarity with Git, Visual Studio Code, and Git Bash. (ref:hirist.tech)

Loading similar vacancies…