| Data Integration Lead at Remote, Remote, USA |
| Email: [email protected] |
| From: Devakar, KK Software Associates [email protected] Reply to: [email protected] Note: Please don't share OPT, CPT and H4EAD Client: TCS Location: Hartford or Remote support (US, INDIA) during EST hours JD: 2 Required Technical Skill Set 1. Hands on in AWS Data services like RDS, Lambda, AWS Glue ETL for calling APIs and extracting data into S3 and RDS and further visualizing with QuickSight 2. Working knowledge, awareness of security and best practices for IAM,S3, IAM., Lambda ,AWS Glue,VPC, Secret Manager, Cloud Formation, Terraform ,QuickSight 3. Ability to guide testing team on ETL Strategy 4. Strong PySpark and Python Skills 5. ETL design skills 6. Implementation experience on CICD for Glue 7. Implementation experience on CICD for Lambda 8. Proficient in database/ model design for RDS 9. Experience in normalizing complex JSON Schema and loading into database. 10. Good understanding of data modelling (With and without tools) including design of entity relationships, data flows and conceptual and logical data models, data dictionaries. 11. Strong knowledge in writing page long complex SQL queries to join 40+ to create denormalized layer for reporting. 12. Strong data modelling experience for Analytical and Reporting Layer for BI and Big data environments 13. Proficient in query tuning, denormalization and preparation of Analytical Layer for reporting 14. Should be well versed working in Agile methodology. 15. Very Good communication skill. Must-Have Hands on in AWS Data services like RDS, Lambda, AWS Glue ETL for calling APIs and extracting data into S3 and RDS and further visualizing with QuickSight Working knowledge, awareness of security and best practices for IAM,S3, IAM., Lambda ,AWS Glue,VPC, Secret Manager, Cloud Formation, Terraform ,QuickSight Ability to guide testing team on ETL Strategy Strong PySpark and Python Skills ETL design skills Experience in normalizing complex JSON Schema and loading into database. Good understanding of data modelling (With and without tools) including design of entity relationships, data flows and conceptual and logical data models, data dictionaries. Strong knowledge in writing page long complex SQL queries to join 40+ to create denormalized layer for reporting. Good-to-Have Reporting knowledge General understanding on ETL processing Serverless design Keywords: business intelligence sthree |
| [email protected] View all |
| Tue Oct 17 22:44:00 UTC 2023 |