Second Menu

Wednesday, October 1, 2014

ETL Tester /Quality Assurance Analyst/Engineer | MA |

 

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

Nitesh@apetan.com

http://www.apetan.com

--
You 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