Diptarup Sinha
ETL Testing | Spark SQL | Agile
- Role
- Assistant Consultant at Tata Consultancy Services
- Location
- Kolkata, WB, IN
- LinkedIn followers
- 500 followers
About Diptarup Sinha
Skilled in Data Analysis, Data Visualization, Dashboards and Reporting, MS EXCEL 2019…
Experience
Assistant Consultant
Aug 2022 — Present · Rajarhat, IN
ETL Tester 1. Project: Order Tech Data Management | Client: Comcast | Jan 2024 – PresentPerform end-to-end validation of ETL pipelines moving data from Query Fabric S3 to Oracle DB.Participate in Agile ceremonies; contribute to planning and retrospectives.Develop and execute test cases aligned with business/technical specs.Validate Tableau and ThoughtSpot reports for data accuracy and performance.Monitor/trigger ETL jobs via Rundeck; investigate job failures with developers.Provide L2 production support, including root cause analysis and incident resolution.Ensure build integrity and pipeline deployment validation via Jenkins and Concourse.Use Databricks for test data preparation, profiling, and validation tasks.Log/report defects and coordinate with QA/development for timely closure.2. Project: Reporting D | Client: S&P Global | Aug 2022 – Dec 2023Participated in Agile Scrum ceremonies: sprint planning, daily stand-ups, retrospectives, and reviews using Azure DevOps.Performed data validation from Salesforce CPQ to Oracle via Salesforce Workbench, ensuring cross-system data accuracy.Validated ETL pipelines in Informatica IICS for transformation logic and load integrity.Conducted post-OS patch validation for ODI jobs to ensure ETL workflow stability.Executed manual validation of Tableau reports to ensure accuracy of visual metrics post-ETL jobs.Logged, tracked, and collaborated on defect resolution using Azure DevOps.Technical Skills & Core CompetenciesETL Tools: Informatica IICS, Databricks, RundeckDatabases: Oracle, Query FabricReporting: Tableau, ThoughtSpotCI/CD: Jenkins, ConcourseMethodologies: Agile (Scrum), SDLCLanguages: SQL (data validation, comparison)Other: JIRA, Azure DevOps, Test Case Documentation, Production Support
Education
Bharatiya Vidya Bhavan's
A.I.S.S.C.E. Class XII. C.B.S.E, Computer Science
1990 — 2004
Calcutta University, Kolkata
Bachelor of Science (BSc)Hons. Computer Science, Computer Science
2004 — 2008
Narula Institute Of Technology
Master of Computer Applications (M.C.A.)
2008 — 2011
Skills
- C
- Html
- E-Commerce SEO
- Visual Studio
- Asp.net
- C# 4.0
- Microsoft Sql Server
- Search Engine Optimization (SEO)
- Sql Server Management Studio
- C++
- SEO
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.