Data Engineer (AWS Redshift) in Chicago, Illinois onsite at Chicago, Illinois, USA |
Email: [email protected] |
From: aftab, convextech [email protected] Reply to: [email protected] Hope you are doing good.!! Please let me know if you are interested in the below position.!! Position : Data Engineer (AWS Redshift) Location : Chicago, Illinois onsite Duration : 6 months Visa : USC/GC Interview mode: Interview : Phone/skype, Job Description Responsibilities: Data Engineer who has experience migrating from Oracle to Redshift AWS. Technologies: AWS DMS, CDC, SCD, Amazon S3, AWS Glue, Redshift, Airflow We are hiring a Data Engineer to assist with our AWS Redshift migration. We are migrating from Oracle to Redshift and need someone that has done a similar migration in the past! Qualifications and Skills: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. Extensive hands-on experience designing, developing, and maintaining data pipelines and ETL processes on AWS Redshift, including data lakes and data warehouses. Proficiency in SQL programming and Redshift stored procedures for efficient data manipulation and transformation. Hands-on experience with AWS services such as AWS DMS, Amazon S3, AWS Glue, Redshift, Airflow, and other pertinent data technologies. Strong understanding of ETL best practices, data integration, data modeling, and data transformation. Experience with complex ETL scenarios, such as CDC and SCD logics, and integrating data from multiple source systems. Demonstrated expertise in AWS DMS for seamless ingestion from on-prem databases to AWS cloud. Proficiency in Python programming with a focus on developing efficient Airflow DAGs and operators. Experience in converting Oracle scripts and Stored Procedures to Redshift equivalents. Familiarity with version control systems, particularly Git, for maintaining a structured code repository. Proficiency in identifying and resolving performance bottleneck and fine-tuning Redshift queries, Strong coding and problem-solving skills, and attention to detail in data quality and accuracy. Ability to work collaboratively in a fast-paced, agile environment and effectively communicate technical concepts to non-technical stakeholders. Proven track record of delivering high-quality data solutions within designated timelines. Experience working with large-scale, high-volume data environments. The ideal candidate possesses several years of hands-on experience working with Redshift and other AWS services and a proven track record of delivering high-performing, scalable data platforms and solutions within the AWS cloud. AWS certifications related to data engineering or databases are a plus. MD AFTAB ALAM US IT Recruiter ConvexTech Inc. Direct : 4693007818 ext-412 Email : [email protected] https://www.linkedin.com/in/md-aftab-alam-69114611b Keywords: sthree information technology green card Maryland |
[email protected] View all |
Wed Sep 27 01:14:00 UTC 2023 |