Job Details

Home

AWS Redshift Data Engineer - Harrisburg, PA (Hybrid Onsite) at Harrisburg, Arkansas, USA

Email: [email protected]

AWS Redshift Data Engineer - Harrisburg, PA (Hybrid Onsite)

Hi,

Hope you are doing well.

Please review the JD & let me know if you're interested.

Role: AWS Redshift Data Engineer

Location:
200 Amp Drive, Harrisburg, PA 17112 (Hybrid Onsite)

Duration: 12+ Months Contract

Note: Candidate needs to be in the office 3 day every week

Key points:

-Minimum 5-7 years of relevant experience in

AWS
S3, Glue, Athena,

Redshift
, and EMR,EC2.

-Strong SQL programming experience

-Talend Framework is kind of a must.

-Optional: Other

AWS
Services is added advantage.

Job Description:

As an

AWS

Redshift

Data

Engineer
, the primary responsibility is to design, implement, and maintain

data
solutions using Amazon

Redshift
. Your role involves working with large-scale

data
sets, optimizing performance, and ensuring the reliability and availability of the

Redshift
environment. Here is a general job description for an

AWS

Redshift

Data

Engineer
:

Data
Modeling and Design:
Develop and maintain

data
models for

Redshift

data
bases, including schema design, table structures, and optimization techniques. Collaborate with

data
architects and stakeholders to understand requirements and translate them into efficient

data
structures.

ETL Development:
Design and implement Extract, Transform, Load (ETL) processes to extract

data
from various sources, transform it as per business requirements, and load it into

Redshift
. Develop efficient and scalable ETL workflows, considering

data
quality, performance, and

data
governance.

Performance Optimization:
Optimize query performance by creating appropriate

data
distribution keys, sort keys, and compression techniques. Identify and resolve performance bottlenecks, fine-tuning queries, and optimizing

data
processing to enhance

Redshift
's performance.

Data
Integration:
Integrate

Redshift
with other

AWS
services, such as

AWS
Glue,

AWS
Lambda, Amazon S3, and more, to build end-to-end

data
pipelines. Ensure seamless

data
flow between different systems and platforms, maintaining

data
integrity and consistency.

Monitoring and Troubleshooting:
Implement monitoring and alerting systems to proactively identify issues and ensure the stability and availability of the

Redshift
cluster. Perform troubleshooting, diagnose and resolve

data
-related issues, and work closely with support teams to resolve any performance or operational problems.

Security and Compliance:
Implement security best practices to protect

data
stored in

Redshift
. Ensure compliance with

data
privacy regulations and industry standards, such as GDPR and HIPAA. Implement encryption, access controls, and

data
masking techniques to secure sensitive

data
.

Documentation and Collaboration:
Maintain documentation of

data
models, ETL processes, and system configurations. Collaborate with cross-functional teams, including

data
scientists, analysts, and software

engineer
s, to understand

data
requirements and provide

data
solutions that meet their needs.

Scalability and Capacity Planning:
Plan and execute strategies for scaling

Redshift
clusters to handle increasing

data
volumes and user demands. Monitor resource utilization, track

data
growth, and make recommendations for capacity planning and infrastructure scaling.

Knowledge or previous experience in oracle PLSQL will be added advantage

Thanks

Mayank Verma

Technical Recruiter | Empower Professionals

[email protected]
|Official Phone:
732-356-8008
x 364

LinkedIn
:

https://www.linkedin.com/in/
mayankdverma/

-------------------------------------------------------------------------------------------------------------

Fax:

732-356-8009
|
100 Franklin Square Drive Suite 104
|
Somerset, NJ 08873

www.empowerprofessionals.com

Certified NJ and NY Minority Business Enterprise (NMSDC)

Chandan Khandelwal

100 Franklin Square Drive Suite 104, Somerset, AZ 08873

Mayank

Somerset, NJ 08873, Somerset, NJ 08873,
Somerset, NJ,
NJ
08873

Keywords: sthree information technology Arizona New Jersey New York Pennsylvania

[email protected]
View all

Thu Aug 24 02:06:00 UTC 2023

To remove this job post send "job_kill 563275" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.

Your reply to [email protected] -

To

Subject
Message -

mayank@empowerprofessionals.com wrote:
AWS Redshift Data Engineer - Harrisburg, PA (Hybrid Onsite)

Hi,

Hope you are doing well.

Please review the JD & let me know if you're interested.

Role: AWS Redshift Data Engineer

Location: 
200 Amp Drive, Harrisburg, PA 17112 (Hybrid Onsite)

Duration: 12+ Months Contract

Note: Candidate needs to be in the office 3 day every week

Key points:

-Minimum 5-7 years of relevant experience in

AWS
 S3, Glue, Athena,

Redshift
, and EMR,EC2.

-Strong SQL programming experience

-Talend Framework is kind of a must.

-Optional: Other

AWS
 Services is added advantage.

Job Description:

As an

AWS

Redshift

Data

Engineer
, the primary responsibility is to design, implement, and maintain

data
 solutions using Amazon

Redshift
. Your role involves working with large-scale

data
 sets, optimizing performance, and ensuring the reliability and availability of the

Redshift
 environment. Here is a general job description for an

AWS

Redshift

Data

Engineer
:

Data
 Modeling and Design:
 Develop and maintain

data
 models for

Redshift

data
bases, including schema design, table structures, and optimization techniques. Collaborate with

data
 architects and stakeholders to understand requirements and translate them into efficient

data
 structures.

ETL Development:
 Design and implement Extract, Transform, Load (ETL) processes to extract

data
 from various sources, transform it as per business requirements, and load it into

Redshift
. Develop efficient and scalable ETL workflows, considering

data
 quality, performance, and

data
 governance.

Performance Optimization:
 Optimize query performance by creating appropriate

data
 distribution keys, sort keys, and compression techniques. Identify and resolve performance bottlenecks, fine-tuning queries, and optimizing

data
 processing to enhance

Redshift
's performance.

Data
 Integration:
 Integrate

Redshift
 with other

AWS
 services, such as

AWS
 Glue,

AWS
 Lambda, Amazon S3, and more, to build end-to-end

data
 pipelines. Ensure seamless

data
 flow between different systems and platforms, maintaining

data
 integrity and consistency.

Monitoring and Troubleshooting:
 Implement monitoring and alerting systems to proactively identify issues and ensure the stability and availability of the

Redshift
 cluster. Perform troubleshooting, diagnose and resolve

data
-related issues, and work closely with support teams to resolve any performance or operational problems.

Security and Compliance:
 Implement security best practices to protect

data
 stored in

Redshift
. Ensure compliance with

data
 privacy regulations and industry standards, such as GDPR and HIPAA. Implement encryption, access controls, and

data
 masking techniques to secure sensitive

data
.

Documentation and Collaboration:
 Maintain documentation of

data
 models, ETL processes, and system configurations. Collaborate with cross-functional teams, including

data
 scientists, analysts, and software

engineer
s, to understand

data
 requirements and provide

data
 solutions that meet their needs.

Scalability and Capacity Planning:
 Plan and execute strategies for scaling

Redshift
 clusters to handle increasing

data
 volumes and user demands. Monitor resource utilization, track

data
 growth, and make recommendations for capacity planning and infrastructure scaling.

Knowledge or previous experience in oracle PLSQL will be added advantage

Thanks

Mayank Verma

Technical Recruiter | Empower Professionals

mayank@empowerprofessionals.com
 |Official Phone: 
732-356-8008
 x 364

LinkedIn
:

https://www.linkedin.com/in/
mayankdverma/

-------------------------------------------------------------------------------------------------------------

Fax:

732-356-8009
 |  
100 Franklin Square Drive  Suite 104 
|
 Somerset, NJ 08873

www.empowerprofessionals.com

Certified NJ and NY Minority Business Enterprise (NMSDC)

Chandan Khandelwal

100 Franklin Square Drive  Suite 104, Somerset, AZ 08873

Mayank

Somerset, NJ 08873, Somerset, NJ 08873, 
Somerset, NJ, 
NJ 
08873

Keywords: sthree information technology Arizona New Jersey New York Pennsylvania

Your email id:

Captcha Image:

Captcha Code:

Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 9

Location: Harrisburg, Pennsylvania