Data Engineer
12 hours ago
Santa Clara, California, United States
PeopleNTech
Full-time
$50 - $52 Permanent
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Indent : SF_OP_199108-12-1
Role : Data Engineer
Location : Newton center, MA (Hybrid)
Rate: $50/hr to $52/hr
As a Senior Data Engineer you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency.
Section 2: Job Functions, Essential Duties and Responsibilities Essential Job Functions:
• Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).
• Assist with Data Warehouse project definition and planning.
• Troubleshoot issues as they occur.
• Data Integration
o Services
▪ Design and build data ingestion tools, metrics, alerts and notifications, metadata management.
▪ Design and build data replication services and Change Data Capture (CDC) processes to incrementally update data in the data warehouse / data marts from Ascensus systems of record.
o ETL development
▪ Contribute to standards and best practices for implementing ETL tools in support of the DW vision and reference architecture.
▪ Build and maintain ETL solutions on Oracle using PL/SQL Version 06/01/2019 Page 2
▪ Participate in creating a long term ETL application support model. o Data Warehouse and Data Marts
▪ Adhere to technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.
▪ Organize metadata and define processes for loading data into and extracting data from the warehouse / marts.
o Quality Control o Peer code review and quality assurance duties throughout the data warehouse project life cycle; creating, executing and updating unit test plans and test cases for necessary projects and application releases.
• Assist with other tasks and projects as assigned `
Section 3: Experience, Skills, Knowledge Requirements Required skills and experience
• 5+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques and technology.
• Bachelor's degree or equivalent work experience. • Strong knowledge of Data Warehousing and ETL design/tools. • Excellent analytical skills. • Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents. • Extensive Oracle and Pl/SQL experience and skills • Good experience with relational databases like Sybase ASE, Oracle, MySQL. Preferred knowledge, skills and abilities: • Experience with PowerBI, Tableau • Experience with Informatica
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Role : Data Engineer
Location : Newton center, MA (Hybrid)
Rate: $50/hr to $52/hr
As a Senior Data Engineer you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency.
Section 2: Job Functions, Essential Duties and Responsibilities Essential Job Functions:
• Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).
• Assist with Data Warehouse project definition and planning.
• Troubleshoot issues as they occur.
• Data Integration
o Services
▪ Design and build data ingestion tools, metrics, alerts and notifications, metadata management.
▪ Design and build data replication services and Change Data Capture (CDC) processes to incrementally update data in the data warehouse / data marts from Ascensus systems of record.
o ETL development
▪ Contribute to standards and best practices for implementing ETL tools in support of the DW vision and reference architecture.
▪ Build and maintain ETL solutions on Oracle using PL/SQL Version 06/01/2019 Page 2
▪ Participate in creating a long term ETL application support model. o Data Warehouse and Data Marts
▪ Adhere to technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.
▪ Organize metadata and define processes for loading data into and extracting data from the warehouse / marts.
o Quality Control o Peer code review and quality assurance duties throughout the data warehouse project life cycle; creating, executing and updating unit test plans and test cases for necessary projects and application releases.
• Assist with other tasks and projects as assigned `
Section 3: Experience, Skills, Knowledge Requirements Required skills and experience
• 5+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques and technology.
• Bachelor's degree or equivalent work experience. • Strong knowledge of Data Warehousing and ETL design/tools. • Excellent analytical skills. • Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents. • Extensive Oracle and Pl/SQL experience and skills • Good experience with relational databases like Sybase ASE, Oracle, MySQL. Preferred knowledge, skills and abilities: • Experience with PowerBI, Tableau • Experience with Informatica
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.