Senoir Software Developer - III

Role & Responsibilities: 

• Collaborate closely with Data Scientists and Business Analysts to understand data and functional requirements. 
• Design and Build data pipelines to standardize, clean and ingest data. 
• Support existing Data Warehousing Environment and enhance based on new business needs.
•  Triage Production issues in Data Ingestion pipelines and work with stakeholders to resolve the same in a timely manner. 
• Write Optimised queries for ETL Extraction and Reporting. Enhance and Create New dashboards for Jobs, KPI and DQ Metrics. 
• Learn, adapt and implement new technologies to improve data ecosystem and overall data health. 

What is needed: 

• 4+ years of strong hands-on experience in enterprise data warehousing, designing and implementation of complex data solutions. 
• 2+ years of experience working with RDBMS Platforms like Oracle, MySQL. 
• Very good knowledge of SQL and ability to write analytical queries using but not limited to Rank, Lead, Lag, Partition functions. 
• Good knowledge of Query tuning, Indexes, Stats. 
• Experience working on Big Data Technologies like Hive, Presto, Spark SQL and knowledge of Hadoop architecture. 
• Experience working on ETL tools like Informatica, Pentaho, Nifi and knowledge of CDC. Good knowledge of SDLC.

What is good to have?

• Working experience on Cloud Environment preferably AWS. 

• Working Experience in an Agile environment.

• Exposure to notebook tools like Jupyter and Zeppelin Working Experience on reporting and dashboard tools.