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
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
Similar Profiles
Swathika V VSwathika V V
Senior Analyst I Data Engineering at DXC Technology ( EIT Services India Pvt., Ltd., formerly known as HP Global Soft Pvt., Ltd, ChennaiSenior Analyst I Data Engineering at DXC Technology ( EIT Services India Pvt., Ltd., formerly known as HP Global Soft Pvt., Ltd, Chennai
Sanjeev ReddySanjeev Reddy
Senior Consultant at Capgemini India Pvt ltd (Client Airbus Group India pvt ltd)Senior Consultant at Capgemini India Pvt ltd (Client Airbus Group India pvt ltd)
MADHUSUDHAN NBMADHUSUDHAN NB
Business Operations Specialist at HP India sales Pvt LtdBusiness Operations Specialist at HP India sales Pvt Ltd
Neha KumbhareNeha Kumbhare
Business Analyst at Harbinger SystemsBusiness Analyst at Harbinger Systems
Lucy ChatterjeeLucy Chatterjee
Customer Retention Manager at Netcore CloudCustomer Retention Manager at Netcore Cloud