Piyush Rai
ETL Developer | 5+ Yrs Experience at TCS | Expertise in IDMC, IICS, Informatica Power Center, SQL, GCP, GBQ | Building Scalable Data Pipelines | Informatica Cloud Certified | 🚀 Serving Notice Period(7th Apr LWD)
- Role
- System Engineer (Etl Developer) at Tata Consultancy Services
- Location
- Gurugram, HR, IN
- LinkedIn followers
- 500 followers
About Piyush Rai
Currently serving notice period(90 Days) and open to new ETL / Informatica opportunities. Available for interviews.I’m a Data Engineer and Informatica IICS Developer with 5+ years of experience designing, developing, and optimizing end-to-end data integration solutions. Currently at Tata Consultancy Services, I specialize in building scalable ETL pipelines using Informatica IICS, PowerCenter, and SAP BW, enabling clients to unlock actionable insights from complex enterprise data.My academic foundation in Computer Science (Amity School of Engineering & Technology) and Certified Ethical Hacker (CEH) credential give me a unique edge in delivering solutions that are not only efficient but also secure and compliant. Whether it’s migrating legacy systems to cloud platforms, orchestrating data flows between on-prem and cloud systems, or improving load performance, I approach every project with a focus on clean architecture, automation, and business value.I’m proficient in SQL, Unix/Linux scripting, and data warehouse design, and I enjoy turning data chaos into structured intelligence that supports better decisions. I thrive in fast-paced, collaborative teams that value technical excellence and innovation.If you\'re working on cloud modernization, ETL strategy, or data platform transformation, let’s connect.
Experience
System Engineer (Etl Developer)
May 2022 — Present · Noida, IN
Working as an Informatica IICS and IDMC Developer, responsible for designing, developing, and maintaining end-to-end ETL workflows.Implemented data integration, transformation, and migration pipelines using Informatica IICS, ensuring data accuracy and performance.Migrated multiple on-prem PowerCenter workflows to Informatica Cloud (IICS/IDMC) platforms, improving scalability and cloud readiness.Collaborated with data architects and business analysts to define data flow, mapping rules, and transformation logic.Automated workflows using parameterization, scheduling, and reusable mappings to streamline data processing.Strong hands-on exposure to SQL, UNIX/Shell scripting, data quality, and cloud data integration.Skills: Informatica IICS · IDMC · PowerCenter · SQL · Data Quality · UNIX · ETL Development
Education
Amity School of Engineering and Technology, AUMP
Bachelor of Technology, Computer Engineering
The Board of High School and Intermediate Education Uttar Pradesh
Senior higher secondary ( XII), Mathematics and Computer Science
2013 — 2015
Central Board of Secondary Education
Higher secondary (X), Science
2011 — 2013
Amity University
Bachelor of Technology, Computer Science
2015 — 2019
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.