Data Engineer With Sybase ASE

• Role : Senior Data Engineer With Sybase ASE
• Location : Remote
• Contract

• 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 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 systems of record.
• •
• • 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

• • Participate in creating a long term ETL application support model.
• •
• • 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.
• •
• • Quality Control
• • 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

• 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