Narayanan Viswanathan
Coimbatore
Summary
Results-driven Senior Analyst at HCL Technologies, specializing in the design and implementation of ETL processes with Informatica PowerCenter and IICS. Demonstrated expertise in data validation and performance tuning, ensuring optimal data integrity and system efficiency. Strong analytical capabilities paired with exceptional communication skills have consistently contributed to successful project outcomes in dynamic settings. Aiming to leverage technical proficiency and analytical insights to drive impactful data solutions.
Overview
6
6
years of professional experience
Work History
Associates-Projects
Cognizant Technology Solutions India Pvt.ltd.
11.2022 - Current
- Responsible on understanding the current on-prem setup and creating the data lineage in the excel/Cinchy
- Creating the IDC(Incoming data collection) and ODC(Outgoing data collection) of the setup as part of Project Architecture
- Updating the missed column and analysis on the data flow and updating the column mapping
- Creating the STTM(Source to Target Mapping sheet) Sheets
- Participating in daily standup calls and updating work completed
- Understanding the current On-prem SSIS Packages, Store procedures and implementing the logics by creating JSON’s and running the ADF pipelines where the complete JSON’s are tested in ADB on the cluster availability
- Creating the multiple Data frames for Data processing, Data transformation, Data writing within the JSON Code as per syntax
- Handling complete data validation task on the developed JSON’s
- In order to handover as part of migration process
- As Part of ETL Testing participated in Complete testing life cycle
- Done Data Validation, Spot checks, variance checks negative test case scenarios, Data type match and length match
- Created multiple testcase scenarios and Test plan for each Quarter and PI Planning
- Participated weekly Defect triage to prioritize bug fixes
- Participating in complete Agile ceremonies
- Working on FIX Stories based on the request
- Worked on the Ingestion required support
- Designed, Developed and Implemented ETL processes using IICS Data integration
- Created IICS connections using various cloud connectors in IICS administrator
- Installed and configured Windows Secure Agent register with IICS org
- Extensively used performance tuning techniques while loading data into Azure Synapse using IICS
- Extensively used cloud transformations - Aggregator, Expression, Filter, Joiner, Lookup (connected and unconnected), Rank, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations
- Extensively used cloud connectors Snowflake and SQL Server
- Developed Cloud integration parameterized mapping templates (DB, and table object parameterization) for Stage, Dimension (SCD Type1, SCD Type2, CDC and Incremental Load) and Fact load processes
- Extensively used Parameters (Input and IN/OUT parameters), Expression Macros and Source Partitioning Partitions
- Extensively used Push Down Optimization option to optimize processing
- Extracted data from Snowflake to push the data into Azure warehouse instance to support reporting requirements
- Performed loads into Snowflake instance using Snowflake connector in IICS for a separate project to support data analytics and Integrated different applications data using Informatica REST API
- Good hands on knowledge on application integration using Rest assured API
Senior Analyst
HCL Technologies Ltd.
09.2019 - 11.2022
- Responsible for designing and developing of mappings, mapplets, sessions and work flows to load the data from source to target database using Informatica Power Center
- Extracted data from legacy systems to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center
- Developed Mappings using various Transformations like lookup, Update Strategy, Aggregator, Router, Sequence generator, Expression
- Involved in ETL process from development to testing and production environments
- Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 10.2
- Creating effective Test data and development thorough unit test cases to ensure successful execution of the data
- Experience of handling Slowly Changing Dimensions to maintain the complete History
- Created new mappings and updating old mappings according to changes in Business Logic
- Fixing defects and Coordinating with testing team
- Preparing status report and discuss with Business and Technical lead in daily status call
- Creating Document related to Designs, Technical Specifications & Unit testing
- Participated in End to end testing in SIT env by doing Data validation and other negative test case scenarios as part of ETL testing
Education
Bachelor of Engineering - Electronics and communication engineering
SNS College of Technology
CoimbatoreHSC -
CMS Matriculation Higher Secondary School
CoimbatoreSSLC -
CMS Matriculation Higher Secondary School
CoimbatoreSkills
- ETL Tools: Informatica PowerCenter 102/104
- Informatica IICS
- ADF
- ADB
- SSIS
- Programming Languages: SQL
- PLSQL (Basics)
- Spark-sql
- Scheduling Tool: Informatica Native scheduler
- Control-M
- Databases: Oracle 11g
- 18C/19C
- MS SQL Server
- SSMS
- SSAS
- ADLS
- Snowflake
- Testing Tool: Jira
- Operating Systems: Windows 11
- UNIX
- Other Tools: Oracle SQL Developer
- MS SQL Server 2008 Management Studio
- MySQL
- JIRA
- Service Now
- Bit Bucket
Disclaimer
I hereby declare that the above-mentioned information is correct to the best of my knowledge and belief.
Timeline
Associates-Projects
Cognizant Technology Solutions India Pvt.ltd.
11.2022 - Current
Senior Analyst
HCL Technologies Ltd.
09.2019 - 11.2022
Bachelor of Engineering - Electronics and communication engineering
SNS College of Technology
HSC -
CMS Matriculation Higher Secondary School
SSLC -
CMS Matriculation Higher Secondary School
Similar Profiles
THUKKAIPRASANTH TTHUKKAIPRASANTH T
QA validation Engineer at Cognizant Technology Solutions India Pvt.LtdQA validation Engineer at Cognizant Technology Solutions India Pvt.Ltd
Roshan AngamuthuRoshan Angamuthu
Process Executive - Data at Cognizant Technology Solutions India Pvt.Ltd.Process Executive - Data at Cognizant Technology Solutions India Pvt.Ltd.
SWATHI B MSWATHI B M
Incident Manager at COGNIZANT TECHNOLOGY SOLUTIONS INDIA PVT.LTD.Incident Manager at COGNIZANT TECHNOLOGY SOLUTIONS INDIA PVT.LTD.
Surya Prakash ReddySurya Prakash Reddy
API Developer (CanadaLife) at Cognizant Technology Solutions India Pvt.ltd.API Developer (CanadaLife) at Cognizant Technology Solutions India Pvt.ltd.
Vibisha VVibisha V
Senior Design Consultant at Urban LadderSenior Design Consultant at Urban Ladder