Rajkumar N Email & Phone Number

Puducherry, India

Chennai, Tamil Nadu, India

Data Engineer | GCP | Data Analytics BI/ETL-Bigquery-Jenkins-AtScaleExperience in Cloud (GCP), Configuration management, Infrastructure automation, Continuous Integration and Delivery (CI/CD).Expert in Setting up Continuous Integration (CI) by configuring Build, Code, Deploy and test automation Jobs in Jenkins for different applications and in creation and.

Chennai, Tamil Nadu, India

• Reverse Engineering Proficiency: Demonstrated expertise in reverse engineering tables from BigQuery, covering diverse subject areas and contributing to comprehensive data modeling
• Subject Area Expertise: Developed data models for intricate subject areas within the retail domain, including VENDOR DRILL, MY DRILL, SC DRILL, FINANCE CORE, and NURO, enhancing the overall understanding of data.
• Fact and Dimension Identification: Specialized in designing star schemas by skillfully determining fact and dimension tables. Fact tables, containing numerical measures and large volumes of transactional data, are.
• Collaborative Data Design: Collaborated with cross-functional teams to design and implement data models that met business requirements, ensuring alignment with organizational goals and objectives.
• Tool and Methodology: Utilized SQLDBM for reverse engineering from BigQuery, employing a methodical approach to ensure accurate and insightful data models.
• Complex Table Analysis: Conducted in-depth analysis of over 500 complex tables, extracting crucial join condition and also getting the column names from complex subquiries for the purpose of linking the tables while.

Chennai, Tamil Nadu, India

• Schema Design and Implementation: Designed and implemented database schemas tailored to the requirements of the retail project, ensuring optimal data organization and retrieval.
• Dataset Creation: Created comprehensive datasets to facilitate efficient data storage and retrieval, aligning with project objectives and industry best practices.
• Table Development: Developed tables to capture and store relevant retail data, adhering to normalization principles and ensuring data integrity.
• Advanced Joins: Implemented advanced join operations to connect and retrieve data from multiple tables, enhancing the depth and breadth of analytical insights.
• Complex Subqueries: Employed complex subqueries to address specific project requirements, optimizing data extraction and analysis for improved decision-making.
• Alias Usage: Utilized aliasing techniques to enhance query readability and simplify complex SQL statements, promoting maintainability and collaboration.

Chennai, Tamil Nadu, India

• Stored Procedures: Contributed in developing and implementing stored procedures, streamlining data processing for efficient information retrieval and management.
• Views and Functions: Contributed to the creation of database views and implemented functions, enhancing data accessibility and modular code structures.
• Trigger Logic: Worked on trigger development, gaining exposure to logic implementation that automatically responds to predefined events.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering

Higher Secondary, Biology, 11Th-12Th Standard

Sslc, 1St- 10Th Standard