Prolifics

  • ETL Developer-SQL Server

    Job ID
    2018-3225
    Category
    Information Technology
    Department
    Information Management
    Location
    Hyderabad
  • Overview

     

    Purpose of role

     

     

    As a ETL Developer, he will be responsible for ETL Transactions, BI, Reporting, Environment development etc. This candidate will work with ETL / BI Team of Client and Prolifics to configure and implement highly-performing enterprise systems that improve outcomes and increase productivity and performance. Part of the job will involve manage ETL Transactions, BI & Reporting. We are a service industry so we need a flexible and energetic individual who can adapt to the changing needs of the business

     

    Key Responsibilities

     

    Software Development

    • Perform ETL Transactions and develop Jobs to fetch data.
    • Knowledge of strong SQL Server is must but should be able understand and develop database objects.
    • Should be able to develop complex Stored Procedures, Functions, Trigger, User-defined Functions, Views and Indexes.
    • Performance tuning is preferable.
    • Experience on Designing and Implementing ETL methodologies/solutions on basis of requirements.
    • Preferable exposure to working on reports using SSRS and/or Power BI.
    • Production support activities including on call support.
    • Having good knowledge on C# and .Net development.

     

    Client Interaction and communication

    • Attending client calls - The candidate shall be able to attend client calls during India and US overlap time in morning or evening.
    • Status Reporting - The candidate shall be able to provide status update of the assigned work in the form of status reports, emails or over the call.

     

    Change Management

    • Candidate shall be able to understand requirement changes and re-plan the work accordingly.
    • Onsite Travel– Candidate shall be able to travel to US based client office on need basis.

     

    Process Compliance

    • Organization Process Adherence - Candidate should follow organization process while performing the work.
    • Production support activities including on call.

     

    Primary Expertise

     

    • ETL Development using SSIS.
    • SQL Server Development (complex development/handling transactions/integration with SSIS).
    • C# development experience, web technologies experience.
    • Preferable exposure to cloud technologies AWS/Azure.
    • Basic understanding of PowerShell Scripting.

     

     

     

    Secondary Expertise

     

    • Performance tuning of SQL Server objects.
    • Reports development experience using SSIS/Telerik/Power BI.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed