Job Summary
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
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 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
Key Responsibilities
ETL DeveloperEXPECTED SERVICES1. Contractor will develop new features / enhancements, refactor legacy ETL code andfix bugs for the Business Intelligence and Analytics team . This can include, but is notlimited to, data mart design/development2. Contractor will own tasks through the entire software development life cycle fromconcept to release to production including: helping to document businessrequirements, documenting development approach, implementing code changes,testing, gathering approvals and migrating code3. Contractor will develop code changes, unit tests, integration tests and performancetests pursuant to the development standards and best practices as documented byGoogle4. Contractor will develop code changes based on functional requirements defined viabusiness requirement documents (BRDs), functional specification design documents(FSDs),Technical Design Documents (TDDs), or other written / verbal instructions5. Contractor will work with Google business analysts, program managers and othercontractors (including contractors from other vendors) to determine functional &technical requirementsSkills● 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 programminglanguages - 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 codepost-production● Owns report/dashboard delivery (PLX) tasks from development through supportincluding: 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 forassigned design / development and testing tasks as prescribed by BI team● Has supply chain experience background in above mentioned areaQualificationsMinimum 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-scaledistributed systems● Analytical skills with the experience identifying, quantifying, and effectively raisingbusiness risks associated with data quality or non-compliance● Strong communication and collaboration skills with capability to execute with businessstakeholders