Senior Data Analyst

Job Description

Responsibilities includes working on MDM platforms like ETL, data modelling, data warehousing and manage database related complex analysis, design, implement and support moderate to large sized databases. The role will help in providing production support and enhance existing data assets, design and develop ETL processes. Job Description: He/She will be responsible for design and development of ETL processes for large data warehouse. Required Qualifications: Experience in Master Data Management Platform like ETL or EAI, Data warehousing concepts, code management, automated testing Experience in developing ETL design guidelines, standards and procedures to ensure a manageable ETL infrastructure across the enterprise. Strong command on MS SQL/Oracle SQL, Mongo DB, PL/SQL and Complex Data Analysis using SQL queries. Development experience in Big Data eco system with the ability to design, develop, document & architect Hadoop applications would be plus. Experience in HDFS/Hive /Spark/NoSQL Hbase Strong knowledge of data architecture concepts. Strong knowledge of reporting and analytics concepts. Knowledge of Software Engineering best practices with experience on implementing CI/CD using Jenkins Knowledge of the Agile methodology for delivering software solutions Good to have skills in SQL Server DB and Windows server file handling and Power Shell scripting. What will you do in this role? Manage and develop ETL processes for large data warehouse. Provide analysis and design reviews with other development teams to avoid duplication of efforts and inefficiency in solving the same application problem with different solutions. Work closely with business partners, business analysts and software architects to create and operationalize common data products and consumption layers. Acts as a developer in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs. Develops simple or highly complex code. Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.