ETL Test Specialist

IntroductionAs a Test Specialist at IBM, your analytical and technical skills will directly impact the quality of the software we create. Come work in an agile environment where you will help each iteration reach the next level. Whether the testing is manual, automated, or cognitive, you hold a key role in releasing the best deliverables to IBM'ers and our clients.Your Role and ResponsibilitiesThe ETL Test Specialist should have 3-5 years of hands-on experience in performing data analysis and data profiling. You should also have hands on experience in working with at least one of the ETL tools like informatica, QuerySurge, DataStage. You should be able to work closely with a team of technical and non-technical staff and consultants to garner feedback on testing deliverables and provide feedback for other team member deliverables. Participate and contribute to planning sessions by providing testing estimates, report status to management on a regular basis. Overall, you should have strong experience in Test Data management, Test Strategy, Test Planning, Execution, Defect Management, and reporting process for ETL Testing.Candidates must have the ability to work in the United States without a current or future need for visa sponsorship.Successful candidates for these positions will work on-site at the IBM Client Innovation Center in Baton Rouge. The IBM Client Innovation Center is an in-bound delivery model where we support our clients from our Baton Rouge center. However, some travel is expected, and all candidates must be willing and able to travel to meet our client needs across the US. Travel is typically related to knowledge transfer and training at the client site (Monday thru Friday). You are expected to travel up to 50% of the time. This is a traditional office position. You must live in, or be willing to relocate to, Louisiana within 30 days of the center permanently reopening. The work location is 100 North Street Baton Rouge, LA 70802. This is not a work from home position.sprgg21Required Technical and Professional Expertise+ At least 3 years experience in ETL Testing ( example Abinitio, Informatica or DataStage).+ Good knowledge of the ETL tools and processes and understand differences between functional testing vs regression testing.+ Write test data scripts, based on ETL mapping artifacts.+ Document and write Test scenarios for an ETL process (for an ETL process that loads data from files to MySQL/Nettezza/DB2 databases and vise versa).+ Execute data scripts and detailed analysis on the scripts.+ Create strategies and test cases for applications that use ETL components+ Understand the Source to Target Mapping documentation.+ Perform ETL Test validations and Quality checks+ Knowledge on basic Database objects and relational data model.+ Experienced using SQL queries; Writing basic SQLs to validate record counts, data truncation, invalid datatypes, NULLs, transformation logics and data integrity.Preferred Technical and Professional Expertise+ Experience with Abinito or Informatica job execution using CA7 and / or ESP.+ Knowledge on automation tool like Ignite, Query Surge or OptimAbout Business UnitIBM Services is a team of business, strategy and technology consultants that design, build, and run foundational systems and services that is the backbone of the world's economy. IBM Services partners with the world's leading companies in over 170 countries to build smarter businesses by reimagining and reinventing through technology, with its outcome-focused methodologies, industry-leading portfolio and world class research and operations expertise leading to results-driven innovation and enduring excellence.Your Life @ IBMWhat matters to you when you're looking for your next career challenge?Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities - where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust - where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.Impact. Inclusion. Infinite Experiences. Do your best work ever.About IBMIBM's greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.Location StatementIBM will not be providing visa sponsorship for this position now or in the future. Therefore, in order to be considered for this position, you must have the ability to work without a need for current or future visa sponsorship.IBM intends this job to be performed entirely outside of Colorado.Being You @ IBMIBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.