Ashutosh Dalbehera Email & Phone Number

Mechanicsburg, Pa, Us

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. • Enhanced Code to develop new functionalities, to meet specific business needs.• Fine-tuning of code, reduce job run timings, achieving SLA timings, and making data available before start of business day.• Implemented reusable Informatica mapplet, common across subject area which resulted considerable saving in time and effort.• Implemented solution for handling dynamic input file to update multiple tables in a single Informatica execution. • Implemented Oracle hints to optimized existing sql query.• Worked on Informatica Power Exchange to receive mainframe data for membership subject area.• Implemented incremental logic, mapping/table partition, bulk load option, for performance tuning of existing Informatica mapping.• Responsible for code migration, deployment group creation and production implementation.• Supported QA/UAT testing with identifying data needs, preparing test data and support during testing.• Documented all the implementation and CRQ deployments related to project.

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, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations• Documented the mappings used in ETL processes

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• Created Reports using Table, Cross Tab, Chart and Master-Detail formats• Created Reports using Multidimensional analysis modes Drill Mode and Slice and DiceAs an Oracle Developer I was involved in• Feed processing to Host database• Query manipulations for report generation and investigation• Client ad-hoc job on request• Different type of monthly and weekly report generation

Master In Information Technology, Data Analytics

Bachelor'S Degree, Mechanical Engineering

All India Senior School Certificate, Science