Local candidates preferred
Need Passport No
Hi,
Pleasure mailing you. Please go through the below requirement and let me know if you are comfortable for the position.
Please send me your updated resume along with the best hourly rate, work authorization status and availability.
An early response is really appreciated
Role : AWS Data Engineer
Location : El Segundo, CA (Hybrid Model)
Duration : 6-12 Months
Responsibilities
· Gain an understanding of the scope and timeline of the migration project
· Execution of all migrations assigned by your manager on a daily and weekly basis
· Collaborate with product/business stakeholders, architects, engineering teams and analytics teams to build accurate, timely and actionable information products
· Design, develop, test, and maintain ELT (Extract, Load, Transform) processes to bring data from multiple sources into a single warehouse environment
· Ensure smooth ongoing operations of data warehouse and data pipeline platform with high availability and performance while making continuous improvements and leverage best practice and features of the technical stack offers.
· Provide production support on a rotating basis
Qualifications :
· 5+ years of experience with SQL
· 2+ years of experience with Python
· Strong understanding of BI best practices, relational structures, data warehousing methodologies, ELT processing and dimensional data modeling
· Excellent data analytics skills – the candidate should be able to test and document the accuracy of the data efficiently.
· Experience with source code management and version control (Git/GitHub/GitLab)
· Excellent collaboration and commutation skills, both written and verbal
· Must be self-directed and be able to thrive in a quick turn-around working environment
· Expert SQL skills, particularly in an analytics / reporting capacity. Extensive experience creating and maintaining DW and reporting processes
· Advanced Data modeling skills (hands-on experience + theoretical understanding)
· Implementing star-schemas/snowflake-schemas
· Incremental and Full Load
· Slowly changing dimensions
· Advanced SQL skills required
· Primary/foreign keys, indexes (when to use them)
· Join and Set Operations
· Tables and Views (How are they different? Pros and cons of using)
· Window functions
· Scalar and aggregate functions
Nice to Have:
· Experience with Snowflake
· Experience working in an Agile environment
· Prior experience performing a data warehouse migration
Thanks,
Maneendra K
US IT Recruiter
Email : maneendrak@tekskillsinc.com | www.tekskills.in
INDIA | USA | CANADA | UK I AUSTRALIA
ISO 9001:2015 | ISO/IEC 27001:2013 | ISO 45001:2018 | ISO/IEC 20000-1:2018
Appraised at CMM Level 3 | WMBE Certified Company
