ONLY ACCEPTING LOCAL CANDIDATES!! F2F
Title: ETL Tester /Quality Assurance Analyst/Engineer
Location: Boston, MA
Team: Analytics/Data Warehousing
Duration: 6 months
Interview Process: phone then on site
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.
Best Regards
Nitesh Yadav
Technical Recruiter
P-201-285-8031 * 118 | F- 201-526-6869
APETAN CONSULTING LLC
72 Van Reipen Avenue # 255
Jersey City, NJ 07306
http://www.apetan.comYou received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment