ETL Developer I
Mouser Electronics
Bangalore, IN
4d ago

JOB DESCRIPTION

Title : ETL Developer I

The ETL Developer is responsible for the performance, integrity and security of a database. The DBA will create database, structures, data flows and reports.

They will collaborate with developers, analysts and business partners to design data solutions based on best practices.

ACCOUNTABILITIES & ESSENTIAL FUNCTIONS

  • Analyze, solve, and correct issues in real time.
  • Provide suggestions for solutions.
  • Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).
  • Experience with complicated SSIS Package coding and maintenance.
  • Participate in ongoing DW / BI performance tuning activities.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with query tuning and schema refinement.
  • Provide support for critical production systems as required.
  • Maintaining code versioning and support code deployments.
  • Perform scheduled maintenance and support deployment activities as required.
  • Manage SQL Databases but not limited and can extend to NoSQL / Cloud Database as applicable.
  • Preserve data integrity.
  • Maintains contemporary knowledge of industry trends, concepts, and techniques.
  • Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.
  • SKILLS & CERTIFICATIONS

  • Expert knowledge in traditional relational database concepts and design.
  • Fluent in SQL
  • Database design and query optimization.
  • Write and debug stored procedures and ability in advanced SQL operations.
  • Advanced query, join operation, and aggregate.
  • Knowledge of data warehousing.
  • Automate manual data tasks through workflows and ETL packages.
  • Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.
  • Administrate application and server environments.
  • Analyze data quality and make recommendations for data preparation.
  • Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).
  • Experience with data manipulation, data engineering, and working with large data sets.
  • Follow guidance from senior team members to plan, deploy, and maintain critical data solutions .
  • Data engineering and manipulation of large data sets.
  • Perform system monitoring and technical support.
  • Analyze data quality and make recommendations for data preparation.
  • Engage with end-users to identify opportunities where data can enable them to make data-driven decisions.
  • OPTIONAL / GOOD TO HAVE)

  • Configure and maintain database servers and processes.
  • Monitor system's health and performance.
  • Handle scheduled maintenance and support deployment activities as required.
  • Installing and configuring SQL Server, applying patches and fixes and monitoring, troubleshooting and optimizing performance.
  • Creating backup plans, developing and testing disaster recovery scenarios, managing security, server sizing, and performance tuning.
  • REQUIREMENT

  • A Bachelors degree related to Computer Science or related discipline.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form