Job Description:
Business Title
Data Engineer
Years of Experience
Min 6 and max upto 10.
Job Descreption
The Data Engineer is responsible for designing, implementing, deploying, and supporting various data management technologies and architectures. In partnership with business leaders, key stakeholders and cross-functional project teams, the Data Engineer will be an active contributor in a collaborative team structure and will have the opportunity to accelerate the delivery of and improve the quality of P&LS products providing increased operational excellence, a greater client experience and other strategic objectives.
Must have skills
• Experience with ETL tooling
• Experience with Apache Airflow
• Skills in programming languages such as Python a plus.
• Experience in data manipulation in Python
• Strong understanding of different data warehouse schema designs, data model design and documentation, as well as query optimization
• Expert SQL Skills. Experience with relational and non-relational databases: PostgreSQL, MySQL, Redshift, Snowflake, Elastic search, MongoDB), table design and query optimization for each specific platform
• Experience with Power BI or other data visualization tools preferred
• Experience using AWS services such as S3, Redshift, Lambda, RDS
• Strong expectation-setting on required effort/duration to reliably deliver work to meet client deadlines.
Good to have skills
• Experience with Power BI or other data visualization tools preferred
• Experience using AWS services such as S3, Redshift, Lambda, RDS
Key responsibiltes
• Perform data loads and optimize data for extraction and reporting.
• Assist with discovery of data requirements to ensure proper data collection and plan/roadmap the analysis.
• Create and maintain complex data pipelines that support high-volume, high-dimensionality data from varying sources using a variety of tools and ETL techniques.
• Maintain complex databases by performing appropriate database management functions (e.g., maintain space availability, rebuilds indexes, file cleanup, runs utilities to check database integrity) to ensure optimum capacity and application performance.
• Produce and maintain data pipelines in support of client and internal reporting needs.
• Support development of client facing documentation such as a comprehensive data dictionary and data model documentation.
• Establish and maintain data models in support of operational reports, dashboards, and scorecards for internal and external clients.
Education Qulification
1. Bachelor’s or Master Degree or equivalent Degree
Certification If Any
1. AWS Certified Cloud Practitioner
2 AWS Certified Solutions Architect – Associate
Shift timing
12 PM to 9 PM and / or 2 PM to 11 PM - IST time zone ( To have good overlap with the US team)
Location:
DGS India - Mumbai - Thane Ashar IT ParkBrand:
MerkleTime Type:
Full timeContract Type:
PermanentTop Skills
What We Do
We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next
