Sr Data Engineer

Roles and Responsibilities: . 

• Tests, monitors, manage and validate data warehouse activity including data extraction, transformation, movement, loading, cleansing, and updating processes
• Building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting
• Collaborate with stakeholders to understand, define and document business applications, data sources/relationships, and needs (metrics, dimensions, charts and dashboards).
• Analyze and Identify new data sources as needed per stakeholder requirements.
• Working closely with analytics team and other business stakeholders to create data processing frameworks that help the business make sense of growing data
• Manage and monitor existing data pipelines and work with other team members to ensure best practices for ETL and data warehousing
• Work on optimization of data storage and processing infrastructure to reduce costs
• Facilitate integration of different BI tools as needed by business stakeholders
• Assist in the design and documentation of data infrastructure and technologies

Skills Required :

• Proficient in languages: Python.
• Minimum 2+ years' experience as Data Engineer
• Experience in AWS Stack - Glue, Athena, Quick sight, RDS, Redshift, Kafka, pySparkExperience setting up data pipelines, archiving data, data lakes
• Bachelors or Master's degree in computer science/Maths/statistics or related field
• Expertise with designing complex Data Models and Data Engineering solutions
• Write complex SQL for processing raw data, data transformations as well as data validations
• Experience with infrastructure as code using shell scripting
• Hands on experience in working with big data on AWS environments including cleaning/transforming/cataloging/mapping etc.
• Experience in setup of data warehouse using Amazon Redshift, creating Redshift clusters and perform data analysis queries
• Experience in ETL and data modeling on AWS ecosystem components - AWS Glue, Redshift, DynamoDB
• Familiarity with AWS data migration tools such as AWS DMS, Amazon EMR, and AWS Data Pipeline
• Certifications on AWS will be an added plus.