Aug 2018
Present
Associate Consultant
Syntel Private Limited
Pune, IN
- Experience in extraction, transformation and loading of data directly from different source systems like Oracle, flat files, SQL Server and DB2.
- Good experience in Informatica Designer tools like Source Analyzer, Target Designer, and Mapping Designer.
- Good experience in Informatica Workflow Manager tools like Task developer, Workflow Designer.
- Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Used different transformations such as Source Qualifier, Expression, Aggregator, Joiner, Sorter, Lookups, Filters, Normalizer, Update Strategy and Sequence Generator to develop robust mappings
- Good at developing mappings, define workflows &tasks, monitoring Sessions
- Good at performance tuning of Informatica mappings.
- Created mapping documents to outline data flow from sources to targets
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
- Modified existing mappings for enhancements of new business requirements
- Wrote UNIX shell Scripts & PMCMD commands for SFTP of files from remote server
Education
May 2014
Jun 2018
Bachelor of Technology in C.S.E in University of Technology and Management
loading...