-Working experience in test planning, test case designing and test execution for Pharma, Life science Healthcare Data (Database Testing/ETL Testing/DWH) projects
-Experience in Data Warehouse, Database, ETL & BI testing
-Should have functional knowledge on data quality, DWH verification and validation procedures
-Thorough out the project in various iterations/Sprints conducted system testing, integration testing, functional testing and integration testing.
-Developed complex SQL queries for querying data against different data bases for data verification process.
-Prepared the Test Plan and Testing Strategies for Data Warehousing Application
-Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
-Translate system requirements into test scenarios and scripts Write test cases/scripts, and coordinate reviews/approvals of those test scripts. Execute test scripts. Define and track quality issues/defects
-Extensively used and developed SQL scripts/queries in backend testing of Databases.
-Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
-Extracted data from various sources like Oracle, flat files and DB2 server.
-Worked on issues with migration of Data from development to QA-Test Environment
-Extensively tested several Business Objects Reports, (Dashboards) to validate the reports the data and cosmetics of the report.
-Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases
-Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
-Creating test cases for ETL mappings and design documents for production support
-Knowledge of Software testing processes and automated tools, with an ability to apply software testing methods and techniques in a DW / BI environment.
-Knowledge of relational and dimensional data models
-Knowledge of tools like Informatica, Oracle, MicroStrategy is preferred
-Experience in working with the project/customer team and co-coordinate onsite and offshore team model
-Should have hands on experience in Regression, Integration, Functional & Non-Functional testing
-Proven ability to handle multiple projects while meeting deadlines and documenting progress towards those deadlines.
-Excellent communication skills (must be able to interface with both technical and business leaders in the organization)
-Ability to be a self-starter and can provide leadership
-Strong customer focus, excellent problem solving and analytical skills
-Bachelor's degree in computer science.
-Experience working on Pharma/Life Sciences projects will be a plus
-A minimum of 3+ years of relevant experience in Pharma Domain.
Axtria (www.axtria.com) is an advanced analytics and business information management company based out of New Jersey. We have offices at Richmond VA, Atlanta GA, Scottsdale AZ and India. Our broad portfolio of services and solutions help our clients improve their sales, marketing and distribution strategies and operations. We blend analytics, technology and consulting to help customers gain deep insights from their customer data, create strategic advantage and drive profitable growth.
Our global team is committed to delivering high quality, high-impact solutions for our clients and to building a world-class firm with enduring value. Our unique team combines real-world business knowledge, a depth of analytical skill and experience with the latest technologies. Those who excel at Axtria share a number of common qualities. They are smart and have the analytical toolkit to put their intelligence to work. They are passionate about data and analytics.
They seek to constantly learn recognizing this drives career development, client value and firm growth. They are entrepreneurial, energized by the idea of creating something new.