Sign in

Informatica Etl

Malkajgiri, Telangana, India
it would be good if it is $60/hr.
April 26, 2021

Contact this candidate


Surendra M

Professional Summary

Solutions-driven Quality Assurance Analyst and Scrum Master with experience leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals. Seek opportunities to transform company practices into fresh, cost-effective solutions leading to more efficient operations. Accustomed to managing multiple projects and priorities in fast-paced environment.


Primary Skills

Project Management, Software testing life cycle, Agile Methodologies, Business Process Management, Requirements Gathering, Test Management, Defect Management

Operating systems & Technologies

Windows 98/2000/XP, NT, 2003 Server, Windows 7, Dot Net, Asp.Net


SQL Server Management Studio 2008, Oracle

Bug Reporting Tools Used

JIRA, ALM (Application Life Management), Bugzilla, TFS, Quality Center

Management Skills

Communicate proactively, Leadership, adaptable to situations, strong bondage with teams, ensures both team and self-develop to the next level, manage SDLC, ensure process compliance & Customer ecstasy.

Domain knowledge

Health Care (HL7), Banking (ISO Messages – ATM Cards, Debit Card, Credit Card) and Insurance

Testing Methodologies

Functionality & Regression Testing, Integration & Smoke Testing, System & Sanity Testing, ETL & BI Testing

Reporting & ETL Tools

Tableau, Cognos, Informatica-Power Center 8/7.1.2/5.1.1/5.0


Bachelor of Science, Computer Science, Madras University, Chennai, India. -2004


Certified Scrum Master


Kiewet Jan, 2020 –Till Date

Scrum Master


Implemented Agile Scrum Methodology throughout the organization to improve communications between Engineering, Product Management, and Business; to provide more transparency across the 3 departments; and to obtain great business value with short turnarounds.

Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings.

Removed team impediments on a daily basis to allow the team to deliver the sprint goals and deliverables.

Collaborated with members of the Product, Business and Engineering Teams to develop and maintain Product Backlogs.

Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction.

Ensure regular and effective communication with subordinate staff on performance, goals, and coaching.

Facilitates daily agent coaching and development sessions in both written and verbal format.

Participates in client related activities to include client calibration sessions and project planning.

Identify and address agent training needs.

Manage team’s time entry to ensure 0% discrepancy rate.

Manage program specific performance standards (i.e. AHT, Quality Scores, Sales, etc.).

Manage financial implications of attrition and attendance by maintaining program-specific goals.

Manage staffing in accordance with program specific workflow (i.e. down-staffing, up-staffing).

Completion of weekly Team Manager Scorecard for review with Operations Manager.

DMSi Software June, 2018 – Sep, 2019

Scrum Master

Serving as scrum master for 3 teams on internal programs

I work with product owner to produce Program Increment Objectives to be used for Program increment planning.

Worked with technical Leads on resource management.

Facilitated Scrum Ceremonies: daily stand ups, Backlog grooming, Sprint planning, demos and retrospectives.

Worked with Product owner to update backlogs.

Worked with other teams in the Safe program on dependencies and creating and managing dependency board through out every program increment.

Keeping the team focused, shielding the team from outside distractions and interferences.

Facilitating meetings between teams, creating action items and making sure all actions items are taken care of on a timely manner.

Forecast sprint iterations with the Product Owner and concerned stakeholders.

Participated in the SAFe community of practice (CoP)

Escalated impediments to upper management for assistance in solving impediments when the team was unable to solve them on a timely manner.

Communicated Jira reports (Burndown charts, Sprint reports, and version reports) to upper management and stakeholders.

Nebraska Furniture Mart Jan, 2017 – Mar, 2018

Scrum Master


Facilitated Sprint Planning, Release Planning, Daily Stand-Ups, Product Demos and Sprint Retrospectives. Removed impediments/blockers to keep teams productive

Managed burn down chart, monthly budget and reported project status to PMO and higher management

Plan and lead scrum ceremonies and facilitate Story and Task entries in JIRA

Make sure that team is following agile processes in each sprint at user story level as per the Definition of Done (DoD)

Made the winning strategy according to the ground conditions for continuous improvement on velocity, quality and processes

Cognizant Technology Solutions Jun- 2016 –Sep-2016

Client: Emblem Health, US, Scrum Master

Project Description:

ESAWS Accelerator – It is a Dashboard Screen created to optimize the search and reduce the time to address the Member Calling Emblem health care insurer regarding inquiries on the various entities.


Gathering and updating project materials, completing budgeting, forecasting, project documentation, business flows, and lessons learned documents.

Scheduling and allocating work, providing advice and guidance, and resolving problems to meet technical performance and financial objectives.

Coordinate all Scrum Ceremonies including Sprint Planning, Daily Standups, Sprint retrospectives, Sprint Demos, Story Grooming, and Release Planning.

Coaching and mentoring other Scrum Masters on our program team. Partnering to ensure that our ways of working are consistent across teams.

Assist in defining and deploying new product development processes and in facilitating the continuous improvement of existing processes.

Coaching and mentoring other Scrum Masters on our program team. Partnering to ensure that our ways of working are consistent across teams.

Liaising between developers and project stakeholders; fostering quality communication between engineering disciplines.

Skills Exercised: Agile- Scrum, MySQL database, JAD, HP Quality center (ALM), SSIS, MS Visio, MS Excel, MS Outlook, SharePoint, JIRA, Informatica, Confluence, MMIS (Medicaid Medicare Information System)

Cognizant Technology Solutions July- 2014 –Jun-2016

Client: Patient Point, US – Quality Assurance/Scrum Master

Project Description:

For more than 25 years, PatientPoint has been the leader and innovator of patient and physician engagement solutions at the point of care. From primary care to specialty practices, from urgent care clinics to hospitals, PatientPoint programs provide an integrated patient-engagement experience across care settings


Providing support/leadership in the formulation of network, technology, systems and information strategy and evolution plans.

Provide signed off complex functional end to end solution designs for use by Development and Test in line with the BT Ireland Strategy.

Act as a key contributor and provide expert advice to other groups on technical and operational issues.

Providing effective support of large projects and leadership of small/medium projects, dealing with all relevant issues, often without the guidance of the manager.

Supporting real time operational systems providing leadership and guidance on resolving complex technical issues owning operational processes and ensuring support is provided to meet service level standards.

Responsible for the design of BT Ireland’s infrastructure, systems and application software, network services and data security to internal customers.

Solving business problems and furthers business success by applying industry, applications, and technical knowledge through the definition of high-level solutions. In addition, may work proactively with the business to define new product developments.

Skills Exercised: Agile Methodology, JIRA, HL7 Standard Files creating, processing and HealthCare Functional knowledge.

Cognizant Technology Solutions Aug - 2013 – June 2014

Client: Siemens Care Management, Quality Assurance Specialist

Project Description:

Siemens Healthcare is one of the world's largest suppliers to the healthcare industry and a trendsetter in medical imaging, laboratory diagnostics, medical information technology and hearing aids. Siemens offers its customers products and solutions for the entire range of patient care.


Responsible for managing the scrum process with the coordination of the scrum team in an agile methodology.

Gathered and analyzed business requirements for the database systems.

Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.

Analyzed plan requirements and then contributed further defining the plan requirements with the Project Manager and observed the compliance of the requirements with federal and state government regulations Medicaid, Medicare, and accreditation requirements.

Analyzed "AS IS" and "TO BE" scenarios, designed new process flows and documented the business process and various business scenarios.

Translated information between business teams and technical teams using object-oriented models or other techniques.

Using the tool ALM (Application Lifecycle Management) to gather, map and trace all solutions and strategies defined towards a particular problem and use the same solution as a reference in case a similar problem arises.

Skills Exercised: Agile Methodology, ALM, TIBCO, SQL Server, HL7 & EDI Claims Standard Files creating, processing and HealthCare Functional knowledge

Cognizant Technology Solutions Oct 2012 – July 2013

Client: Branch Banking & Trust, US, Quality Assurance Specialist

Project Description:

The Association Services Phase 1 project is to develop Web Plus application. It consists of various modules which include Management, Association, System Administration, Bank Region Information, Services and User Role Management Set up.


Preparation of the following various technical and functional documents (where applicable depending on the request types) Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, Detailed Design Document, System test plan and test procedure document, implementation plans and Knowledge transition documents after the implementation.

Responsible for developing, implementing, and maintaining test plans, procedures, guidelines, standards and processes on the project and document test results in a test report.

Oversee development testing aspects (unit, integration, system, and acceptance) ensuring testing is coordinated, executed, and reported.

Supported the development team with problem diagnosis and resolution, as well as determined appropriate test methods for specific product fixes and updates.

Perform Back end validation on New DB for the changes done in New WebPlus Application.

Complete Data Migration from New DB to Old DB, test the new WebPlus application for migrated data.

Supported the extraction, transformation, and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and Involved in ETL process testing using Informatica ETL tool.

Test the current ecosystem (With PLUS application and surrounding components) and validate that the ecosystem remains intact for changes done in the new application.

Skills Exercised: Windows, HL7, Microsoft Office SharePoint, Agile, Rational Requisite Pro, MS Office, SQL Server, GEM, DB2, MS Project, MS FrontPage, and MS Access.

Cognizant Technology Solutions Jan 2010 – Sep 2012

Client: Funds Express (Firstdata Corporation), Business Analyst

Project Description: Customizing the application for online banking for Funds Express Clients.


Responsible for Initial Study and Understanding of the Functional Specs.

Supported the extraction, transformation, and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.

Involved in ETL process testing using Informatica ETL tool.

Providing inputs to Design team based on UAT defects analysis.

Coordination with team on daily basis for all deliverables.

Client Interaction and provide QA support for the application.

Interacting with the Onsite Coordinator for clarifications for the raised queries

Responsible for doing Functional & Regression Testing

Planning for Test Execution activities to accomplish tasks on daily/weekly basis.

Skills Exercised: User Acceptance Testing (UAT), Rational Clear Quest, Joint Application Development (JAD), MS Access, Windows, Rational Test Manager, MS Office, Requirement Traceability Matrix (RTM).

Synaptree May 2004 – Dec 2009


Creating and developing user stories based on business and systems requirements, as well as defining and elaborating user stories with validation and acceptance criteria.

Gathered and analyzed business requirements for various projects by collaborating directly with the department to access impact and provide alternate solutions when necessary.

Effectively collaborated across all teams and communicating results of multiple software releases.

Creating new business rules and process flows for proposed system enhancements.

Assist in providing verification support during monthly production releases.

Create test scenarios and analyze program results to ensure requirements are met.

Ensure that technology solutions meet global business requirements, goals, and best practices.

Skills Exercised: Agile Methodology, SharePoint, Microsoft Office, Excel, Database, HTML, PowerPoint, SQL, Gap Analysis, Testing, User Acceptance.

Contact this candidate