Lilly Data Integration Developer in Bangalore, India
At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 35,000 employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.
- Data Integration Developer
At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 39,000 global employees work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to improve the quality of life for patients around the globe.
The Global Services Solutions IDS Team supports company critical solutions that enable our Global Services business partners, e.g. Legal and Ethics and Compliance, to support and protect Lilly’s most essential assets. This position will be responsible for the support, development, and maintenance of our Global Services Insights Platform.
The Data Integration Developer has a deep understanding of various technologies and developer tools used to create stable, reliable, and effective modern data ecosystems for data science, data discovery, and BI/analytics. The Developer has expertise in problem solving and the ability to translate business requirements into designs and solutions.
Gather user requirements and translate them into business solutions.
Design, develop, test, improve, and maintain new and existing solutions for data integration, data prep, ingestion, cleansing, and transforming raw data into curated datasets for business consumption.
Incorporate deep data management expertise into solutions, including permissions, recovery, security, and monitoring.
Validate and qualify solutions.
Identify, troubleshoot, debug, and resolve technical issues.
Work with business and IT groups to understand source systems and enterprise infrastructure offerings.
Work with data from multiple data sources to build integrated views that will drive decisions
Consult with internal customers who own the data to develop information relationships that lead to actionable insights.
Work in Agile Sprints with business facing project teams
Work closely with other developers to ensure system consistency and adherence to standards and best practices.
Develop solid understanding of business processes and needs to identify new capabilities and features.
Optimize and maintain legacy solutions.
Collaborate with administrators and clients to provide technical and data management support.
Solve database usage issues and malfunctions.
Develop and maintain technical and training documentation.
Ensure all data solutions meet performance requirements.
Research and suggest new products, services, and protocols.
Partner with Solution and Data Architects to understand and influence evolving technical design.
Coach/ Mentor management, team, and others on technologies and design.
Bachelor’s Degree and 5+ years’ experience in the implementation of modern data ecosystems.
Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
Knowledge in Python, UNIX Shell scripting and ETL
Experience with JSON, REST API, and other data integration technologies
Demonstrated expertise in one or more cloud-based data solutions.
Excellent oral and written communication skills.
A high level of intellectual curiosity, external perspective, and innovation interest
Strong analytical, problem solving and investigative skills
Experience in applying quality and compliance requirements
Experience with security models and development on large data sets
Fluency in English.
Excellent self-management skills.
RDBMS MS SQL SERVER 2008/2005/2000, MS Access, Oracle8i/9i.
Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management
Studio, Query Editor, Reporting Server, MS-Access
ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS)
MS SQL Server Reporting Services (SSRS)
BI Tools MS SQL Business Intelligence
- ITIL Certification
Bachelor’s Degree or relevant degree
Lilly is an EEO/Affirmative Action Employer, and does not discriminate on the basis of race, gender, protected veteran status, disability or any other legally protected status.
- Job Families for Job Profiles
Software Configuration & Development
Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( LillyRecruitingCompliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. Any other correspondence will not receive a response.
Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.
At Lilly we strive to ensure our employees are part of a team that cares about them and our shared purpose of making life better for those around the world. How do we do this? We continue to look for ways to include, innovate, accelerate and deliver while maintaining integrity, excellence and respect for people. We hope that you seek to join us on our journey as we create medicine and deliver improved outcomes for patients across the globe!