• ETL Senior Developer

    Job ID
    Consulting Services
    Information Management
  • Overview



    Key Responsibilities


    Software Development

    • Perform ETL Transactions and develop Jobs to fetch data.
    • Knowledge of both Oracle and SQL is must (At least not Expert) but should be able understand and develop.
    • Should be able to develop complex Stored Procedures, Functions, Trigger, User-defined Functions, Views and Indexes.
    • Scanning of DB files and develop scripts to load.
    • Experience on Designing and Implementing ETL methodologies/solutions on basis of requirements.
    • Strong exposure to working on complex reports using SSRS, preferably having experience on Power BI.
    • Production support activities including on call support.


    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.
    • Oracle and SQL Server Development (complex development/handling transactions/integration with SSIS).


    Secondary Expertise


    • PowerShell scripting (not deep, but should have good knowledge on how scripting works and should be able to take over or manage existing scripts).
    • Python/Pearl scripting (not deep, but should have idea on how scripting works).


    Qualifications and Experience




    Years of Experience

     5 to 6 Years.

    Educational Qualification

    B.E, B.Tech., MCA, M.Tech., M.S

    Prior Experience

    DB - SQL Server+ Oracle : 4+ yrs. Module level DB design, knowledge of indexes, relationships, queries, joins, performance tuning, normalization

    SQL Server + oracle  Development: 4+ ETL Methodologies

    TSQL / SQL Database experience 4+ yrs.

    Reporting Tools: good to have reporting experience and Business Intelligence.

    Scripting  : Python , Perl , Power Shell

    ETL:- Loading and reading data from various data sources including Oracle and SQL Server.

    Understanding of various file formats ( XML , JASON, Flat , MS Office)

    Good to have analytics experience





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