Vikas R Email & Phone Number

I have designed and implemented ETL solutions that improved the performance and reliability of data transfer processes across multiple platforms. I worked with tools such as Informatica, Oracle Database, Data Warehouse and Cloud technologies like AWS, GCP transforming complex, unstructured data into meaningful datasets for analytics and reporting. I also leveraged cloud services to build automated and scalable ETL systems, ensuring data availability and integrity for business intelligence needs.Some key highlights of my experience include:Developing end-to-end ETL workflows that processed large datasets with minimal latency, resulting in a 30% reduction in processing time. Optimizing database queries and transformations to handle millions of records, ensuring accurate and efficient data loading into enterprise data warehouses. Implementing error-handling mechanisms to address data discrepancies in real-time, significantly improving data quality and reporting accuracy. Expertise in defining and documenting ETL Process flow, job execution sequence, parameter file requirements, Job scheduling and alerting mechanisms. Understanding and developing project artifacts including business requirements documents,technical requirements documents, Requirement traceability matrices, User acceptance test plans and project definition documentation. Strong experience in designing and developing complex ETL (Extract, Transform, and Load) mappings, reusable components and performing power center administrative task Worked extensively with Data migration, ETL Processes and Web reporting. Proficient in SQL, data warehousing concepts, and performance tuning, have collaborated with data analysts and business stakeholders to meet organizational data needs. Used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator. Ensure adherence to all enterprise security, compliance, legal and audit requirements for assigned projects.