*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.* *[email protected] <[email protected]> | [email protected] <[email protected]>* 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 "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
