Sr. Software Engineer - Informatica ETL
- Bioclinica
- 2 - 5 years
- Bengaluru
- 6 years ago
- Email to a friend
- Report this job
Job Description
Primary Responsibilities At Bioclinica , the role of the Sr. Software Engineer , Data & Analytics is to focus on digital data asset transformation , data integration , analytical insight , and decision management support. The Sr. Software Engineer develops custom data acquisition & movement ETL software utilizing the Informatica PowerCenter platform in support of our Clinical Trial Imaging solution. Develops custom software or enhances commercial software packages to promote operational efficiencies , data movement (ETL) and aggregation , enhance decision making , or creating new features / function capabilities is the primary focus of this role. The Sr Software Engineer is a subject matter expert in software development primarily in the Informatica platform , SDLC , agile development , unit testing , documentation , understanding business requirements , converting business concepts / data maps to technical software delivery , data , production support , administration of the ETL platform and data quality. Ultimately , the role of the Sr Software Engineer is to build high - quality , innovative and fully performant software that complies with coding standards , technical design and complies with Regulatory & Compliance policies in the Extraction , Transformation , and Loading (ETL) of data from Imaging source systems to the Imaging Data Warehousing solution in support of Clinical Trials. Specifically , this role will: Execute full software development life cycle (SDLC) and agile development of data acquisition & movement ETL solutions supporting the Bioclinica Imaging Clinical Trial Data Warehouse. Designing , developing , maintaining and supporting functionality of fault tolerant scalable programs. Manages software versioning. Write well - designed , testable , secure code using Informatica PowerCenter & PL / SQL as a member of a highly performant Imaging data warehousing development team. SSIS , .Net , PowerBI , OBIEE and other applicable technologies is a plus. Perform detailed data analysis to understand source system data and source to target mapping. Creates and maintains databases. Creating and modifying stored procedures , user defined functions , and triggers. Lead and guide development teams on Informatica based ETL architectures as required. Develop & unit test Informatica ETL data loading processes for optimal performance based upon Service Level Agreements (SLAs) and business requirements. Determine operational feasibility of proposed solution designs. Develop & unit test Unix scripts for pre and post loading processes. Develop Oracle PL / SQL procedures , functions and performance tuning of SQL queries. Performance tune Informatica ETL mappings and report queries. Participate in data model , architecture and code reviews as required. Perform an active , leading role in shaping and enhancing overall ETL Informatica architecture. Identify , recommend and implement ETL process and architecture continuous improvements. Manage and coordinate the development projects , retrofit , maintain the versioning and perform the Informatica deployments. Develop the release plans by coordinating with different technical and business teams. Conducts root cause analysis on application and data issues throughout the life cycle of the project. Triages issues reported by users in production systems. Troubleshoots system failures and assesses root cause. Troubleshoot , debug and upgrade existing systems. Provide level 3 support on ServiceNow product support tickets. Comply with project plans and corporate and industry standards. Creates and maintains documentation across projects being supported including ongoing changes or amendments to specifications. Performs software solution capability reviews and presentations with technical and business colleagues as required. Collaborate with project teams to ensure timely delivery and quality of all project deliverables. Exhibit confidence and an extensive knowledge of emerging industry & technical practices when solving business problems. Communicates effectively with team , stakeholders , and other operations personnel on the successful execution of information systems development & integration deliverables. Effectively escalates issues proactively to ensure timely delivery. Protects operations by keeping information confidential. Secondary Responsibilities Maintains Quality Service and Departmental Standards by: Verifying work to ensure quality deliverables. Reading , understanding and adhering to organizational Standard Operating Procedures (SOPs). Assisting in establishing and enforcing departmental standards. Updates job knowledge by studying state - of - the - art development tools , programming techniques , and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. Contributes to team effort by: Helping others to accomplish results. Performing other duties as assigned. Attending and participating in applicable company sponsored training. Qualifications: Education: Degree in Computer Science / Information Technology or equivalent software engineering / Informatica developer experience. Experience: Proven 5 years in software development or programming experience as a Data Warehousing Software Engineer in large - scale ETL Informatica PowerCenter (v9.1 or higher) , PL / SQL & PWX Connectors. 2 Years hands - on experience using Informatica s Data Quality Developer , and Data Quality Analyst tool. OBIEE , PowerBI , SSIS , .Net experience a Plus. Proven knowledge of Informatica PowerCenter ETL processes , best practices , installation , configuration and administration. Demonstrated expert knowledge of PL / SQL programming and relational database design on the Oracle database platform. MS SQL Server and MS - SQL a plus. Proven experience conducting data analysis , profiling , cleansing , exception handling within ETL processes , matching , ETL business rule implementation , standardization and quality practices. 5 years SDLC and unit testing. SharePoint knowledge is a plus. Experience in the Life Sciences industry , CRO / Clinical Trial regulated environment preferred. Team player attitude with a willingness to lead when necessary. Devotion to continuing education on an annual basis. Additional skill set: A demonstrated passion for a value of enterprise data assets. Highly motivated self - starter. A drive to learn and master new technologies , techniques , and data sources. Continuous learning is key to success in this position. Strong analytical , organizational , verbal communication and business writing skills. Strong problem - solving , trouble - shooting skills. Flexible. Adaptable. Strong attention to detail. Strong ability to collaborate with developers , product managers , testers and business colleagues. Critical thinking abilities to take complex , ambiguous , abstract requirements and break them into smaller components , patterns , views , features and work epics , themes , stories. Ability to conceptualize and think creatively. Ability to work independently in an agile operational environment. Demonstrated ability to manage multiple tasks simultaneously and complete work within allocated time frames. Be accountable for the timely deliverables meeting all quality goals. Hands - on knowledge of current technology standards / trends coupled with a desire to continually expand personal knowledge / skills. Ability to manage change and cope with complex and ambiguous situations. Ability to establish and maintain relationships with other business and technology leaders. Strong written and verbal communication skills coupled with the ability to tailor communication to all levels of an organization. Demonstrated ability to debate ideas / strategy / business priorities , comfortable managing constructive conflict , and not afraid to challenge the status quo. Working conditions: Travel: 0 - 5% Lifting: 0 - 20lbs Other: Computer work for long periods of time This position description should not be deemed all inclusive. Additional requirements and expectations may be assigned. At all times , employees are expected to adhere to company policies and company SOPs. EEO Statement Bioclinica is an equal opportunity employer. Bioclinica evaluates qualified applicants without regard to race , color , religion , gender , national origin , age , sexual orientation , gender identity or expression , protected veteran status , disability / handicap status or any other legally protected characteristicJob Classification
Industry: Pharma, Biotech, Clinical ResearchFunctional Area: IT Software - DBA, Datawarehousing, Role Category: Programming & DesignRole: Programming & DesignEmployement Type: Full timeEducation
Under Graduation: B.Tech/B.E. in ComputersPost Graduation: M.Tech in ComputersDoctorate: Doctorate Not RequiredContact Details:
Company: BioClinicaLocation(s): Bengaluru+ View Contact
Keyskills: Unix Performance tuning MS SQL Production support Coding Agile Informatica Stored procedures SSIS SDLC
Fraud Alert to job seekers!
₹ Not Disclosed
Bioclinica
Bioclinica is the leader in scientifically-driven services and technology-enabled solutions in clinical research. Clinical trials are complex, and traditional approaches are either monolithic or fragmented. Successful trials require an ability to see key details and uncover hidden insights. Empl...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in