Senior Software Developer - ETL/SQL/SDTM
Location
Bangalore | India
Job description
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
- Provide technical guidance, training and support to other team members
- 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
- Through understanding of Clinical research life cycle and Clinical Data standards.
- Other duties as assigned
Education/Language:
- BE / B Tech / M Tech / Master of Science degree in Computer Science and/or equivalent
- Excellent knowledge of English
Professional Skills & Experience
- Minimum of 3-5 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
- Thorough understanding of the data formats like CDISC, SDTM, CDISC(92,45,101), Q Format, Customized Data formats ..etc
- 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 modeling and design
- Strong technical project management experience and team leadership skills including scope management, work planning and work delegation
- Strong troubleshooting skills and use of defect/feature management systems
- Proven ability to work independently and with technical team members (Startup environment experience is a plus)
- Excellent verbal and written communication skills
Technical Skills & Experience
- 3+ years with SQL Server, ETL and Data Warehousing
- 3+ years with ETL architecture and design
- 2+ years with Data modeling (physical & logical)
- 3+ years with SDTM mapping.
- Experience with Performance tuning and management of SQL Server
- Experience with Dimensional modeling
- Experience with any BI tools(eg Qlik, MicroStrategy, etc)
- Knowledge of clinical trial data is a plus
Job tags
Salary
