Job Description :
Role#1 : ETL + SQL combination with excellent SQL query writing exp. Max Rate 60/hr
Role#2 : ETL + SQL : It’s a support role, pls ensure candidate is comfortable working on support environment. Max Rate 62/hr
Skill : ETL Developer
Location : Sunnyvale CA
Client : Google, CA
Minimum Qualifications:
8+ yrs of experience in architecting and implementing full scale data warehouse systems
Experience working with Web-scale databases, Columnar or NoSQL technologies
Master level knowledge of SQL
Extensive hands-on experience in implementing data pipelines using ETL tools such as Pentaho Kettle (preferable), Informatica, IBM datastage etc
Strong hands-on experience in building reports and dashboards using tools such as Tableau etc
Experience with at least a programming language (Java, or Python
Preferred Qualifications:
Deep experience in building end to end BI solutions with master level proficiency in solution architecture, data modeling, ETL (eg: Pentaho, Informatica, IBM Datastage etc) and reporting (eg: Tableau) skills.
Ability to deal with ambiguity and thrive in a rapidly changing business environment.
Very strong analytical and problem solving skills.
Ability to learn a new business domain and build subject matter expertise in a short period of time.
Responsibilities:
Design and develop data warehouse solutions for complex business processes.
Work closely with business users and various platform, application and support teams to deliver reporting solutions.
Develop, test and deploy new data pipelines (ETL) to support
Support existing data pipelines. Troubleshoot and fix production issues; implement enhancements in existing data pipelines and reports.
Create project specific artifacts such as technical design documents, source to target transformation mapping docs, data dictionary, data flow diagrams etc.
Build reports and dashboards to support business critical decision making.
Own specific project areas and take proactive measures to maintain the health of the overall system.
Work closely with other members in the team to contribute to the improvements of the broader reporting landscape.