Jayabrata Sinha

Jayabrata Sinha Data Engineer | Teradata India Pvt. Ltd. | Ex-Capgemini Kolkata | - |-| LinkedIn Professional Synopsis Skilled in designing and implementing efficient data integration solutions, optimizing data processes, and ensuring data quality. Proficient in leveraging ETL tools and technologies to extract, transform, and load data from various sources into data warehouses. Strong knowledge of DataStage and its components, including DataStage Enterprise, Data Quality, and Information Services. Proven track record of delivering high-quality solutions that meet business requirements and enhance operational efficiency. Experienced in working with large datasets, performing data analysis, and generating actionable insights. Committed to staying updated with the latest industry trends and technologies in the data engineering domain. A resultsoriented professional with more than 6.5 years of experience dedicated to driving business success through effective data management and analytics Professional Overview         Expertise in end-to-end implementation of IBM Infosphere Information Server suite, covering data warehousing, reporting, scripting languages, and databases. Proven track record of driving successful business rollouts in the Automobile & Banking domains, resulting in improved customer satisfaction and enhanced client experience. Extensive 6.5-year client-facing experience in IBM DataStage & Quality Stage v11.5 & v11.7, Information Services & Analyzer, Server Manager, and Infosphere Administrator Client. Effectively collaborating with clients to understand their requirements and deliver tailored solutions, ensuring seamless integration and optimal performance. Proven ability as an ETL & Data Quality developer and track lead, with deep knowledge of design fundamentals and expertise in developing high-performance ETL applications using DataStage Enterprise. Result-oriented approach has consistently generated significant revenue for organizations. Actively involved in data quality analysis and profiling across diverse markets, delivering actionable insights and reports crucial to informed business decision-making. Ensured data integrity and accuracy, supporting companies in maintaining a competitive edge. Proficient in UNIX, Shell Scripting, JCL programming, Teradata SQL 14, and DB2, enabling seamless automation of complex data flows and interfaces. Implemented efficient data processing pipelines to optimize resource utilization and improve overall operational efficiency. Additional proficiency in Project Management tools such as Jira and RTC, Repository Management tools like UCD, GitHub, Jenkins and Scheduling applications including Crontab and Zeke. Facilitated and streamlined collaboration, version control, and efficient project execution. Successfully implemented multiple Proof of Concepts in IBM DataStage and Data Quality, highlighting the ability to apply innovative solutions and leverage cutting-edge technologies. Strong understanding of DataStage Administration & Web console ensured optimal system performance. Extensive experience in Agile and Waterfall methodologies within software development life cycles. Adapted seamlessly to different project environments, effectively managed project timelines, and delivered high-quality results while adhering to best practices. Relevant Work Experience Integrated Risk & Enterprise Single Name Data Mart | Client: Royal Bank of Canada | Duration: August ‘21–Till Date | Organization: Teradata Title Overview Integrated Risk Management RBC is a Data Warehousing project which has multiple data warehouses, used for Business Reporting, Regulatory Reporting, and many other aspects along with analytics power given by Teradata system to clients. It adheres data for all risk types, all types of business that are run by the Bank. Operating System Windows 7, Windows 10 Tools DS 11.5/11.7, Teradata 14, Unix, Mainframe, Zeke, On-Demand. Team Size 11 Role Technical System Analyst, Data Engineer, Developer - Responsibilities - Data Architecture & Design: Led end-to-end design and implementation of scalable data architectures, optimizing storage, retrieval, and analysis for enhanced performance. ETL Development & Integration: Developed complex ETL solutions using DataStage to seamlessly integrate and transform data across diverse systems and sources. Data Quality Assurance: Ensured data integrity and accuracy through comprehensive validation, profiling, and quality control measures. Performance Optimization: Identified and resolved performance bottlenecks, optimizing data processing speed and improving system efficiency. Stakeholder Collaboration: Collaborated with cross-functional teams, including data scientists, business analysts, and stakeholders, to understand requirements and deliver valuable insights. Process Optimization: Proactively identified areas for process improvement and implemented automation strategies, streamlining data engineering workflows and boosting efficiency. Technical Leadership: Mentored junior team members, fostering skill development, and creating a culture of continuous learning. Data Governance & Compliance: Implemented robust data governance frameworks, ensuring adherence to regulations, access controls, and data lifecycle management. Documentation & Communication: Prepared comprehensive technical documentation, facilitating project understanding and effective communication. Troubleshooting & Issue Resolution: Quickly identified and resolved data-related issues, ensuring minimal disruption to business operations. Agile Methodologies: Applied Agile methodologies, enabling iterative and efficient project execution while adapting to evolving requirements. Techno-Functional Expertise: Combined technical proficiency with domain knowledge, understanding the business context and providing value-added solutions. Global CDM Rollout | Client: Daimler AG | Duration: June ‘17–August’21| Organization: Capgemini Title Customer Data Management (CDM) The project involved implementation of Centralized Customer Data Management (CDM) to facilitate the journey from Commercial Centricity to Customer Centricity. Implementation of 3 CDM Components (IBM MDM, IBM IIS & IBM IIB). Implementing Data Quality Analysis & ETL of source data and creating a single authoritative using IBM MDM. Abstract Operatin g System Tools Windows 7, Windows 10 Team Size 8 Role Track Lead, ETL Developer, Data Analyst, DS Admin DS v11.5 suite, Unix, Shell Scripting, DB2, BMC Remedy - Responsibilities - Documentation: HLD, LLD, Project Plan Effort estimation and track planning based on functional requirement. Data Profiling of source data & preparing profiling reports & dashboards. Data Quality validations of key fields involved in match & merge in MDM. Extraction of source data, transformation using business specific logic & loading the data. Building custom, real time& batch transactional interfaces. Executing & Scheduling services through shell scripts in Linux. Deploying Services across environments including production. Tracking, Planning & fixing of production CRs & SIT/UAT defects. Monitoring Admin & Server health through WAS console. Production Support, Hyper care & incident management assistance. Performing server optimization and admin roles when the server is down. Organizational Highlights   Teradata India Pvt. Ltd. Duration: Aug ‘21 – Till Date Designation: Data Engineer  Capgemini Technology Services India Ltd. Duration: Dec ‘16 - Aug ‘21 Designation: Consultant Education Qualification School/College University/Board Year Stream/Degree Score Bachelor of Technology University of Engineering & Management, Jaipur UEM 2016 Civil Engineering 85.63 Percent 12th K.E Carmel School, Amtala ISC 2012 Science 70.00 Percent ICSE 2010 Meghmala Roy Education Centre 10th 77.20 Percent Certifications & Achievements    Certified Vantage 2.3 Associate as of February 2023 Awarded Silver Medal in College: Recognized for outstanding career achievements and academic performance, receiving a Silver Medal as a testament to excellence. Founding Member of E-Cell for National Entrepreneurship Network: Played a pivotal role as a founding member of the E-Cell, contributing to fostering an entrepreneurial ecosystem and promoting innovation. Passions and Pursuits  Motorcycling: I actively ride as part of a motorcycling club, raising awareness for road safety, combating drug abuse and engage in riding for humanitarian causes and social awareness initiatives. I contribute to raising awareness and making a positive impact in the community.  Thrill-Seeking Adventures: I enjoy engaging in adrenaline-pumping adventure sports, constantly challenging myself to push boundaries and embrace new experiences.  Cultural Exploration through Travel: Exploring diverse cultures and destinations broadens my perspective, fosters adaptability, and inspires creativity.  Fragrance Artistry: I delve into the art of perfumery, experimenting with scents and creating captivating fragrances that evoke emotions and captivate the senses.  Innovative and Creative Thinking: I nurture a passion for creativity, applying it to various pursuits such as writing, painting, and problem-solving, to bring fresh perspectives and unique solutions.