Souvik Das
Associate - Projects @ Cognizant | Ex-TCS | Data Engineering, Data Integration
- Role
- Associate - Projects at Cognizant
- Location
- Kolkata, WB, IN
- LinkedIn followers
- 500 followers
About Souvik Das
IT Engineer with 7 years of experience in Telecommunications and Insurance domains. For the first two years, I excelled as a PL/SQL developer, and currently, I lead ETL development projects. My technical expertise spans Informatica PowerCenter, IDMC, IICS, Oracle PL/SQL, Oracle Database 12c, PostgreSQL, Microsoft SQL Server, Data Warehousing, Tableau, Unix, and CI/CD.I\'m passionate about data, pursuing interests in Data Engineering and Data Science. Beyond my technical roles, I actively engage in requirement gathering, client communication, mentoring, and project leadership. Continuous learning and staying updated on technology trends are integral to my professional journey.I\'m on the lookout for a full-time position in Information Technology, aiming to collaborate with a forward-thinking organization to leverage my skills for mutual growth and innovation.Feel free to connect, and let\'s explore the possibilities that data and technology offer together.
Experience
Associate - Projects
Sep 2022 — Present · Kolkata, IN
Project Summary:Implemented end-to-end data conversion and integration project, transforming legacy XML files into a format compatible with Duck Creek insurance software. Collaborated with business analysts, customers, and development teams to gather requirements, design solutions, and ensure successful data migration.Developed and maintained ETL pipelines, databases, and data privacy solutions to facilitate data transformation and ensure data quality and security.Roles and Responsibilities: Led an end-to-end data integration project, converting legacy XML files into Duck Creek-compatible format, and achieved huge cost reduction by optimizing data mapping and eliminating manual processes. Collaborated with stakeholders to gather requirements and design ETL solutions, documented HLD and LLD, and performed POC. Developed robust ETL pipelines in Informatica, extracting data from diverse sources (XML, CSV, Oracle, MS SQL Server) and loading it into target databases, ensuring seamless data integration and adherence to business requirements. Designed databases, improving data retrieval efficiency by 20%, and created PL/SQL and T-SQL stored procedures for data transformation and validation. Ensured data protection through successful implementation of data masking and privacy solutions, maintaining a 100% data security record. Conducted data profiling to assess data quality and characteristics, utilizing tools like Informatica Data Quality for comprehensive assessment. Crafted Unix scripts to automate data manipulation tasks, streamlining job scheduling with 0% error rate. Optimized ETL processes for efficiency and performance by 15% through code refactoring and parallel processing techniques. Ensured data reconciliation for data consistency and accuracy and implemented audit and error control mechanisms to automate ETL processes. Maintained detailed documentation and collaborated effectively with cross-functional teams to ensure project success.
Education
Institute Of Engineering and Management
Bachelor of Computer Application - BCA, Computer Science
Basirhat High School
Science
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.