Data Developer

Keyur Desai

SUMMARY

Keyur Desai is a local US Citizen ETL Developer with 8+ years of industry experience. He has been responsible for mappings various transformations, and developing strategies for (ETL) mechanism by using Informatica 9.x/8.x/7.x,SAS and SAS DI. He has also worked with heterogeneous data sources that included Teradata, Oracle, SQL Server, flat files, XML files, CSV files and Text files.

Skill

# Years Used

Last Used

ETL Extract Transfer Load

8+

2020

Informatica

1+

2014

SAS

7+

2020

SQL

7+

2020

EXPERIENCE

ENTERPRISE HOLDING INC., St louis, MO (07/2014 to Present)

ETL Developer

Responsible for developing prototypes and performing complex application coding and programming.

Interprets end-user business requirements to develop and/or modify technical design specifications for off-the-shelf and/or custom-developed applications.

Analyzes and reviews software requirements to determine feasibility of a design within time. In addition, performs unit and integration testing and assists with developing unit test scripts. provides instruction and guidance to less senior team members on new tasks and assignments.

Experience using SAS as a data extract, transform, and load (ETL) tool.

Expertise using SAS/ACESS to Teradata, Oracle and SQL server

Experience in developing SAS Macros and applications for data cleaning, data migration, ad hoc reporting and documentation.

Extensive programming experience with different procedures like PROC SQL,PROC REPORT,PROC FREQ,PROC TRANSPOSE.

AND PROC SORT etc.

Doing the daily production support in weekdays in day/night time.

Performing Build Engineer role after each sprint for deploying the objects into QA & Iprod environment.

Work with SAS admin, Teradata admin, TWS admin to Migrate SAS DI packages, Table objects and TWS files from Dev to Test Environment and from Test to Prod Environment.

Create Jobstream and Job definition for IWS, Tivoli WorkLoad Scheduler.

Works on routine to moderately complex assignments.

Perform Code review of SAS program, DDL changes and Jobs definitions of various application.

Normally receives detailed instructions on work assignments.

Develops and modifies elements of technology.

Assists with the design Tests, researches and investigates the effectiveness of elements of technology.

Implements, operates and maintains elements of technology.

Maintains documentation for elements of technology.

Maintains established service level agreements to meet customer expectations and quality standards.

Generate reports in Salesforce marketing cloud by creating Automation.

Develop nodes in SAS CI to help business for generating reports.

Environment: SAS 9.4 Enterprise Guide, UNIX, Teradata SQL assistance, Flat Files, CSV Files, Salesforce Marketing Cloud (SFMC), SQL Server, IBM Workload Scheduler, Batch script, Windows.

HASBRO, Pawtucket, RI (02/2014 to 07/2014)

ETL Informatica Developer

Designed, developed and tested data conversion/data integration modules to support large scale system migrations and implementations.

Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Configured ODBC connectivity to various source/target databases.

Tuned performance of Informatica session for large data files by using partitioning, increasing block size, data cache size, sequence buffer length and target-based commit interval.

Involved in Unit, System integration testing of Mappings. Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.

Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.

Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.

Created high-level Technical Design Document and Unit Test Plans.

Created Connected, Unconnected and Dynamic Lookup transformations for better performance.

Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.

Created Sessions and partitioned using different partition types like key range partitioning.

Used Parameter files to manage the control dates for the incremental load times.

Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.

Created reusable mapplets using Mapplet Designer which involved date conversions.

Performed Informatica Folder/Object Level Migration using Repository Manager.

Performed Code review of mappings of various applications.

Environment: Informatica PowerCenter 9.1x/9.5, UNIX, Oracle 10g, Flat Files, SAP, SQL Server, Batch script, Windows, PL/SQL, Salesforce Marketing cloud.

NATIONWIDE INSURANCE, Des Moines, IA (04/2013 to 02/2014)

ETL Informatica Developer

Nationwide, is one of the largest and strongest diversified insurance and financial services organizations in the U.S. and is rated A+ by A.M. Best. The company provides a full range of personalized insurance and financial services, including auto insurance, motorcycle, boat, homeowners, life insurance, farm, commercial insurance, administrative services, annuities, mortgages, mutual funds, pensions, long-term savings plans and health and productivity services.

ICA-IMT

ICA – IMT, Independent Commercial & Agri – Information Management Team, own the IT Datawarehouse applications for ICA line of business. ETL Datawarehouse is being redesigned from Galaxy DataWarehouse to Information Management System Datawarehouse.

It is a support and break fix project handling over 19 different applications of Insurance domain. The main tasks handled are: Incidents, Data Issues and pilot work. Incidents are escalated by Level2 team. Provide short term and long-term fix for the incidents. Data Issues are assigned when unexpected data volume is populated. We analyze and identify the root cause of the data discrepancy and clean up the data. This demands strong analytical & technical knowledge.

Pilot work relates to tasks, to be executed in the production environment, requested by development teams.

Break fix relates to fixing by making development code changes wherever defects are identified.

Developed several generic Informatica mappings, workflows which can be reused for several processes.

Worked extensively on Teradata to load the data from Unix Server, SQL server 2008.

The systems were implemented using SAS and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used.

Created Informatica workflows to run daily, biweekly and monthly based on the business requirements.

Extracted sources from flat-files, CSV & Text files, SQL Server and load them into Teradata using SAS Enterprise guide.

Worked with ETL Migration Team and Migrated SAS libraries from Dev to Test repository and from Test to Prod Repository.

Used Change data capture (CDC) for data integration that is based on the identification, capture and delivery of the changes made to enterprise data sources.

Configured ODBC connectivity to various source/target databases.

Monitored all JOBS using TIVOLIscheduler.

Extensively work on TIVOLI Scheduler to create Schedule and Job definition.

Environment: Informatica 9,9.1,9.5, ETL, Maestro Tivoli Scheduler, Teradata, Oracle & Unix Shell Scripting, XML

EDUCATION

Computer ENG.

Aptech Institute, Gujarat, India

Contact this candidate