The Software Developer will work closely with clients and provide technical consulting services and oversight for specific projects that include ETL development
- The Software Developer will provide direction on database aspects to the team of existing ETL developers on various database related activities
- This position reports to the Team Lead-ETL, Technical Services
KEY TASKS & RESPONSIBILITIES
- Design, develop, test, and deploy highly efficient SQL code and data mapping code according to specifications.
- Design and develop ETL code in support of analytic software applications and related analysis projects.
- Work with Analytics developers, other team members and clients to review the business.
- Requirements and translate them into database objects.
- Research and utilize new technologies.
- Collaborate with the Quality Assurance team to test the applications functionality.
- Provide diagnostic support and fix defects as needed
- Ensure compliance with eClinical Solutions/industry quality standards, regulations, guidelines, and procedures.
- Manage multiple timelines and deliverables (for single or multiple clients) and managing client communications as assigned.
- Provide programming solutions and support using elluminate Data Intelligence Hub platform.
- Configuration, migration, and support of the elluminate platform
- Other duties as assigned
Education & Experience
- BE / B Tech / M Tech / Master of Science degree in Computer Science and/or equivalent
- Excellent knowledge of English
Professional Skills
- Minimum of 2 years in database design and development experience
- Thorough experience in data warehouse architecture, design, and development.
- Thorough understanding of database design principles and best practices
- Excellent experience in designing scalable, modular SQL code and ETL procedures using MS-SQL Server
- Strong Software Development Lifecycle experience (Agile methodology experience is a plus)
- Excellent understanding of relational database concepts, data modelling, and design
- Strong troubleshooting skills and use of defect/feature management systems
- Proven ability to work independently and with technical team members (Start-up environment experience is a plus)
- Excellent verbal and written communication skills
Technical Skills
- 1+ years with SQL Server, ETL and Data Warehousing
- 1+ years with ETL architecture and design
- Experience with Performance tuning and management of SQL Server
- Knowledge of Dimensional modelling
- Understanding of any BI tools (eg, Qlik, MicroStrategy, etc)
- Knowledge of clinical trial data is a plus