Sudharshan
Summary
5.0 years of experience in design, development, data integration, and transformation using cloud of software applications. Data Warehousing Technology by using, ETL tool Informatica Power Centre 10x/9x and Informatica other tools. Working closely with onsite team to understand the data flow and data requirements. Working on Informatica IICS for Data Extraction, Integration, Staging and post migration validation activities. Worked on mapping, task flows and parameter files. Involved in design, development, unit and integration testing. Performed ETL performance tuning and Process Optimization (used Caching, pushdown optimization etc.). Worked with business teams in EMEA, EVOLVE to understand requirements and provide enhancement/bug fixes. Participated in peer code review daily, weekly and monthly basis. Involved in daily status calls, preparing reports and conducting walkthrough sessions. Expertise in ETL Analysis, design, development, testing and implementation of Data Warehousing and EDW solutions using Informatica Power Centre & IICS. Possess complete domain and development Life Cycle knowledge of Data Warehousing. Worked on Push down Optimization and Partitions to improve the performance. Responsible for overall development for the mappings, tasks, Taks flows and scheduling jobs Optimizing Informatica Mappings and Sessions to improve the performance. Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions. Knowledge with UNIX, SQL Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
Overview
3
3
years of professional experience
Work History
ETL Developer
Infosys Limited
Bangalore
06.2022 - Current
- Company Overview: Infosys is a global leader in technology services and consulting.
- Working on ETL development using Informatica PowerCenter and IICS.
- Infosys is a global leader in technology services and consulting.
ETL Developer
Avnet
- Company Overview: Avnet is a global technology distributor and solutions provider. For more than a century, Avnet made it easier for customers and suppliers to activate the transformative possibilities of technology. Avnet is one of the topmost leading companies in chip designing and FPGA market.
- Designed the Mapping Technical Specifications on the basis of Functional Requirements.
- Created ETL mappings using Informatica Power Center to move Data from multiple sources like Oracle, Flat files into a common target area such as Staging, Data Warehouse and Data Marts.
- Designed, Developed, and Implemented ETL processes using IICS Data integration.
- Created IICS connections using various cloud connectors in IICS administrator.
- Installed and configured Windows Secure Agent register with IICS org.
- Created mapping documents with detailed source to target transformation logic, Source data column information and target data column information.
- Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
- Prepared Unit test cases for the mappings.
- Involved into the preparation of deployment plan which contains list of mappings and workflows they need to migrate bases on this deployment team migrate the code from one environment to another environment.
- Involved in unit testing for the mappings developed by myself.
- Avnet is a global technology distributor and solutions provider. For more than a century, Avnet made it easier for customers and suppliers to activate the transformative possibilities of technology. Avnet is one of the topmost leading companies in chip designing and FPGA market.
ETL Developer
Nissan
- Company Overview: The Nissan Data Integration and Reporting Project aims to build a unified data platform to manage and analyze large volumes of enterprise data across Nissan’s global operations.
- Monitoring jobs ran in scheduled time. Raising tickets for the failure jobs. Finding root cause for the failure jobs.
- Experience in debugging ETL jobs to check in for the errors and warnings associated with each Job run.
- Optimized existing jobs which running long time and used partition techniques.
- Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
- Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
- Analyze job failures, identify root causes, and perform quick resolutions to restore normal operations.
- Manage on-call support during critical job schedules or month-end loads.
- Handle incident and change management through tools like ServiceNow, ALM.
- Perform root cause analysis (RCA) for recurring issues and implement preventive solutions.
- Validate data loads and perform reconciliation checks between source and target systems.
- Communicate effectively with business users and stakeholders regarding issue updates and resolutions.
- Monitor ETL jobs and data pipelines (Informatica PowerCenter / IICS) on a daily basis to ensure successful completion.
- The Nissan Data Integration and Reporting Project aims to build a unified data platform to manage and analyze large volumes of enterprise data across Nissan’s global operations.
Education
B.Sc. - computers science
YV University
Kadapa01.2015
Master of Business Administration (MBA) -
Sri Venkateswara university
TirupathiSkills
- ETL Tools: Informatica Power Center 10x
- Informatica Power Center 9x
- Informatica Intelligent Cloud Services (IICS)
- Product 360 (PIM tool)
- Operating Systems: Windows
- Operating Systems: UNIX
- Technologies: UNIX shells Script
- Databases: Oracle
- Databases: SQL Server
- Databases: Snowflake
Timeline
ETL Developer
Infosys Limited
06.2022 - Current
ETL Developer
Avnet
ETL Developer
Nissan
B.Sc. - computers science
YV University
Master of Business Administration (MBA) -
Sri Venkateswara university