Role overview

Qualifications

8+ years experience
SQL Server Advanced SQL concepts
SSIS and its concepts with SQL Jobs profiler
Azure Data Services (SQL Azure, Azure Data Factory, Data lake)

Responsibilities

Design and develop SQL Server table, stored procedures, functions, views and triggers for ETL process
Designing and developing SSIS packages, Test and prepare SQL ETL solutions for data acquisition
Build data transformations with SSIS including data import and migration
Develop strategies to migrate, restore, backup, archive data between sources and warehouse destinations

Key facts

Remote from: India
Fixed term
Database Administrator
English

Hard skills

SQL (Programming Language) SQL Server Integration Services (SSIS) Data Migration Crystal Reports (Reporting Software) Azure Data Catalog .NET Power BI

About the company

CodersBrain

IT Services & IT Consulting

Coders Brain is a global leader in IT services, digital and business solutions that partners with its clients to simplify, strengthen and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deep-set commitment to our clients, comprehensive industry expertise and a global network of innovation and delivery centers. We achieved our success because of how successfully we integrate with our clients.

Company details

Company typeSME

IndustryIT Services & IT Consulting

Company size201 - 500

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Experience - 8+yrs

Location - Remote

Primary Skills:
SQL Server & Advance SQL concepts
SSRS & Crystal Reports
SSIS and its concepts with SQL Jobs & profiler
Azure Data Services (SQL Azure, Azure Data Factory, Data lake)
Experience of Data Migration, Restoration & Archival
Prior development experience with .NET & Web API

Roles & Responsibilities:

Design and develop SQL Server table, stored procedures, functions, views and triggers to be used during the ETL process
Designing and developing SSIS packages, Test & prepare SQL ETL solutions to acquire and prepare data from numerous systems for ORM
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
Working with SSIS package, Test & prepare ETL processes to ensure accurate and efficient movement of data
Develop strategies to migrate, restore, backup, archive data between sources and warehouse destinations
Provide support and acceptance testing including the development or refinement of test plans

Added Advantages:

Knowledge of Power BI & development experience
Certifications - MCSA, BI, MCSD

Interested Candidates can send their resume at foram.nagda@codersbrain.com

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.