Srushti Temkar
Senior ETL Developer & Tester
Mumbai
Summary
Well-coordinated Test Lead driven to improve procedures and team effectiveness. Adept at evaluating products for design compliance, sustainability and user-friendliness. Highly productive and resourceful leader bringing 7 years of ETL and MDM Testing experience. Top-notch critical thinking, organizational and problem-solving abilities. Organized, meticulous and diligent professional ready to leverage experience and skills to take on new role with room for growth and advancement.
Overview
7
7
years of professional experience
2
2
Languages
Work History
Lead QA Analyst/ETL Tester, SSIS Developer
Capgemini India Pvt. Ltd, HP Inc
08.2020 - Current
- Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
- Environment: IBM DB2, Microsoft SQL Server, Informatica 10.0, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Azure DevOps Board, HP QC 9.0/11.0, SOAP UI, Unix
- Responsibilities:
- Proficient in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Analysis Services and SQL Server Integration Services
- Experience in maintaining one to many and many to one relationships while moving data between two databases
- Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications
- Expertise in writing Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, Views
- Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging
- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
- Experience in importing/exporting data between different sources like Oracle/Excel etc
- Using SSIS/DTS utility
- Experience in ETL processes involving migrations and in sync processes between two databases
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
- Developed test cases to accomplish ETL data migration
- Involved in Unit testing and integration testing of Informatica and SSIS mappings
- Ensured Error logs and audit tables are generated and populated properly
- Prepared the guides for UAT & Production readiness for entire ETL testing efforts
- Led team of 6 people offshore
- Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
- Ability to handle Multiple tasks, Initiative and Adaptable
- Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals
- Good ability to quickly grasp and master new concepts and technologies
Lead QA Analyst/ETL/SQL Tester
Capgemini India Pvt. Ltd, Daimler South East Asia
01.2019 - Current
- Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
- Environment: IBM DB2, IBM Data Stage, HP QC 9.0/11.0, SQL developer, SQL and PL/SQL, SOAP UI, Unix
- Responsibilities:
- Led efficient, competent team of 8 test engineers integrated into all aspects of software lifecycle, resulting in significant improvement in quality of software deliverables
- Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
- Key contributor in leading the project, having a complex landscape of integrating 8 source systems and 20 Interfaces, to be delivered in a span of 3 months
- Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability
- Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
- Performed data quality analysis using advanced SQL skills
- Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration
- Extensive SQL querying on Staging, Data warehouse and DataMart
- Ensured Error logs and audit tables are generated and populated properly
- Performed UAT and Regression Testing
- Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
- Tracking and reporting the issues to project team and management during test cycles
- Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications
- Contribute in the development of knowledge transfer documentation
- Attended client facing activities - Business go-live support at Singapore
- Also attended Business User Acceptance Testing at UAE and representing Capgemini
Sr. ETL Tester
Capgemini India Pvt. Ltd, Daimler
06.2017 - 12.2018
- IBM DB2, IBM Data Stage, HP QC 9.0/11.0, SQL developer, SQL and PL/SQL, SOAP UI, Unix
- Responsibilities:
- Directed onsite training for business users to maximize productivity
- Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data
- Worked with IT Development team to ensure feasibility of design and clarify user requirements
- Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle
- Consistently met deadlines and requirements for all production deliverable
- Reproduced defects and documented findings
- Trained junior testers in company standards and testing protocols
- Completed regression tests of new software builds to assess performance and the success of bug fixes
- Perform test execution for all aspects of the product/system like function/component, system performance, regression and service
- Provided feedback on usability and serviceability, trace the result to quality risk and report it to concerned people
ETL tester /Data Analyst
iGATE Global Solutions Ltd, GE Capital Treasury, GE Healthcare
06.2015 - 06.2017
- Environment: Oracle 10g, Informatica Power Center, Business Objects, Spotfire, Tableau, Windows/2000 and UNIX, SOAP UI, Unix
- Responsibilities:
- Work closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements
- Developed and executed comprehensive test plans and workforce breakdown structures for complete systems
- Engaged internal and external customers during the planning and test phases and interfaced with assigned project managers to ensure compliance with entry criteria
- Reviewed, evaluated and identified requirements for test-ability
- Created comprehensive test plans, test scripts, and use cases to support testing objectives
- Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse
- Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements
- Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process
- Ability to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.
Education
B.E -
Atharva College of Engineering Mumbai University
H.S.C - undefined
Ramnivas Ruia College Maharashtra Board
S.S.C - undefined
St. Paul’s Convent High School Maharashtra Board
Skills
Requirements analysis
Project lifecycle management
Agile framework
Decision-Making
Multitasking Abilities
Problem-Solving
Attention to Detail
Organization and Time Management
Excellent Communication
Timeline
Lead QA Analyst/ETL Tester, SSIS Developer
Capgemini India Pvt. Ltd, HP Inc
08.2020 - Current
Lead QA Analyst/ETL/SQL Tester
Capgemini India Pvt. Ltd, Daimler South East Asia
01.2019 - Current
Sr. ETL Tester
Capgemini India Pvt. Ltd, Daimler
06.2017 - 12.2018
ETL tester /Data Analyst
iGATE Global Solutions Ltd, GE Capital Treasury, GE Healthcare
06.2015 - 06.2017
B.E -
Atharva College of Engineering Mumbai University
H.S.C - undefined
Ramnivas Ruia College Maharashtra Board
S.S.C - undefined
St. Paul’s Convent High School Maharashtra Board