Ranjit Kumar Rana
Senior Data Engineer @ LTI Mindtree
- Role
- Senior Data Engineer at LTIMindtree
- Location
- Kolkata, WB, IN
- LinkedIn followers
- 500 followers
About Ranjit Kumar Rana
Senior Data Engineer with 4.7 years of extensive experience in designing, implementing, and optimizing robust data pipelines, databases, and cloud-based infrastructures. Adept at monitoring and enhancing the performance of complex ETL workflows using tools like Informatica PowerCenter, Control-M, and cloud storage solutions such as AWS S3 and Azure Storage. Proven expertise in query optimization, PL/SQL development, data integration, and automation using Python and shell scripts. Experienced in building scalable, multi-cloud data architectures and pipelines, utilizing platforms such as AWS, Azure to ensure smooth data processing, real-time streaming, and integration with data lakes and warehouses. Passionate about improving data availability, integrity, and quality through proactive monitoring, validation, and continuous automation, driving improvements in operational efficiency and performance.
Experience
Senior Data Engineer
Oct 2024 — Present · Kolkata, IN
ETL Workflow Design & Optimization: Developed and optimized complex ETL workflows using Informatica PowerCenter to ensure efficient data ingestion, transformation, and loading, supporting analytics and reporting needs. Improved ETL performance by enhancing data flow, reducing transformation complexity, and minimizing bottlenecks. Database Development & PL/SQL Scripting: Designed and implemented database objects such as tables, views, functions, and stored procedures. Developed PL/SQL scripts to support business logic and data processing tasks, ensuring efficient execution and data integrity. Cloud-Based Data Solutions: Implemented data storage solutions using AWS S3 and Azure Storage for Oracle database data, and explored cloud-based ETL workflows to integrate on premise and cloud storage solutions, enhancing scalability and data accessibility. Python Automation & Data Processing: Developed Python scripts to automate data extraction, transformation, and integration tasks. Notable achievements include creating a script to process multi-page TIFF/PDF files, reducing processing time by 70%, and automating FTP/SFTP-based data transfers. Web Scraping & Data Extraction: Worked on web scraping projects using Selenium and Python to automate data extraction and interaction with websites. Also extracted data from images and PDFs using Python-based libraries to facilitate further processing and integration into workflows.
Education
SAGAR INSTITUTE OF SCIENCE & TECHNOLOGY (SISTEC), GANDHI NAGAR
Bachelor of Engineering - BE, Computer Software Engineering
2016 — 2020
ST. COLUMBA'S COLLEGE, HAZARIBAG
Higher Secondary School, Science
2013 — 2016
Govt+2 High School Barkatha,Hazaribag(Jharkhand)
Matriculation, All subjects
2003 — 2013
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.