Summary
Overview
Work History
Education
Skills
Timeline
Generic

Amit Nair

Orange,CA

Summary

Consultant and Tech Lead with 24 years of experience in enterprise data platforms, currently spearheading initiatives at Nationwide Insurance. Expertise in managing large-scale data warehouse and ETL solutions utilizing Informatica, Talend, Snowflake, and Oracle. Proficient in implementing CI/CD pipelines with GitHub Actions and UAC scheduler, ensuring compliance and security in collaboration with IRM and enterprise architecture teams. Experienced in leading onsite/offshore teams, driving agile delivery, and formulating technical strategies across various applications.

Overview

21
21
years of professional experience

Work History

Consultant,Software Engineer

Nationwide Insurance
Orange, CA
08.2017 - Current
  • Executed design and development of ETL processes in AWS Glue for GIN data migration from MySQL sources to AWS S3.
  • Designed policy conversion ETL process from REN to GIN, enhancing operational efficiency.
  • Collaborated with architects on implementing data lake processes within the Pet framework.
  • Reviewed data models with project teams, ensuring compliance with best practices.
  • Managed both onsite and offshore personnel while maintaining project alignment.
  • Tuned Informatica mappings, achieving optimum performance levels for diverse projects.
  • Delivered production support related to ETL schedules, resolving issues alongside BI/IT teams.
  • Led Scrum meetings, mentoring team members to foster collaborative work environments.

Tech Lead

AIT GLOBAL INC
03.2014 - 08.2017
  • Executed role of BI Consultant and Sr. ETL Developer for BI projects, encompassing requirements analysis, design, development, testing, implementation, and production support.
  • Led all phases of project design, development, quality assurance, and implementation.
  • Created extensive mapping/mapplets and reusable transformations using various techniques such as Lookup, Filter, Expression, Normalizer, and Aggregator.
  • Conducted performance tuning of workflows and mappings to enhance efficiency.
  • Supervised Informatica Developers in job development and troubleshooting, providing guidance on logic implementation.
  • Developed mappings to ensure data quality and integrity throughout processes.
  • Collaborated with Informatica Admin team for code migration to QA and PROD environments.
  • Coordinated onsite-offshore activities, reviewing deliverables and providing regular status updates to PMO and stakeholders.

Onsite project lead

AIT GLOBAL INC
04.2014 - 11.2014
  • Led technology team, which consisted of Beachbody employees, onshore and off-shore consultants, and project, involved multiple groups throughout the organization.
  • Worked with the business analysts to gather business requirements to be translated into design considerations.
  • Discussing with Business and understanding the requirement and prepared the high level functional design document.
  • Developed complex mapping subrogation and delivered to third party of client on time
  • Created transformations such as Expression, Joiner, Aggregator, Sorter, Filter, Router, Lookup and mapplet to apply the business logic and load data into target.
  • Implemented Dynamically Creation of Parameter file for the application.
  • Designed and Developed Mappings, Mapplets, Sessions, Worklets, Workflows, to extract, Transform and Load the Data in EDW.
  • Worked on Performance Tuning Mappings & Sessions and loaded data with client specified timelines.
  • Experience in Development and maintenance of Informatica and OBIEE repository.
  • Coordinate with Reg Reporting apps for testing to make sure no breach in app due to masking of upstream application.
  • Prepared UTC document and support the team during QA and UAT phase.
  • Reviewed the Design doc and Code with the Client team and STM review with Business team.
  • Worked with Informatica Admin team to migrate codes to QA and PROD environment.
  • Sending the updated status report to the client/vertical manager on weekly basis.
  • Technical Environment: Informatica Power Center 9.1, Oracle 10g, UNIX, Autosys, OBIEE

Onsite Project Lead

Igate technologies
10.2008 - 04.2014
  • Led technology team, which consisted of UB employees, onshore and off-shore consultants, and project, involved multiple groups throughout the bank structure.
  • Worked with the business analysts to gather business requirements to be translated into design considerations.
  • Discussing with Business and understanding the requirement and prepared the high level functional design document.
  • Developed complex mapping subrogation and delivered to third party of client on time
  • Created transformations such as Expression, Joiner, Aggregator, Sorter, Filter, Router, Lookup and mapplet to apply the business logic and load data into target.
  • Implemented Dynamically Creation of Parameter file for the application.
  • Designed and Developed Mappings, Mapplets, Sessions, Worklets, Workflows, to extract, Transform and Load the Data in EDW.
  • Scheduled the entire process in Autosys.
  • Worked on Performance Tuning Mappings & Sessions and loaded data with client specified timelines.
  • Presented the design document for Q & R review with the client architecture team, DBA and business team to get the approval and move to next phase of project cycle.
  • Experience in Development and maintenance of Informatica and OBIEE repository.
  • Coordinate with Reg Reporting apps for testing to make sure no breach in app due to masking of upstream application.
  • Prepared UTC document and support the team during QA and UAT phase.
  • Reviewed the Design doc and Code with the Client team and STM review with Business team.
  • Worked with Informatica Admin team to migrate codes to QA and PROD environment.
  • Sending the updated status report to the client/vertical manager on weekly basis.
  • Technical Environment: Informatica Power Center 9.1, Oracle 10g, UNIX, Autosys, OBIEE

Onsite Project Lead

Igate technologies
09.2012 - 11.2012
  • Facilitated JAD sessions to gather the data warehouse requirements from the users.
  • Analyzed business requirements, performed source system analysis, prepared functional and technical design documents.
  • Performed Dimensional data modeling and created Star Schema model to meet the OLAP needs.
  • Process the high volume by doing partition at session level and creating intermediate temp table approach.
  • Has worked on Information Lifecycle Management.
  • Has worked on Informatica Data Quality (IDQ) to standardize the data as per the business rules.
  • Has knowledge on Master data management, concepts implemented in the project.
  • The aggregated tables are populated from 10 years data.
  • Preparing Low level ETL design document and creating SQL views
  • Developing Informatica mappings, sessions, worklets and workflows and stored procedures.
  • Establishing and monitoring issue management, change request and quality management processes
  • Created transformations such as Expression, Joiner, Aggregator, Sorter, Filter, Router, Lookup, Normalizer, SQL and Rank, Sequence generator, mapplet to apply the business logic and load data into target.
  • Debugger and monitor and ensure correct flow of data through mapping.
  • Worked with pre and post sessions, and extracted data from Transaction System into Staging Area
  • Worked with client’s vendor partners to migrate code to different environments and resolve the migration issues.
  • Communicates with source system to correct the source data.
  • Perform Quality assurance and review process once the build is over.
  • Releasing the files to application development team on daily basis as per specified time line.
  • Prepared Run books, production monitoring and support handbook for daily, and weekly and monthly processing.
  • Sending the updated status report to the client/vertical manager on weekly basis.
  • Technical Environment: Informatica 9.1, Oracle 10g, UNIX, Autosys, Cognos

Onsite project lead

Igate technologies
05.2010 - 11.2010
  • Participation in High-level Design documents like Application Design Document, Technical Architecture Document, and Data Profiling.
  • Participation in logical and physical data model creation and finalization.
  • Participation in data profiling for data quality assessment.
  • Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
  • Involved in the analysis, design and development of all the interface’s using Informatica PowerCenter tools in interface team and interfaced with all the other tracks for business related issues
  • Created complex Informatica mappings to load the datamart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, lookup, Joiner, Union, Normalizer and Sequence generator.
  • Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
  • Liaising with Business users.
  • Designing and creation of data loading strategies.
  • Communication and co-ordination with ETL manager.
  • Development of ETL Jobs and builds for Development, UAT and Production.
  • Participation in design reviews.
  • Creation of Unit test cases for data loads.
  • Reviewing of Test cases for data loads.
  • Participation and Support in System Testing, User Acceptance Testing and Operation Testing of the application.
  • Testing individual test cases.
  • Development of Integrated Testing.
  • Classification and reporting bugs to the ETL manager.
  • Technical Environment: Informatica 9.1, Oracle, UNIX, QC.

Onsite project lead

Igate technologies
11.2008 - 05.2010
  • Analyzed existing system prepared and presented an Impact Analysis Document.
  • Actively participated in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart.
  • Created Several Informatica Mappings to populate the data into dimensions and fact tables.
  • Developed various mappings by using reusable transformations.
  • Improved the mapping performance using SQL overrides.
  • Created Mapplets and used them in different mappings.
  • Used Debugger to test the data flow and fix the mappings.
  • Implemented Error data validations using Error handling strategy techniques.
  • Tuning Informatica Mappings and Sessions for optimum performance.
  • Post-Production support to monitor jobs in new environment.
  • Developed mappings, sessions and workflows for the new ETL process followed with Quality standards.
  • Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy and Normalizer.
  • Developed and implemented the long term IT goals and strategies.
  • Created reports in Informatica Power Analyzer.
  • Participate in the rotation of 24/7 supports.
  • Participation in Extraction of Historical Data from Aurion System, Cleansing and Conversion of Warehouse Loading.
  • Creation of Unit test cases for data loads.
  • Technical Environment: Business Object data integrator (BODI), Oracle

Developer

Lehman Brothers
10.2006 - 11.2008
  • Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to Build Data Marts.
  • Setup Procedures to Extract, Transform and Load (ETL) data from Operational Systems to the Data Warehouse by Using Informatica.
  • Developed a number of Informatica Mappings and Transformations to load data from relational and flat file sources into the data mart.
  • Worked on several transformations such as Filter, Joiner, Lookup, Rank, Sequence Generator, Stored Procedure and Expression in Informatica.
  • Implemented Type – 2 Slowly Changing Dimensions.
  • Involved in creating, editing and scheduling of the Sessions in Informatica.
  • Tuned the Transformations and Sessions for better performance.
  • Used pre-session and post-session scripts for dropping and recreating indexes on target table.
  • Recovered the failed sessions by enabling the recovery option.
  • Technical Environment: Informatica, Oracle, UNIX, Autosys, Business objects

Trainee Programmer

Godrej InfoTech Ltd
01.2005 - 09.2006
  • Requirement gathering and requirement Analysis
  • Code creation
  • Conduct reviews
  • Test case preparation.
  • Review of Unit test cases, Integration test cases of all the assigned modules.
  • Testing individual modules of the software against the Unit test cases.
  • Doing Integration testing of the software against integration test cases.
  • Classification and reporting the bugs to the Project Lead
  • Repeating the Individual modules and Integration testing cycles after bug fixes.
  • Technical Environment: Visual basic, Oracle 9i, Crystal reports

Education

Masters - computer technology

Masters - computer Application

Bachelor of Science - Physics

Advanced diploma - computer application

Skills

  • Cloud and data platforms: AWS (S3, Glue), Snowflake, Informatica Intelligent Cloud Services, Talend Cloud
  • DevOps and automation: GitHub Actions, CI/CD pipelines, UAC Scheduler, Harness, Shell scripting
  • ETL and data integration: Informatica PowerCenter, Talend, PySpark
  • Data modeling: Star and snowflake schema, dimensional modeling, ER diagrams
  • Databases: Oracle, SQL Server, DB2, MySQL, Sybase
  • SQL and PL/SQL: Stored procedures, views, materialized views
  • Version control and collaboration: GitHub, VSS
  • Scheduling tools: Autosys, UAC
  • Reporting tools: Business Objects, Oracle Reports
  • Tools and utilities: TOAD, SQL Developer, MS Office
  • Testing and tracking: Quality Center (QC), JIRA
  • Domain knowledge: Insurance (P&C), financial services

Timeline

Consultant,Software Engineer

Nationwide Insurance
08.2017 - Current

Onsite project lead

AIT GLOBAL INC
04.2014 - 11.2014

Tech Lead

AIT GLOBAL INC
03.2014 - 08.2017

Onsite Project Lead

Igate technologies
09.2012 - 11.2012

Onsite project lead

Igate technologies
05.2010 - 11.2010

Onsite project lead

Igate technologies
11.2008 - 05.2010

Onsite Project Lead

Igate technologies
10.2008 - 04.2014

Developer

Lehman Brothers
10.2006 - 11.2008

Trainee Programmer

Godrej InfoTech Ltd
01.2005 - 09.2006

Masters - computer technology

Masters - computer Application

Bachelor of Science - Physics

Advanced diploma - computer application

Similar Profiles

CREATE PROFILE
Amit Nair