Software Configuration & Development Engineer I Job in Bangalore at Eli Lilly & Company

Eli Lilly & Company is hiring for the role of Software Configuration & Development Engineer I!

Responsibilities of the Candidate:

• Create and maintain optimal data pipeline architecture ETL/ELT into Structured data
• Assemble large, complex data sets that meet functional/non-functional business requirements and create and maintain Multi-Dimensional modelling like Star Schema and Snowflake Schema, normalization, de-normalization, and joining of datasets
• Expert level experience creating Fact tables, Dimensional tables and ingest datasets into Cloud based tools. Job Scheduling and automation experience are a must
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc
• Set up and maintain data ingestion, streaming, scheduling and job monitoring automation Connectivity between Lambda, Glue, S3, Redshift, and Power BI needs to be maintained for uninterrupted automation
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and “big data” technologies like AWS and Google
• Build analytics tools that utilize the data pipeline to provide actionable insight into customer acquisition, operational efficiency and other key business performance metrics

Requirements:

• 2-5 years of in-depth hands-on experience in data warehousing Redshift or any OLAP to   support business/data analytics, business intelligence (BI)
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases and Cloud Data warehouses like Redshift
• Data Model development, additional Dims and Facts creation and creating views and procedures, enable programmability to facilitate Automation