Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

STEPHEN SANTHOSH KUMAR RANGANATHAN

Dover,United States

Summary

Boasting 13 years of professional experience in the IT industry, I possess a vast array of progressive expertise in all facets of project development. This encompasses delivering project specifications, conducting design and analysis, managing development, documentation, coding, unit testing, SIT, UAT, and implementation. And also encompasses post-production support, with a particular focus on database management, reporting, data warehousing, and ETL design. Throughout my career, I have consistently applied these skills across various industry verticals.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Data Engineer

Cognizant
04.2021 - Current
  • Evaluate existing PowerCenter workflows, mappings, sessions, and transformations. Identify the complexity, dependencies, and scale of the current ETL processes.
  • Compare the capabilities of PowerCenter with IDMC to identify any gaps or limitations in functionality or performance. Analyze the differences between the on-premise and cloud solutions in terms of deployment, scalability, and maintenance.
  • Redesign the existing PC Mapping,Mapplet,sessions and workflows and build the pipeline according to IDMC's cloud architecture, ensuring that data flows and transformations remain consistent and optimized.
  • Worked with Snowflake, Postresql, SQL Server and Implement automated validation to ensure that migrated data is accurate and meets the expected data quality standards. Compare the results before and after migration to ensure data integrity.
  • Design integrations between IDMC and other cloud services or on-premise systems that the business is using. This may involve database connections, cloud storage (e.g., AWS S3).
  • Migrate the finalized ETL workflows to the production environment in IDMC, ensuring minimal disruption to existing business processes.
  • Monitor the migrated workflows for performance, errors, and failures. Utilize cloud-native monitoring tools to identify bottlenecks, failures, or inefficiencies.
  • Provide ongoing support for troubleshooting, maintaining, and enhancing the ETL pipelines in IDMC.

Data Analyst

Cognizant
01.2015 - 03.2020
  • Collaborate with business stakeholders, data engineers, and data architects to gather and document the data requirements for the cloud migration.
  • Conduct data profiling on the source systems to assess data quality, consistency, and any issues that may need attention before the migration. This helps to identify potential risks in the migration process.
  • Collaborate with ETL developers to design the extraction, transformation, and loading processes needed for the migration. This may involve helping to define the business rules for transformations, aggregations, or any data cleansing steps.
  • Validate that the data migrated to the cloud is accurate, complete, and adheres to the pre-defined transformation rules. This involves checking row counts, ensuring data consistency, and validating that business rules were correctly applied.
  • Track defects through the lifecycle, ensuring that they are prioritized and fixed in a timely manner. Perform regression testing after fixes to verify that the issue is resolved.

ETL Tester

Cognizant
07.2011 - 12.2015
  • Analyze ETL design specifications, mappings, transformation rules, and data models to understand how data is being processed and to create effective test cases.
  • Create an overall test plan for ETL testing and Develop detailed test cases that cover the all the scenarios of the ETL process.
  • Ensure that all transformations applied to the data, such as data cleansing, business rule implementation, data aggregation, and sorting, are functioning as expected. This may include validating calculations, filters, and other business logic.
  • Validate that the transformed data is correctly loaded into the target system, including ensuring data integrity, correct record mapping, and proper handling of primary/foreign keys and indexes.

Education

Bachelor of Science - Information Technology

Sathyabama University
Chennai, Tamil Nadu
05.2011

Skills

  • Snowflake Data Warehouse
  • Informatica Intelligent Cloud Service
  • PostgreSQL
  • Power BI
  • Teradata
  • SQL Server
  • UNIX
  • Snowpipe
  • Snow SQL
  • AWS S3

Certification

  • Snowflake SnowPro Core Certification(S0020837)
  • Power BI Data Analyst Certificate(83DBM4-6103C3)
  • Informatica Cloud Data Integration Modernization

Timeline

Data Engineer

Cognizant
04.2021 - Current

Data Analyst

Cognizant
01.2015 - 03.2020

ETL Tester

Cognizant
07.2011 - 12.2015

Bachelor of Science - Information Technology

Sathyabama University
STEPHEN SANTHOSH KUMAR RANGANATHAN