• Data Engineer

Industry Insurance
Location Andhra Pradesh Hyderabad
Experience Range 10 - 15 Years
Qualification BE
Not active

Functional Banking / Insurance
Job Description
About Us
“Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India’s leading business services provider and largest domestic private sector employer. Quess Corp Limited is - ‘A Great Place to Work’ certified – a testament to our excellent culture, people, and processes.”
About Company
https://itstaffing.quesscorp.com/
Roles and Responsibility
      •  

        JD

         

        Data Engineer

         

        • 10 years of experience in analyzing, extracting data which could be in various formats and sources.
        • Experience in building dimensional models ? OLAP.
        • Ability to articulate insights from the data and help business teams make decisions.
        • Strong knowledge of and experience with reporting, databases (SQL etc), programming ( ETL frameworks)
        • Experience in understanding the source data from various platforms and mapping them into Entity relationship model(ER) for data integration and reporting.
        • Develop and maintain data architecture & data modeling best practices and guidelines for different data and analytic platforms
        • Strong in writing complex SQL queries.
        • Postgre SQL exp is mandatory

         

         

        Responsibilities

        • Work with team leads to prioritize business and information needs
        • Prepare high-level ETL mapping specifications.
        • Develop complex code data scripts (Primarily SQL) for ETL
        • Data Quality Control
        • Troubleshoot & determine best resolution for data issues and anomalies
        • Manage exploratory data analysis to support database and dashboard development required for business users.
        • Ability to articulate data issues to business users and provide solutions to cleanse from source.
        • Assist in development of software technical documentation
        • Build fact-dimensional models for reports
        •  

         

         

        Skills

        • Strong analytical and communication skills.
        • Deep knowledge of Databases, stored procedures, optimizations of huge data.
        • Experience with building the infrastructure required for data ingestion and analytics.
        • Ability to fine tune report generating queries.
        • Indepth knowledge of ingestion techniques, data cleaning, de-dupe, sharding, partioning.
        • DE should be a fast learner who is self-motivated to  explore existing data model and make connections.
        • Should have strong RDBMS development experience and internals knowledge.
        • Should have strong understanding of data modeling techniques and working knowledge with OLTP and OLAP systems.

         

A+| A| A-