Subhadeep Dutta Email & Phone Number

Pune, Mh, In

Pune, Mh, In

Pune, Maharashtra, India

Pune, Maharashtra, India

 > 2 Years of Experience in ETL Development Using Informatica PowerCenter 10.2 > Strong ETL Informatica experience and Data Warehouse. > Good SQL / Unix knowledge. > Experience in working with RDBMS like Oracle. > ETL Development using Informatica – Simple to Complex Transformations logic, > Mappings, Sessions, Workflows. > Strong experience working on transformations like Source Qualifier, Expression, Joiner, Aggregator, Update Strategy, Union, Filter, Router, Sorter, Connected –Unconnected Lookup transformations, etc. > Debugging complicated mappings and fixing errors. > Involved in ETL testing. > Technical expertise in the design, development, coding, testing and debugging. > Design, implement and continuously expand data pipelines by performing Extraction, transformation and loading activities. > Gather requirement and business process knowledge in order to transform the data in a way that’s geared towards the need of end users. > Excellent technical and communication skills who can interfere with internal stakeholders to understand their needs to perform ETL tasks.  > Work with the business in designing and delivering correct, high-quality data. > Investigate data to identify potential issue with ETL pipeline, notify end user and propose adequate solution. > Ingest the data from heterogeneous source into system. > Expertise in the design, creation, management and business use of large datasets. > SQL Knowledge (query performance tuning, index maintenance) as well as understanding of database structure. > Knowledge of data modelling principles. > Passionate about complex data structures and problem solving. > Participate in Sprint Planning. > Involved working in Agile Methodology. > Have experience in Unix Shell scripting. > Ability to pick up new data tools and concepts quickly.