Senior Data Engineer

Role descriptionJob Title: Sr. DATA EngineerWork LocationIrving TXJob Description:Mandatory Karat InterviewRole OverviewWe are seeking a highly skilled and motivated AWS Certified Engineer to design build and optimize scalable data solutions within the Amazon Web Services AWS ecosystem The ideal candidate will have strong expertise in big data processing using PySpark and a deep understanding of data warehousing concepts including Hive and modern table formats like Iceberg This role involves developing deploying and managing robust efficient and secure data pipelines and analytics solutions on AWS leveraging core networking and compute servicesCore ResponsibilitiesAWS Solution Design Implementation Design develop and deploy scalable and costeffective data solutions on AWS leveraging services such as S3 for data lakes EC2 EMR Glue Athena Lambda Redshift and KinesisData Pipeline Development Build and maintain robust ETLELT data pipelines using PySpark for data ingestion transformation and loading into various data stores including those utilizing open table formats like IcebergBig Data Processing Develop and optimize big data processing jobs using PySpark on AWS EMR or AWS Glue handling large datasets efficiently and integrating with Iceberg table formatsData Warehousing Design implement and manage data warehousing solutions including schema design data modeling and query optimization with a focus on Hive and modern data lake table formats like Iceberg for historical data and analytical queriesCloud Infrastructure Networking Implement secure and robust cloud infrastructure components including VPCs subnets routing and security groups to ensure proper connectivity and isolation for data solutionsContainerized Workloads Design deploy and manage containerized data processing applications on Amazon Elastic Kubernetes Service EKSPerformance Tuning Optimization Optimize AWS resources and big data applications Spark Hive Iceberg for performance cost and efficiencyData Governance Security Implement best practices for data security access control and compliance within AWS including IAM policies S3 bucket policies and encryptionMonitoring Troubleshooting Set up monitoring ing and logging for data pipelines and AWS infrastructure troubleshoot and resolve issues promptlyAutomation Develop and maintain automation scripts using Python and shell scripting for infrastructure provisioning deployment and operational tasksCollaboration Work closely with data scientists analysts and other engineering teams to understand data requirements and deliver reliable data solutionsRequired Skills Qualifications AWS Certification Hold at least one AWS certification eg AWS Certified Solutions Architect Associate AWS Certified Data Analytics Specialty AWS Certified Developer AssociateAWS Services Expertise Handson experience with key AWS services for data processing and storage includingStorage S3 for data lakes EC2Data Processing EMR Glue Athena LambdaNetworking VPC Subnets Routing Security GroupsContainerization EKSBig Data Processing Strong proficiency in PySpark for developing complex data transformations and analyticsData Lake Table Formats Practical experience with Apache Iceberg for managing and querying data lakesData Warehousing Indepth knowledge and practical experience with Apache Hive for data storage querying and schema managementProgramming LanguagesPython Expert level proficiency in Python for scripting data manipulation and AWS automation Boto3Shell Scripting Proficient in shell scripting for automation and operational tasksDatabase SQL Strong SQL skills for data querying and manipulationData Concepts Solid understanding of ETLELT processes data modeling distributed computing and data governanceGood to Have Skills Containerization Orchestration Experience with Kubernetes for deploying and managing containerized applicationsCICD Experience with CICD tools and practices eg AWS CodePipeline GitHub Actions GitLab CI for automating deployment of data solutionsOrchestration Experience with workflow orchestration tools like Apache AirflowVersion Control Proficient in using Git for source code managementOther Big Data Technologies Exposure to other big data technologies like Apache Kafka Flink or PrestoCertifications AWS Certified Solutions Architect Associate ProfessionalAWS Certified Data Analytics SpecialtyAWS Certified Developer Associate