Soumodip Roy
Data Engineering & Governance Specialist
About
9 years of professional experience working on-site as well as offshore across multiple domains which sharpened my interpersonal, oral communication and ability to handle multiple tasks simultaneously. I enjoy contributing independently or in a team, with a strong analytical mind using a practical approach to critical problem solving and a drive to see things through to completion with good communication, positive attitude and logical thinking. Aiming to add ample value to your organization by leveraging my skill set.
Skills & Expertise (22)
Work Experience
Data Engineering & Governance Specialist
Accenture
Sep 2023 - Present
Extract client data spread across multiple source systems – Flat Files, Excel, Rest API, XMLs, JSONs, SQL Server, AWS S3 and consolidate in a single staging layer in Snowflake to perform all types of business rules. Build IICS ETL taskflows to load the cleaned & final business data to Salesforce. Designed and developed IICS mappings/taskflows to perform various calculations related to business applications. Collaborated with end users to identify needs and opportunities for improved data management and delivery and formulated long-term solutions. Expertise in SQL joins, Union, aggregations and RDBMS concepts. Actively took part in helping with the QA fixes on the delivered assets as per Jiras raised by client. Participated in the code-reconciliation cycles for cross-validation during delivery. Developed few time saving processes which sped up the overall validation process and was rewarded with appreciation from the client side.
Module Lead
Mindtree Ltd.
Jun 2021 - Sep 2023
Migration of code from PowerCenter to IICS using an internal utility designed by Informatica Corporation. Converted & validated mappings, data tasks and taskflows. Worked actively on maintaining query, mapping & taskflow logic between on-prem and cloud databases. On-prem database systems involved Teradata, SQL Server & Flat files. Cloud database involved Google Bigquery & flat files. As a Module Lead, got opportunities to groom new members in the team and provide walk through regarding the Migration Factory project specifics and end-to-end flow. Also, took part in providing internal Tech sessions.
Technical Specialist
Birlasoft Ltd.
Sep 2020 - May 2021
Data Integration among multiple source systems to achieve a final integrated solution for the demand and supply chain management. Extract, Transform and Load data into the target tables and flat files and vice versa using IICS for further analysis by downstream & upstream components. Designed and developed mappings and taskflows in IICS using source, joiner, filter, router, lookup, sorter, rank and aggregator transformations. Worked on File Listeners and Processes to automate taskflows. Have had exposure to simple batch scripting to copy, move and generate files as part of automated process and also for indirect file loads.
Senior Business Analyst
Ebix Software India Pvt. Ltd.
Aug 2019 - Sep 2020
Commissions & Incentives - Configuration of provision and payment system of Insurance Agents, Brokers, Individuals and others through ETL Process using IICS. Maintain, support, and enhance the business intelligence data backend, including data integration, data modelling and building ETL pipelines. Collaborate and work with end users to validate star and snowflake schema designs and data mining methodologies. Prepare HLD, LLD and ETL workflow documents. Involved in performance tuning, schema design, query optimization. Knowledge of Dimensional & Relational data models. Understanding of lookup caching and ability to program complex ETL mappings and PL/SQL packages. Maintained SCDs to preserve historical as well as latest data using Type I, Type II and Type III strategies in OLAP and OLTP systems.
Software Engineer
Tech Mahindra Ltd.
Dec 2016 - Jul 2019
Data Migration - Legacy data of Telecom client needed to be transformed and loaded into the Data warehouse using ETL pipelines, data modelling while maintaining proper hierarchy and consistency following best practices to ensure high data quality and reduced redundancy and optimum resource management. Analyzed source systems to identify, study and understand requirements and translate them into Informatica Power Center mappings for turning large amounts of data into meaningful and presentable information by influencing best practices by engaging in developing data dictionaries and data library. Performed incremental data load and complex data analytics using CDC concepts to maintain consistency among other components in relational database systems concurrently leveraging excellent organization and data management skill following the agile methodologies and CI/CD process.
Education
Bachelor of Technology - Narula Institute of Technology (WBUT)
2012 - 2016 · Afghanistan
ISC – 12TH - Vivekananda Mission School
2010 - 2012 · Afghanistan
ICSE – 10TH - Vivekananda Mission School
2009 - 2010 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Depends on Offer
Skills (22)
Click a skill to find developers with the same skill
