Data Engineer - Anywhere in India/Multiple Locations/Bangalore - Forward eye technologies

    Forward eye technologies
    Forward eye technologies Anywhere in India/Multiple Locations/Bangalore

    2 weeks ago

    Default job background
    permanent Technology / Internet
    Description

    Detailed Job/ Role Description :
    Data Engineer


    Key Responsibilities :

    • Designing, developing, and maintaining database solutions using Microsoft SQL Server.
    • Developing and optimizing SQL queries, stored procedures, and functions for efficient data retrieval and manipulation.
    • Designing and implementing data models, schemas, and data warehouses to support business requirements and analytical needs.
    • Building and maintaining SSIS ETL processes and data pipelines to extract, transform, and load data from various sources into the SQL Server database.
    • Implementing data quality checks, data validation rules, and data cleansing processes to ensure data accuracy and integrity.
    • Performance tuning and optimization of database queries, indexes, and server configurations to improve data processing speed and efficiency.
    • Collaborating with data scientists and analysts to understand data requirements, design data structures, and implement solutions for advanced analytics and reporting.
    • Working closely with software engineers to integrate database solutions with application systems and ensure data consistency and integrity across the entire technology stack.
    • Monitoring database performance, diagnosing and resolving issues, and implementing proactive measures to prevent downtime and optimize performance.
    • Documenting database designs, data models, ETL processes, and data governance policies for knowledge sharing and compliance purposes.

    Requirements :

    • Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent work experience).
    • Proven experience as a SQL Server developer or data engineer with expertise in designing and developing database solutions using Microsoft SQL Server.
    • Strong proficiency in SQL programming, including advanced querying techniques, stored procedures, functions, and performance optimization.
    • Experience with database design and data modeling concepts, including normalization, denormalization, and dimensional modeling.
    • Handson experience with ETL tools and technologies such as SSIS (SQL Server Integration Services) or similar data integration platforms.
    • Knowledge of data warehousing principles and best practices, including data ingestion, transformation, and storage.
    • Familiarity with data governance, data quality, and data security principles and practices.
    • Experience working with largescale databases, highvolume transactional systems, and distributed computing environments.
    • Strong analytical and problemsolving skills, with the ability to analyze complex data sets and troubleshoot databaserelated issues.
    • Excellent communication and collaboration skills, with the ability to work effectively in a crossfunctional team environment.

    Preferred Qualifications :

    • Experience with other database technologies such as Oracle, PostgreSQL, or MySQL.
    • Familiarity with cloudbased data platforms such as Microsoft Azure SQL Database
    • Knowledge of data visualization tools and technologies such as Power BI, Tableau, or QlikView.
    • Experience with data streaming technologies such as Kafka, Spark Streaming, or Apache Flink.
    • Certification in Microsoft SQL Server or related technologies.
    )