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)

Similar vacancies

More like this role

Inseego India Private Limited

Inseego - Staff Data Engineer - SQL Server

  • Remote
  • Hybrid
  • On-site
... application development as E2E data engineer for highly available enterprise grade software and platform applications.- 3+ years of experience in Platform Engineering across various cloud computing models.- Expertise in one relational db (SQL Server, Postgres, MySQL) and in one nosql store (Cassandra, MongoDB, InfluxDB, ...

Bangalore, भारत

  • Hybrid
  • Full-time
  • IT
... upgrades. SQL Server Database Administration . Install, configure, and administer Microsoft SQL Server environments. . Monitor database performance and optimize SQL queries, indexes, and stored procedures. . Perform database backup, recovery, and disaster recovery activities. . Manage database security, user access, roles, ...

Bangalore, भारत

... applications that rely heavily on SQL Server stored procedures.- Hands-on experience with Tidal, Control-M, AutoSys, or similar batch scheduling tools.- Expertise in SQL Server Query Store, Dynamic Management Views (DMVs), and execution-plan analysis.- Practical experience using AI-assisted engineering tools such as GitHub Copilot, ...

Bangalore, भारत

... applications that rely heavily on SQL Server stored procedures.- Hands-on experience with Tidal, Control-M, AutoSys, or similar batch scheduling tools.- Expertise in SQL Server Query Store, Dynamic Management Views (DMVs), and execution-plan analysis.- Practical experience using AI-assisted engineering tools such as GitHub Copilot, ...

Hyderabad, भारत

... Technology, Data Engineering or a related https://jobeax.com/link/kfLTLT6enIMYonWk Certifications : - AWS Certified Data Engineer - Associate- Google Professional Data Engineer- Microsoft Certified : Fabric Data Engineer Associate- Snowflake SnowPro Core Certification- Databricks Certified Data Engineer Associate (ref:hirist.tech) ...

Calcutta, भारत

  • Full-time
  • IT
... requirements and development activities. - Write T-SQL queries. - Experience in DTS, SSIS, SSRS, SSAS. - Create Stored Procedure, Functions, and Triggers etc. - Process data migration to SQL Server from various sources. - Create and maintain database documentation. - Good interpersonal and communication skills. - Should have worked ...

Bangalore, भारत

  • On-site
Merck seeks a SQL Server Database Administrator and Automation Engineer in Hyderabad to design, implement, and support SQL Server infrastructure across on-premises and cloud environments. The role focuses on developing automation for database provisioning, patching, and system maintenance using industry-standard tools and ...

Hyderabad, भारत

... https://jobeax.com/link/zQoWsvfScO4ymk5u Stack :- C#, .NET Framework, .NET Core/.NET 8+- https://jobeax.com/link/GrYTXLZMpxEMJknV Core, REST APIs, Microservices- SQL Server- Enterprise Integration patterns and middleware technologies- AWS Cloud and AWS DevOpsRequired Skills :- Experience leading distributed engineering teams ...

India, भारत

... Design and implement automated data quality checks and validation frameworks.- Perform data profiling, anomaly detection, and root cause analysis using Python and SQL.- Integrate data quality processes into ETL/ELT pipelines using PySpark and Databricks.- Monitor and resolve data quality issues across Azure/AWS-based data platforms.- ...

Pune, भारत

  • Full-time

€40 EUR

Senior Data Engineer (DBT, AWS, SQL) Join us as a Senior Data Engineer and play a pivotal role in building and scaling modern data platforms that enable data-driven decision-making across the organization. What will you do? - Design, develop, and maintain scalable data pipelines using dbt, SQL, AWS services i.e S3, Redshift, ...

Bangalore, भारत