Experience Summary Tirtha is a Senior ETL / Datawarehouse developer. He has 7+ years of experience in providing datawarehousing solutions including but not limited to development, administration, testing, client co-ordination and production deployment spanning different domain and technologies. • Worked in process oriented environments (SCRUM / AGILE) and also worked in onshore/offshore model. • Valuable experience of working as a team lead. He has experience in effective ongoing communications with the business and technical team. • Strong customer focus, ownership, urgency and drive. • Effective analytical, troubleshooting and problem-solving skills. • He is an Informatica Certified Developer. Technologies • Informatica PowerCenter (versions 7 and above including 9) • ORACLE • DB2 • SAP HANA • UNIX • Python • Autosys • Tivoli Job Scheduler Current Responsibilities • Designs and develops ETL processes by leveraging Informatica Power Center tools • Reviews ETL production design for performance optimization • Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations • Plans and coordinates the implementation of new data requirements • Resolves issues through troubleshooting and quick diagnoses • Maintains effective ongoing communications with the business and development team • Prepares systems procedures, system operating guides, contingency and recovery plans and maintain technical application level documentation

Senior BI Engineer @ From January 2015 to Present (1 year) San Francisco Bay AreaTechnical Lead @ Working as an ETL lead providing data warehousing solutions to world's largest medical device company. Responsibilities • Designs and develops ETL processes by leveraging Informatica Power Center tools • Reviews ETL production design for performance optimization • Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations • Plans and coordinates the implementation of new data requirements • Resolves issues through troubleshooting and quick diagnoses • Maintains effective ongoing communications with the business and development team • Prepares systems procedures, system operating guides, contingency and recovery plans and maintain technical application level documentation From February 2013 to January 2015 (2 years) Greater Minneapolis-St. Paul AreaTechnical Lead @ Client : Farmers Insurance Group Responsibilities • Designs and develops ETL processes by leveraging Informatica Power Center tools • Reviews ETL production design for performance optimization • Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations • Plans and coordinates the implementation of new data requirements • Resolves issues through troubleshooting and quick diagnoses • Maintains effective ongoing communications with the business and development team • Prepares systems procedures, system operating guides, contingency and recovery plans and maintain technical application level documentation From January 2012 to February 2013 (1 year 2 months) Greater Los Angeles AreaSenior ETL developer @ Client : Union Bank of Switzerland (UBS- Investment Banking) Role: Data Integration Developer Activities: • ETL code development and L3 maintainance. • Production Deployment and UAT support • Informatica maintainance and housekeeping. • Scheduling by Informatica scheduler and autosys. • Environment management and deployment. From June 2009 to January 2012 (2 years 8 months) London, United KingdomAssociate software engineer @ Role: ETL Developer Activities: • ETL Design using Informatica 8.1 as ETL. • Audit Balance Control Mechanism in ETL implementation and integration process. • Build (Coding, unit testing & UAT support). • Review • UAT support & Production Implementation at client location. Environment: • Informatica 8.1 on 64 bit HP-UX, Oracle 10g, Erwin 7.1 From July 2007 to June 2009 (2 years)

B.Tech, Electronics & Instrumentation Engineering @ West Bengal University of Technology From 2003 to 2007 S.T.Xaviers Durgapur From 1990 to 2001 Tirtha Dastidar is skilled in: Informatica, UNIX, ORACLE, DB2, Data Warehousing, Unix, Oracle, Agile Methodologies, Integration, Performance Tuning, Unix Shell Scripting, Data Integration, Data Migration, ETL, Data Modeling