ETL Developer - Atlanta

Company: KK Associates LLC
Your Application: You have not applied yet
Location: Atlanta, USA
JOB DESCRIPTION

Hi,

Greetings from KK Software Associates.

This is Syed Fazulul from KK Software Associates.

I have an urgent requirement of ETL Developer, please go through the below requirement and forward me your updated resume with contact details ASAP.

Position: ETL Developer

Location: Atlanta, GA

Duration: 6+ months with extension

Due to covid-19, it will be remote for now. Post covid-19 consultant should work onsite.

Responsibilities

The ETL Developer will be responsible for design, development and testing of stored procedures and ETL processes for the Enterprise Data Warehouse. The ETL Developer will work closely with BI Team and business to understand business requirements, translate them into technical design, develop data pipelines and implement solutions in the Data Warehouse (Redshift).

Responsibilities:

Develop complex stored procedures and SQL OLAP/Analytic functions per business requirements.

Read existing stored procedures and learn the data model and business rules from it.

Conduct database testing to ensure data quality and integrity.

Optimize existing ETL process and SQL statements to improve performance.

Analyze and solve complex technical data and transformation issues.

Create and maintain ETL process design, data model and operations documentation.

Participate in an on-call rotation as needed.

Complete other duties as assigned.

Competencies:

Innovative: displays original thinking and creativity; meets challenges with resourcefulness; presents ideas and information in a manner that gets others' attention

Initiative: undertakes self-development activities; takes independent actions and calculated risks; looks for and takes advantage of opportunities; asks for and offers help when needed

Dependability: follows instructions, responds to direction; takes responsibilities for

own actions; keeps commitments; completes tasks on time or notifies appropriate personal with an alternate plan; arrives at meetings and appointments on time

Required Experience:

5 years of demonstrated experience in SQL ETL development for the large Enterprise Data Warehousing environment.

Experience with Data model design and complex stored procedure development.

Experience with Oracle and/or PostgreSQL and/or Redshift and PL/SQL scripting and query optimization.

Knowledge and experience with full SDLC (Software Development Life Cycle).

Must possess strong written and verbal communication skills.

Adaptable to change and able to work independently and as part of a team.

Strong analytical skills with the ability to collect, organize, disseminate, and present significant amounts of information with an attention to detail and accuracy.

Manage and prioritize work effectively with minimal supervision.

Desired Skills

Experience in one (or more) scripting languages is a big plus: Unix Shell, Bash, Python, Scala, Java)

AWS certification or experience with AWS services, S3, Glue, Redshift, Lambda, etc.

Working experience in an Agile methodology is preferred.

Experience with Tableau or other visualization tools is a plus.

Experience with Informatica is a plus.

Education Qualification:

Bachelor's degree in Computer Science or other relevant degree or demonstrable equivalent experience.

Regards

Syed Fazul | Delivery Manager

8751 Collin-McKinney Pkwy, unit # 1302 McKinney, TX 75070

Email: fazul.syed@kksoftwareassociates.com


Employment type: C2C, 1099


JOB TYPE
Work Day: Full Time
Salary: Negotiable


JOB REQUIREMENTS
Minimal experience: 4 years



Jobs you may be interested in


    Tips You May Be Interested In