Amit Nair

About Amit Nair

Over 9 1/2 years of IT industry experience with extensive experience in the Analysis, Design, Development and Validation of Data Warehousing & Data Integration Solutions for Healthcare and Telecom Industry.SUMMARY->Expertise in ETL tools like Informatica Power Center and Pentaho data integration->Expertise in databases like Oracle PL/SQL and MS SQL server->Experienced in all SDLC phases of the Data Warehouse project which includes Requirements gathering, Data Requirement Analysis, Solution design & Data Mapping, Code development, Unit testing and Deployment->Experienced in Agile projects, involved in sprint planning and maintaining the agile dashboard->Strong ability to analyze source systems and business requirements, identify and document business rules, prepare Data models based on the requirements->Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies->Extensive experience with Informatica data extraction, Transformation and loading from various sources like Oracle, SFDC and Flat files->Experience in Integration of Amazon Web Services (AWS) using S3, EC2 and RDS->Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL->Effectively made use of Indexes, Table Partitioning, Analytical functions, Materialized Views and Dynamic SQLs->Well versed in SQL Optimization, performance monitoring and tuning using explain plan, hints, indexes and partitioning->Hands on experience in QlikView and Qlik Sense->Hands-on experience in identifying and resolving performance bottlenecks at the source, target, mapping and sessions level->Extensive experience on Incentive Compensation Management [ICM] with Hands-on experience using True Comp tool->Team player with excellent leadership, communication and interpersonal skills. Poses good analytical and problem solving skills.

Experience

1. Senior Product Engineer

   Deloitte

   Sep 2019 — Present · Atlanta, GA, US

Education

• Cochin University of Science and Technology

  Bachelor's Degree, Computer Science

  2004 — 2008

Skills

• Informatica
• Truecomp
• Aws
• Business Process Design
• Etl
• Hp Quality Center
• Data Modeling
• Incentive Compensation Management
• Jira
• Software Project Management
• Sql Server Management Studio
• Data Integration
• Business Intelligence
• Agile Project Management
• Oracle
• Requirements Analysis
• Databases
• Agile Methodologies
• Pl/Sql
• Data Warehousing
• Functional Analysis
• Business Requirements
• Sql
• Microsoft Sql Server
• Sdlc
• Pentaho