What are the responsibilities and job description for the ETL Developer position at E-Solutions, Inc.?
Title: ETL Developer
Location: San Jose, CA - On-Site role
Duration: Long-Term Contract - W2
Job Description
ETL Developer EXPECTED SERVICES
1. Contractor will develop new features / enhancements, refactor legacy ETL code and fix bugs for the Business Intelligence and Analytics team . This can include, but is not limited to, data mart design/development
2. Contractor will own tasks through the entire software development life cycle from concept to release to production including: helping to document business requirements, documenting development approach, implementing code changes, testing, gathering approvals and migrating code
3. Contractor will develop code changes, unit tests, integration tests and performance tests pursuant to the development standards and best practices as documented by Google
4. Contractor will develop code changes based on functional requirements defined via business requirement documents (BRDs), functional specification design documents (FSDs),Technical Design Documents (TDDs), or other written / verbal instructions
5. Contractor will work with Google business analysts, program managers and other contractors (including contractors from other vendors) to determine functional & technical requirements Skills
● Experience in delivering Business Intelligence solutions - Mandatory ○ Preferably experienced in multiple BI aspects ○ Strong SQL skills in complex queries and data manipulation a must
● Experience in developing ETL / building data pipelines with ETL tools or programming languages - Mandatory
○ Experience in data bridge.
○ Python programming, shell scripting, java scripting experience a plus.
● Owns data integration delivery tasks from development through support including: documenting data modeling / development approach, implementing code changes, testing, gathering approvals, migrating code, and support / enhancement of code post-production
● Owns report/dashboard delivery (PLX) tasks from development through support including: documenting development approach, implementing code changes, testing, gathering approvals, migrating code, and support/enhancement of code post-production
● Will provide support for new and existing data models, ETL pipelines and data marts
● Will create and maintain detailed documentation via Google Docs / Sheets / Slides for assigned design / development and testing tasks as prescribed by BI team
● Has supply chain experience background in above mentioned area Qualifications Minimum qualifications:
● 5 or more years of experience in Data engineering projects
● Experience with SQL or equivalent database querying language
● Working knowledge of relational databases, including BigQuery, MySQL and large-scale distributed systems
● Analytical skills with the experience identifying, quantifying, and effectively raising business risks associated with data quality or non-compliance
● Strong communication and collaboration skills with capability to execute with business stakeholders.
ETL Developer4(ETL) AND (SQL) AND (BIGQUERY OR "BIG QUERY") AND (PYTHON)N/AC2C,W-2,1099,C2H,Part Time,Full Time,Other,Intern,Pass Through,Contract,SOLUTIONS,Hourly,Contract to Perm,W2,W2 - Profit Sharing,Sub-con,Permanent,Full TImeUnited States