• ETL Developer-SQL Server

    Job ID
    Information Technology
    Information Management
  • 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.


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