What are the responsibilities and job description for the BI-ETL Consultant position at Precision Technologies Corp?
Job Description
BI-ETL Consultant
Location: 1825 South Grant Street, San Mateo, CA, 94402, USA - Onsite -- Few times in a month. (after month)
No. of Interviews:
- 2 Technical Evaluation with Nagarro
- 1 DM Round with Nagarro
- 1 Client
Job Description-
Mandatory
10 years of ETL/ELT developer experience.
Experience in SQL and manipulating large data sets in a database.
Experience with ELT development in Snowflake managed service.
Experience with ELT orchestration using Airflow.
Experience with full and incremental ETL using Informatica Power Center.
Expertise in Developing ETL/ELT for Data Warehouse Integration from various data sources.
Expert level of both OLTP and Dimensional schema.
AWS Cloud experience.
Experience in any Reporting Tools, preferred MicroStrategy.
Experience in production support.
PST Time zone.
Experience extracting and manipulating data using Python.
Preferred expertise in building key data pipelines using AWS analytical services like S3, EC2, EMR, Glue, Athena.
Experience in AWS terraform.
New Relic set up and maintenance.
Experience using GIT.
Experience using Rally.
Experience using Scala.
Bay area preferred and team meetups few times in a month.
