Nitin Tripathi

  

Certifications

Certified ScrumMaster

Work experience

The Walt Disney Company, Senior DW/BI Analyst
July 2012 - August 2013, Burbank, CA, United States
• Perform as a Liaison with Business for drafting the requirements, implementing design and development of various DW/BI components • Work on migration projects – Informatica 8.1 -> Informatica 8.6, AS400 to Teradata • Design and implement the Audits, Balancing and Controls Process to capture data load statistics, ensure data integrity and enable auditability and traceability. • Manage projects and enhancements applying Agile methodology • Performed on-call – level-1 Production support

Toyota Motor Sales, Sr ETL Developer
September 2008 - July 2012, Torrance, CA, United States
• Assisted Business Analysts with drafting the requirements, implementing design and development of various components of the application • Worked exclusively on performing the ETL to Level 1 as is staging, CDB Load, Level 2 Staging, CDW load and surveys and extracts generations from CDW based on the business rules and transformation specifications • Provided on call – level-1 support and level-2 support for issues in production code • Designed Incremental load strategy, Created Reusable Transformations, Mapplets, and Mappings/Sessions/Workflows etc. • Worked on data quality initiatives • Worked on Offshore-Onsite model and provided guidance to Offshore team • Estimated and prioritized tasks by collaborating with the Project Manager • Performance tuned the existing code on Informatica and database side. Worked on migration projects – Oracle 9i -> Oracle 10g and Informatica 8.1 -> Informatica 8.6 • Awarded by Toyota for Innovation & commitment, for outstanding innovative solutions and their implementation

Toyota Motor Sales, ETL Developer
May 2008 - August 2008, TORRANCE, CA, United States
• Worked on a Dimensional Model of EPC Data mart with Snowflake schema • Designed, Developed and unit tested the ETL process for loading the Vehicle/Part records across STAGE, ODS and RDS schemas • Collaborated with Project Manager to prioritize development activities and subsequently handle task allocation with available team bandwidth • Maintained documents for Design reviews, SOX audits, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans • Awarded star of the quarter by Cognizant for going beyond my duties and contributing to other projects

Washington Mutual, Offshore ETL Lead
November 2007 - May 2008, Pune, Maharashtra, India
• Interacted comprehensively with the onsite lead/ Clients to understand the nature of data to be migrated to CMD. • Designed, Developed and Tested the ETL for data transition from Epiphany AP/CMD to CMD Staging and finally to CMD which was used for generating the reports. • Implemented the conventional load from Epiphany AP/CMD -> CMD Staging -> CMD schemas. • Coordinated the System Integration Testing, Functional testing and Smoke testing. • Conducted peer review of the design and code ensuring proper follow up of Business Requirements while adhering to quality and coding standards.

Wells Fargo Bank, Onsite ETL Lead
October 2006 - November 2007, Minneapolis, Minnesota, United States
• Interacted with BA’s and analyzed/gathered requirements for the new system. • Conveyed the requirement to offshore Build Team and get the code along with Unit Test cases from build team, ensuring timely and quality delivery. • Supported the System integration Test cycle by analyzing and fixing the defects along with code migration. • Coordinated with operations team for deploying the code in production environment. Along with latest code, maintained deployment checklist and mapping change documents using the Version control of respective tool • Worked on code debugging and validation and Involved in Code Review. • Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc). • Completed documentation in relation to detailed work plans, mapping documents and high-level data models.

JPMorgan Chase banking, ETL Developer
February 2005 - September 2006, Pune, Maharashtra, India
• As a key member of the Informatica Build Team, I was responsible for understanding ETL & UNIX shell scripting requirements, code development, creation of Unit Test Cases and ensuring a bug free quality delivery. • Developed a robust ETL process for business users to obtain consistent commercial loan and participation transactions data through the existing Credit Infrastructure Transaction System, developed an ETL process, which processed around 600,000 loan transaction records on a daily basis. • Developed code to audit the ETL processes in Audit log table and raise exceptions and send it to Operations team for analysis. • Conducted peer review of the design and code ensuring proper follow up of Business Requirements while adhering to quality and coding standards. • Provided guidance, coaching and mentoring to the Entry Level Trainees. • Participated in Transition ’06 event as a Data Warehouse Team Lead and was responsible for creating DW Architecture diagrams, Presentation, quizzes and games for the DW Stall.