ETL Lead

Must Have skills : Redshift and AWS Glue

Job Description :

• years of strong technical experience in implementing Data management solution for batch and real time data warehouse / data lake designs.
• Strong working experience in AWS RedShift and AWS Glue, Crawler and Data Catalog
• Technical expert in on-prime, cloud and hybrid data lake solution using AWS eco systems for next generation reporting and BI business needs.
• Good experience in Business Analysis, Estimation, Development, Testing & end to end Implementation at enterprise scale.
• Extensive knowledge and experience in Agile Scrum Process, Kanban and Waterfall lifecycle methodologies
• Extensive experience in Data Engineering / Data Management Process, SDLC with ETL / ELT pipelines
• Experience in developing key performance indicator reports and dashboards to provide value from data insights and trends.
• Extensive experience in building and maintaining data warehouse.
• Extensively worked in Data Extraction, Modeling and Query Designing.
• Extensive experience in Loading, Scheduling, Monitoring, Process Chains.
• Created process chains for periodic upload of master data, transactional data, text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Experienced in the migration of data driven projects from on-premises to Cloud.
• Hands-on experience in Data Modelling, Data Warehousing / ETL Architecture
• Experience in creating / Designing Data transfer packages to various stages of DW
• Liaise with business for requirement gathering and responsible for business discussions, client meetings, offshoreonsite model and implementing the project requirements.
• Creating cases for positive / negative testing, carrying out and documenting validations.
• Excellence in data lake delivery on AWS Redshift, data life cycle management