Ashutosh Dalbehera Email & Phone Number

Danville, PA, US

Danville, Pa., US

Indianapolis, Indiana, US

Detroit, Michigan, US

• Provided first tier of production support for Enterprise Data Warehouse, Job Monitoring, Job statistics, documenting daily status report.
• Completed training in Big data, Hadoop training and implementation in EDW.
• Identifying root causes of job failures, coordinating failure triages and working with operations team for speedy resolution and achieving SLA.
• Analyzing data and validating data quality using, Informatica IDQ tool. And provide root cause analysis to business user.
• Identify and working with Business team to resolve data issues, identifying data cleanup strategies.
• Involved with Book of Business and Data feeds subject area, working closely with Solution architect and Business Analyst.

Teaneck, New Jersey, US

• Involved in designing few tracks in this process, including working closely with Solution Architect and Business Analyst.
• Understanding process, ETL requirement and knowledge transfer to offshore team for development and testing.
• Design specification, Unit Testing, Code Review, Documentation required for next phase migration of code.
• As a tech lead, provide guidance to offshore, solving issue, providing performance tuning tips, delivering code with in time.
• Verifying/validating quality and coding standard

• Developing mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems in to Data Warehouse
• Development of ETL process using Informatica to load the data from source to target Oracle database
• Optimizing the mappings to load the data in SCDs
• Validating mapping, Unit testing to ensure that data loaded as per ETL specification. And, Performance tuning
• Creating workflows, sessions, and task also run workflows
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy.

Reading, GB

• Extensively worked on Informatica tools such as Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Transformations and mapplets), Workflow Manager, and Workflow Monitor
• Developing mapping using needed transformations in Informatica tool according to technical specification
• Resolving any performance issue with transformations and mapping with the help of technical specifications

• As an ETL Developer I was involved in
• Retrieving data from heterogeneous sources and load in to target
• Using various transformations needed as per the logic of mapping
• Creating and run workflows and sessions
• Unit testing and performance issue related to mapping
• Developed and created classes with Dimension, Detail & Measure Objects and Resolved loops by creating Aliases and Context

Master In Information Technology, Data Analytics

Bachelor'S Degree, Mechanical Engineering

All India Senior School Certificate, Science