*Hi* *I have an urgent requirement with one of my clients, details given below. If you find yourself suitable for the position, please *
* send me your latest updated resume along with contact details. Please include your employer details as well and reply to my official id [email protected] <[email protected]> JOB TITLE: ETL Tester Location: NY/Nyc Duration: 6 Months M.O.I ** Telephonic + Face2Face* *Candidates MUST come from healthcare and have experience with Datastage* *Role Description:* The BI/ETL/Data warehouse Tester would need to have a minimum of 5-7 years of professional work experience within the IT field and a minimum of 5 years of experience in BI projects. This candidate will create, review and execute test cases that ensure data extraction, transformation, and migration according to requirements and technical specifications. 1) Verify that data is transformed correctly according to various business requirements and rules. 2) Make sure that all projected data is loaded into the data warehouse per requirements. 3) Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data. *Responsibilities include: * · Collaborate with developers, quality assurance analysts, and other stakeholders on software projects · Analyze requirements and create test cases, and test data. · Develop tests strategies, test scenarios, and tests to be executed against the database and data using SQL and other tools. Requires expert knowledge of SQL against source and target data models with a thorough understanding of complex atomic models. · Ensure the data is extracted correctly, delivered to its destination, and correctly uploaded. · Identify, analyze, and document defects or other anomalies discovered in the data. · Developing scalable and reusable processes and automation frameworks for analyzing data and delivering ongoing quality metrics (leveraging *SQL, PL SQL, UNIX,* and other tools). · Maintaining test environments to include testing tools and automation products · Review test documentation with rest of the team. · In addition to ETL testing, data validation testing and testing of Cognos reporting applications, including Framework Manager validation. *Required Skills: Candidates MUST come from healthcare and have experience with Datastage* · Candidate must possess at least 5 years of experience in Conducting Data Warehouse/ETL/BI Testing with preferably working knowledge of Datastage tool. Must know Unix commands. · Strong SQL skills and should be able to write SQL to compare and reconcile source and target databases. · Expertise in development of Test Scripts for Extract-Transform-Load (ETL) Routines in the data warehousing environment. · Experience with Test Automation and Performance Tools. · Understand Business/Functional Requirement to Develop, Validate, and Implement Test Plans and Test Cases · Experience in defect tracking and management using defect tracking tools · Strong knowledge of system testing best practices and methodologies · Strong data analysis, data verification, and problem-solving abilities · Bachelor’s degree in software engineering, computer science, business administration or equivalent work experience. *Desired Skills:* Cognos IBM domain database Healthcare domain Thanks & Regards, *Amit Sharma* *Technical Resource Specialist* *RG Talent Inc* *39120 Argonaut way* * Suite # 157, Fremont CA 94538* Phone : 510-443-0758 Ext 115 Email : [email protected] URL : www.rgtalent.com In my absence please contact *Javed *at following address [email protected] <[email protected]> *Disclaimer: Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail at [email protected] <[email protected]> and we will gladly REMOVE you from our mailing list.* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups. For more options, visit https://groups.google.com/d/optout.
