Sr. Analyst – ETL Testing - Deloitte Support Services India Private Limited
USI DT Canada MF is an integral part of the Information Technology Services group. The principle focus of this organization is the development and maintenance of technology solutions that e-enable the delivery of Function and Marketplace Services and Management Information Systems.
Solutions Delivery group develops and maintains solutions built on varied technologies like Siebel, PeopleSoft Microsoft technologies, SAP, Hadoop, ETL, BI and Lotus Notes. Solutions Delivery Canada has various groups which provide the best of the breed solutions to the clients by following a streamlined system development methodology. Solutions Delivery comprises of groups like Usability, Application Architecture, Development and Quality Assurance and Performance.
Role Specific Responsibilities / Work you’ll do
• Responsible for planning, developing, and coordinating testing activities including
· Test Plan creation, Test Case creation, debugging, execution, test analysis.
• Responsible for the execution of test scenarios in support of the test team.
• Familiarize themselves with the business functionality and technology used for assigned applications (under test).
• Utilize ETL QA testing tools, methodologies, and processes.
• Work closely with on-site team towards successful test phases.
• Encourage collaborative efforts and camaraderie with other Release Stream team areas.
• Ensure the quality and low bug rates of code released into production.
• Responsible for successful execution and alerting team leads and managers of obstacles, issues, and risks.
• Able discuss status of all open issues facing the test team and describes actions taken to mitigate such issues
• Responsible for coordinating/engaging build movements to the QA environment as directed by Team Lead.
The team
EDC Canada is the Canada CIO’s IT department which manages an end-to-end portfolio of Canada business applications and technology infrastructure that supports business processes common to Deloitte Canada member firm.
Cutting Edge Technologies: At USI DT Canada MF, you will be part of an exciting journey that will keep you ahead of the curve. Be it our innovative delivery model for agile or our Communities of Practices, we are constantly investing in leading edge technologies to give our practitioners a world class experience. We have programs and projects spanning across a multitude of technologies and always abreast on evolving technologies and emerging industry leading practices such as agile.
Application Development and Solutions Delivery: Start from Architecture and User Experience and evolve into design, develop, transform, re-platform, or custom-build systems in complex business scenarios. We manage a portfolio of enterprise scale applications and solutions used by practitioners in Canada. Offerings include Custom Development, Packaged Application Development, Application Architecture and Testing Advisory Services. Technologies include Business Analytics, Business intelligence, Cloud Development, Mobile, .Net, SharePoint, SAP HANA, Manual, Automated, and Performance testing.
Location: Hyderabad
Work shift Timings: 11 AM to 8 PM
Qualifications
Essential
- A Computer Science University degree and/or equivalent work experience
- A strong commitment to professional client service excellence
- Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
- Good verbal and written communications skills
- Excellent Analytical Skill
Top 3 Keywords: SQL databases, Test Strategy, API’s testing
Technical Skills and Qualifications
- 4 to 5 years' experience in ETL testing.
- Demonstrates an understanding and working experience on SQL databases and ETL testing. Should be able to write queries to validate the table mappings and structures
- Should be able to perform schema validations
- Good understanding of SCD types
- Strong knowledge of database methodology
- In-depth understanding of Data Warehousing/Business intelligence concepts
- Working experience in testing BI reports
- Should be able to write queries to validate the data quality during migration projects
- Demonstrates an understanding of any of the peripheral technologies utilized in SDC, including Peoplesoft, SAP and Aderant.
- Demonstrates a working understanding of tools like UFT and TFS
- Experience with Microsoft tools is highly desired
- Understands enterprise-wide networks and software implementations.
- Must have previous experience in creating complex SQL queries for data validation.
- Must have testing experience in Enterprise Data Warehouse (EDW)
· Good to have Reports testing experience
· Good to have working knowledge on Azure, DB2, HANA, SQL databases.
· Demonstrates a working understanding of planning, developing, and coordinating testing activities including Test Plan creation, Test Case creation, debugging, execution, test analysis.
- Demonstarte an understanding on the estimation techaniques and QA plan
- Demonstrates analytical skills in assessing user, functional and technical requirements
- Demonstrates a working understanding of functional testing techniques and strategies.
- Demonstrates a working understanding of test analysis and design.
- Demonstrates a working understanding of analyzing test results and the creation of appropriate test metrics.
- Demonstrates a working understanding of the defect management process.
- Demonstrates an ability to provide accurate project estimates and timelines.
- Demonstrates an ability to deliver on project commitments.
- Produces work that consistently meets quality standards.
- Demonstrates the ability to operate as the primary resource on a project