Job Title – ETL Developer
Location – San Jose CA
Duration: Long Term contract
Role/Responsibilities-
• 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
• 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
• Contractor will develop code changes, unit tests, integration tests and performance tests pursuant to the development standards and best practices as documented by Google
• 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
• 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 databridge ○ 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.