Senior Data Engineer(Location: Pune)

Senior Data Engineer Exp - 5 to 8 Location - Pune preferred Shift time - regular Joining - immediately Position Summary: 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. Job Functions, Essential Duties and Responsibilities Essential Job Functions: · Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients. · Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services). o Assist with Data Warehouse project definition and planning. o Implement and troubleshoot deployments. · Data Modeling o Create conceptual, logical and physical data models. o Create Entity Relationship diagrams and Dimensional models. · 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. 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 and platform. § Participate in creating long term ETL application support model. o Data Warehouse and Data Marts § Develop 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. 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. • Strong knowledge of SQL. • Very good understanding of data modeling techniques. • Strong expertise in Java or other data related programming languages. • Extensive Oracle and Pl/SQL experience and skills Preferred knowledge, skills and abilities: • Experience with data modeling • Experience with PowerBI, Tableau Show more Show less