Company Name: Sears Import - OLD
Job Details
Duration: Permanent
Min Education: Not Specified
Salary: Commensurate
Job Type: Full Time
Min Experience: Not Specified
Required Travel:
  • USA - Chicago Illinois, 60601
Job Description
• Come up with test plans that translates the client’s business requirements into specific systems, applications or process designs for very large complex IT solutions and integrating architecture
• Serves as an advocate for the client as the ultimate authority on the test framework designed to address client business problems, and provides direction for design activities
• Maintains a forward looking perspective on emerging technology test driven developments
• Develop, document and maintain functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts.
• Conduct meetings and correspond with source systems’ to ascertain technical requirements and finalize data model & ETL flow design from test perspective for both manual and automation
• Evaluates query plans to improve performance
• Create, Execute and evaluate manual or automated test cases and report test results.
• Breaks up existing stored procedures to create a multi-tiered architecture, including a robust data access layer
• Creates and maintains logical and physical data models that apts ongoing test needs of client data limitations
• Reviews data models and database design documents produced by the members of other application teams and recommend correct test plans from functional and performance test perspective
• Implement test plans that can validate test data from small to extremely large scale data volumes at systems on a rage of different RDBMS, including DB2
• Works closely with Development engineering, Performance, Data Abstraction, & Distribution teams
• Follows all formal test architectures and project processes, ensuring that formal project and development/test gates are successfully passed by providing the necessary technical artifacts and provide assertive test exit criteria
• Documents workflows and results of business analysis and obtains sign-off from client on the specifications
• Creates audit scripts for testing data validations
• Conducts System & Integration Testing and writes technical test cases, and develops test plans for modules to test all required functionality and possible failure causes
• Isolate, replicate, report defects, verify defect fixes and own root-cause analysis for every defect.
• Leads offshore test teams
• Writes/reviews test cases for Unit testing
• Supports code promotion to different environments
• Collaborates with the development team and business partners to ensure successful delivery and implementation of application solutions
• Coordinates activities with the Enterprise Architecture group to establish test governance, patterns, and anti-patterns for Data Abstraction & Distribution
• Reviews functional requirements and uses cases to determine the relevant data requirements
• Assists in creating realistic project plans and ensuring their timely execution
• Oversees multiple projects simultaneously and meeting strict deadlines for each
• Establish performance benchmarks to test against each software release.
• Setup & maintain test environments and own road-map for assigned projects
• 5+ years of relevant QA technical experience.
• Expertise in database testing in including designing and manipulating test data, validating stored procs, batch jobs, triggers and replication.
• Knowledge of ETL tool inner workings, appropriate design techniques to support restartability, and high volume data load techniques
• Deep understanding of the ETL Development Process and delivering data movements to the production environment
• Experience in monitoring and tuning the general performance of ETL jobs
• Experience in UNIX (Solaris/Linux/AIX) environment
• Experience providing technical design review, development plan critique, code review, test plan/results review
• Strong understanding of relational database concepts, data modeling (dimensional/snowflake), SQL, query optimization
• Data modeling experience, creating both logical and physical designs
• Experience discovering patters in data models to enable the alignment of similar data
• Experience writing complex and efficient queries for ad-hoc reporting needs
• Experience in identifying business rules and creating database designs and documents
• Thorough knowledge of dimensional and relational data modeling concepts
• Experience with XML schemas and usage
• Experience with SVN or other version control frameworks
• Experience operating within strict processes and controls for live production environments
• Experience with data quality/profiling methodologies/tools
• Strong experience in infrastructure design and capacity planning
• Strong knowledge and hands-on experience with IBM Data Stage and other major data movement tools (Talend), including performance monitoring and error-handling
• Experience in Perl experience
• Experience in working with offshore teams and resources
• Comprehensive knowledge and understanding of data warehousing concepts, including architecture, integration methodologies, and metadata management practices.

Tools/Technologies/Skills (2 years experience):
• Mercury/HP tools – Quality Center, Quick Test Pro, Winrunner, Load runner
• DB: IBM DB2, MY SQL, SQL Server
• IBM Tools: Datastage; or Talend
• Rational tools: Clear quest, Clear case
• Open source: JIRA, J-UNIT, SVN, Selenium
• Extremely Proficient in SQL, UNIX
• Testing types: Manual/Automation/UAT/Adhoc/eCommerce/Webservices/APIs

Role specific abilities/skills:
• Passion for technology
• Strong understanding of web technologies including HTML, XML, JavaScript, CSS, HTTP, FTP, JSP and Tomcat
• Ability to follow approved testing methodology and be hands-on tester
• Experience with database systems and SQL programming
• Demonstrate a sense of urgency to communicate issues impacting code release
• Strong oral and written communication skills
• Ability to work in a team environment
• Ability to work in a fast paced exciting environment
• Exp in testing web services
• Programming exp with Java or an OO programming language is a must
• Exp in automating web services (using SOAPUI , or API automation)
• Exposure to testing using JUNIT
• Great analytical and troubleshooting skills