ETL Tester

Cognizant Technology Solutions Cambridge , MA 02138

Posted 4 weeks ago

Project Manager


Bachelors in science , engineering or equivalent


Project Planning and Setup:

  • Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Module Lead for review.

  • Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc.

  • Review plan and provide feedback on gaps, timeline and execution feasibility etc as required in the project.

  • Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements.

Requirement Understanding and Analysis:

  • Analyze functional/non functional requirements and seek clarifications for better understanding of requirements.

  • Based on understanding of system upstream & downstream, provide feedback and inputs on gaps in requirements and technical feasibility of requirements.


  • Prepare the LLD/ detailed design documents based on HLD and briefing from Module Lead.

  • Seek inputs from the developers on specific modules as applicable.

  • Consolidate all modules and provide to Module Lead/ Architects/ Designers for review.

  • Suggest changes in design on technical grounds.

  • Develop components inventory for the code to be developed tying it to the nonfunctional requirements.

  • Perform sampling of data to understand the character/ quality of the data (project dependent in the absence of data analyst or designer).

  • Identify tools and technologies to be used in the project as well as reusable objects that could be customized for the project.


  • Follow coding standards and best practices to develop code and check code quality.

  • Share developed code with supervisor for review.

  • Rework on the code based on inputs if required.

  • Perform complex integration.

  • Guide the developers in identifying, preparing and conducting unit test cases and fixing defects based on results.

  • Consolidate the test results and share with supervisor.

  • Provide periodic status update to supervisor and highlight / recommend any changes in design based on challenges faced.

  • Anticipate unreported defects and raise the same to supervisor.

  • Conduct technical troubleshooting.

  • Conduct reviews for codes created by team.

Testing Management:

  • Develop unit test case for each module.

  • Conduct/ guide conducting of unit and integration testing and fix defects.

  • Review/ approve code to be moved to testing environment.

  • Provide support to the QA team and coordinate for various phases of testing.

  • Address queries raised by QA within defined timelines.

  • Investigate critical defects and establish need for fixing.

  • Raise issues to leads/QA.

  • Report defect status as per project standard process within agreed timelines.

  • Share revised code with supervisor for review.

  • Assist team lead and project manager on estimates around defect fixes.

Configuration Management:

  • Maintain versions of the code or consolidate version maintained by the Developers.

  • Provide support as required to the Administrators during configuration, code backups, deployment etc.


  • Assess and create deployment/ roll back plan.

  • Validate if all the components have been migrated and the right version is checked in.

  • Maintain deployment tracker.

  • Perform sanity checks post deployment to ensure smooth production.

  • Share activity status with supervisor and highlight concerns if any.

Project Execution Monitoring & closure (Support to Project Management activities):

  • Monitor work of the developers and share work achieved with them.

  • Provide guidance through SDLC.

  • Provide status of progress to leads.

  • In case of change requests, provide inputs on the plan.

Service Support and Maintenance:

Specific to production and maintenance support:

  • Provide support for 1 week and hand over to production team.

  • Identify if the incoming request is a service request/ defect during the warranty or an incident.

  • If it is code defect in the warranty, highlight to Lead and initiate defect fix process.

  • Post warranty, support in transition to maintenance team.

Knowledge Management:

  • Post release participate in project review call and discuss points on what went well and what didn't.

  • Create and update knowledge articles (case studies, lessons learnt) in the knowledge management repository.

  • Guide developers in creating such documents.

  • Publish white papers/ blogs/ articles (if required).

People Management:

  • Conduct training through academy or internally within the team.

  • Conduct technical, face to face interviews for internal transfer or external hiring.

  • Provide feedback on Developers form technical /domain standpoint to the module lead.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Application Engineer Sharepoint


Posted 4 days ago

VIEW JOBS 4/20/2019 12:00:00 AM 2019-07-19T00:00 A career in our Tax Reporting and Strategy practice, within Innovation services, will provide you with the opportunity to help our clients' tax departments redesign, redefine, and redeploy tax to be a strategic asset across the enterprise. You'll focus on assisting clients incorporate increased automation in the tax reporting process, increase analytic capabilities through data integration, and create solid internal controls that will enable the Tax function to deliver better quality output and contribute more strategically to organisational decision making. Our team helps our clients expand the tax role to include research, analytics, and technologies to improve how their organisation collaborates and performs. You'll focus on enhancing the tax reporting process by incorporating increased automation, integrating quality data, developing analytic capabilities, and utilising technology to deliver better quality output in less time. Responsibilities As a Manager, you'll work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution. Specific responsibilities include but are not limited to: * Proactively assist in the management of a portfolio of clients, while reporting to Senior Managers and above * Be involved in the financial management of clients * Be actively involved in business development activities to help identify and research opportunities on new/existing clients * Contribute to the development of your own and team's technical acumen * Develop strategies to solve complex technical challenges * Assist in the management and delivering of large projects * Train, coach, and supervise staff * Keep up to date with local and national business and economic issues * Continue to develop internal relationships and your PwC brand Basic Qualifications: Minimum Degree Required: Bachelor Degree Minimum Years of Experience: 4 year(s) Preferred Qualifications: Preferred Fields of Study: Computer Systems Analysis, Computer Systems Analysis & Accounting, Management Information Systems, Management Information Systems & Accounting, Systems Engineering, Computer Engineering, Computer Engineering & Accounting, Computer Management, Computer Programming, Computer and Information Science, Computer and Information Science & Accounting, Computer Applications Preferred Knowledge/Skills: Demonstrates extensive abilities and/or a proven record of success in contributing to projects that span both client implementation and product teams, emphasizing the development life-cycle of our various technology solutions, leveraging Agile methodology which includes the following: * SharePoint on premise / SharePoint Online; * O365 Tools such as Outlook, Teams, Yammer, PowerApps, and Flow; * Use of ETL tools such as Alteryx and/or Power Query; * Automation of tasks through scripting tools, similar to PowerShell; * Database design within SQL; * Use of reporting tools such as PowerBI, Tableu; * Familiar with Machine Learning concepts/tools; and, * Production of deliverables in a high pressure, time sensitive environment, being available on-call for issue escalation. Demonstrates extensive abilities and/or a proven record of success as a technical member of a client implementation or product teams producing results involving, designing and implementing system integration approaches using Microsoft technologies, which includes continuous delivery of the following: * Gathering business requirements and creation of domain-specific reports utilizing Microsoft or other 3rd party reporting solutions; * Designing a full technical solution architecture (system planning or software development); and, * Understanding systems development using .NET or open source technologies and frameworks. Demonstrates extensive abilities and/or a proven record of success as a tax technical business advisor, including developing new relationships, making introductions to sell new services and doing so with a "One Firm" service mindset. Demonstrates extensive abilities and/or a proven record of success with automation & digitization in a professional services environment including but not limited to: * Innovating through new and existing technologies, along with experimenting with digitization solutions; * Working with large, complex data sets to build models and leverage data visualization tools to provide insights to clients; and, * Utilizing digitization tools to reduce hours and optimize engagements. All qualified applicants will receive consideration for employment at PwC without regard to race; creed; color; religion; national origin; sex; age; disability; sexual orientation; gender identity or expression; genetic predisposition or carrier status; veteran, marital, or citizenship status; or any other status protected by law. PwC is proud to be an affirmative action and equal opportunity employer. For positions based in San Francisco, consideration of qualified candidates with arrest and conviction records will be in a manner consistent with the San Francisco Fair Chance Ordinance. Pwc Cambridge MA

ETL Tester

Cognizant Technology Solutions