Purushotham

• Having 6 of IT experience as Data Engineer and Data Analyst. • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. • Experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Oracle implemented complex business logic through ETL with creating many complex mappings. • Proficient in source system analysis and good debugging skills with extensively worked on Data cleansing and Data Staging of operational sources using ETL processes for data warehouses. • Sound knowledge in Informatica Partitioning, Pushdown Optimization and other Performance Enhancements features. • Independently perform complex troubleshooting, root-cause analysis and solution development. • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. • Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills. • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines. • Experience in PL/SQL programming, writing procedures, functions, exceptions etc. • Strong behavioral points include excellent interpersonal communication and management skills, quick adaptation, pressure handling and group dynamism. • Effective in working independently and collaboratively in teams. • Well Experience in using Control Flow Tasks like Execute SQL task, Bulk Insert Task, File System Task. • Experience in Using Containers like For-Each Loop Container, Sequence Container, FTP Task, • Used Data flow Task components like Data Conversion, Derived columns, Conditional Split, Aggregate, Row Count, Multi-cast, Sort, SCD (Slowly Changing Dimensions), Union all, Merge, Lookup and various other Transformation to manipulate data in SSIS package at the Data Flow level. • Performed Logging and Deployment of various packages deploying the SSIS Packages from development server to production server. • Worked creating pipelines in IICS to migrate data from different sources to s3. • Worked on enhancing flows in IICS,