Mode : Hybrid
Location : Hyderabad
Job Description :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
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.
Education
Any engineering or computer degree with relevant experience.
Skills : data engineer,data