Software Engineer
SATHISH SELVARAJ
Informatica ETL Developer
Chennai,TN
2
Languages
2
Certification
5
Years of experience
Detail-oriented Data/ETL Engineer with 4+ years of experience in building cloud data integration pipelines with Informatica IDMC and PowerCenter. Skilled in designing mappings, optimizing SQL queries, and integrating with Snowflake. Experienced in CI/CD-driven Agile environments using Git, Bitbucket, and Jenkins. Committed to delivering technical documentation and fostering collaboration between business and engineering teams.
Work History
NCI Aftersales Data Mart
2 Years 11 Months- Designed and built Informatica IDMC (IICS) mappings, mapping tasks, and taskflows for Nissan's North America Aftersales Data Mart, enhancing data integration through comprehensive analysis, design, development, testing, and production support.
- Wrote and optimized complex SQL queries and stored procedures for SCD 1/2/3 mappings and source-to-target data transformation logic; integrated IDMC pipelines with Snowflake.
- Owned data modeling and performance tuning across dev, test, and production using Git/Bitbucket and Jenkins CI/CD; led code reviews and daily Scrum/JIRA delivery with the customer.
- Client: Nissan
- Organization: Tech Mahindra
- Tools: Informatica IDMC (IICS), PowerCenter 10.5, Snowflake, SQL, Unix, AWS S3, Git/Bitbucket, Jenkins, GitHub, JIRA
PowerCenter to IDMC Migration
7 Months- Migrated on-premises Informatica PowerCenter applications to Informatica IDMC (IICS) cloud, designing and developing end-to-end data integration solutions loading structured and semi-structured data into Snowflake.
- Built and optimized IICS ETL pipelines using AWS S3 and Snowflake as source/target; validated data transformations and business logic against downstream and end-user requirements to ensure accuracy.
- Led production deployment, overseeing implementation plans, change tickets, and cutover activities; ensured data integrity and system stability through post-production support.
- Coordinated unit, STG, and UAT testing with business users for sign-off; utilized Agile methodology in JIRA for effective sprint planning and issue tracking.
- Client: Nissan North America Inc.
- Organization: Tech Mahindra
- Tools: Informatica IDMC (IICS), PowerCenter, Snowflake, AWS S3, JIRA
NCI Aftersales Run the Business
1 Year 1 Month- Monitored and supported Informatica IDMC (IICS) ETL workflows via Control-M, resolving load failures and performance issues to maintain operational efficiency.
- Built Snowflake integrations using Streams and Snowpipe for continuous data loading, and wrote SQL-based stored procedures for transformation logic.
- Managed incident, service request, and change tickets through ServiceNow, implementing root cause analysis and preventive measures for recurring issues.
- Client: Nissan
- Organization: Tech Mahindra
- Tools: Informatica IDMC (IICS), AWS S3, Snowflake (Streams, Snowpipe, Stored Procedures), Git/Bitbucket, Jenkins, GitHub
Education
Bachelor of Engineering
Skills
Data integration
Advanced SQL
Snowflake optimization
Data modeling
CI/CD & Version Control: Git
Bitbucket
Jenkins
GitHub
Cloud Platform: AWS (S3)
Scripting Language: UNIX
Scheduling tools
Personal Information
Title: Data Engineer | Informatica IDMC / IICS | Snowflake | SQL
Certification
SnowPro Core Certification – Snowflake, AWS Certified Cloud Practitioner – Foundational – AWS
Languages
English
B2
Upper Intermediate
Tamil
C2
Proficient
Timeline
NCI Aftersales Data Mart
Informatica ETL Developer
11.2023 - CurrentRead More
PowerCenter to IDMC Migration
IICS and Snowflake Developer
04.2023 - 11.2023Read More
NCI Aftersales Run the Business
RTB Informatica
03.2022 - 04.2023Read More
Sri Ramakrishna Institute of Technology (SRIT)
Bachelor of Engineering
01.2021Read More