Title: Quality Assurance Analyst/Engineer
Location:Boston, MA 02215
Team: Analytics/Data Warehousing
Start: 10/6/14
Duration: 6 months
Interview Process: phone then on site
Project: DFCI is going through a remediation of their clinical data warehouse as part of their Epic eCare Healthcare Enterprise Solution implementation. The Quality Assurance Analyst will work as part of a team remediating the Dana-Farber Cancer Institute's clinical, operational and financial data warehouse for the Epic implementation.
Job Description
Must haves:
· Three years experience in QA roles, supporting Data Extraction, Transformations and Loading in an enterprise team development environment.
· Proficiency with writing SQL scripts for testing ETL processes, Oracle preferred.
· Excellent communication skills, team player, ability to work individually and meet tight deadlines.
Skills, Abilities, Competencies
· Strong experience with relational database management systems (RDBMS), and an understanding of relational database design, including Star-schema.
· Oracle SQL syntax.
· TOAD, SQL*Plus, Golden, SQL Server Management Studio.
· Informatica 9.x, esp. WorkFlow Manager, WorkFlow Monitor.
· Windows operating system.
· Proven analytical and problem-solving skills, along with strong written and verbal communication skills.
· Ability to interact with people from all organizational levels.
· Knowledge of PC applications, e.g., Microsoft Office Suite.
· Quickbase, LiveLink, and other content management systems as necessary.
· Ability to be flexible, versatile and adaptable both in day-to-day activities conducted in a multi-site environment.
Day to day:
· Responsible for verifying the correctness of Informatica jobs, and for tracking issues to remediation.
· Developing test plans, developing test scripts (writing SQL code)
· Work with development teams to create and executing the test plan and documenting the results.
· Logging defect tickets, working with Informatica developers and others to identify the cause of unanticipated test results
· Identifies, analyzes, and documents system defects.
· Functions as part of a broader team to remediate Enterprise Data Warehouse
· Critically evaluates information gathered from multiple sources, reconcile conflicts, and decompose high-level information into details.
· Ensures that development solutions meet defined technical, functional, and service level requirements and standards
· Provides consistent quality in work output, using Dana-Farber best practices, templates, and guidelines.
· Develops, maintains, and verifies test cases through proficient application of occasionally complicated SQL statements (select, insert, update, join, etc.).
· Participates in System testing, Regression testing, Integration testing, and Deployment validation of ETL (Informatica) packages.
· Participates in meetings, provides regular status updates, and discusses issues that must be resolved, creates and updates content in online systems (e.g. defect tracker).
· Proactively communicate and collaborate with team members to analyze information needs, and raise any blockers or concerns to project manager.
· Work with project team and management to identify and document benefits, costs and risks associated with solution alternatives, while balancing stakeholder expectations regarding project timeline, cost, and scope.
· Has responsibility for the security of medical and financial confidential information.
· Collaborate effectively as an exemplary representative of Information Systems. On-going communication, feedback and follow-through with peers are essential.
Thanks & Regards,
Ashok Kumar
Siyaton Global Solutions, Inc.
ashok@siyaton.com | ashok.siyaton@gmail.com
1590 S. Milwaukee Ave | STE # 317 | Libertyville, IL 60048
Desk: 657 214 0217 | Fax: 703 738 7887
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at http://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.
