C2C role: Data Engineer || Newton Center, MA (Hybrid)

[Yogesh Singh]

 

Hi,

Please share profiles for the role below, along with visa status (H1/H4/OPT) and LinkedIn ID.

LinkedIn ID should be before 2020

 

GC/USC on our W2/Full-time only (No C2C)

 

Role: Data Engineer with Change Data Capture (CDC)

Location: Newton Center, MA (Hybrid)

Rate:  $52/hr. C2C max, sorry, no flexibility

 

 

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, and 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

 

 

 

Thanks

Yogesh Pratap Singh

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.