Tamilarasan Muthusamy
@tamilarasanmuthusamy
Experienced Data Engineer with a strong foundation in ETL and cloud computing.
What I'm looking for
With over 16 years of extensive experience in the IT industry, I have honed my skills as a Data Engineer, specializing in ETL processes, data integration, and cloud computing. My journey has taken me through diverse projects where I have successfully managed large volumes of data, ensuring quality and consistency through tools like Informatica PowerCenter and Informatica Intelligent Cloud Services. My expertise in Unix and Python has allowed me to automate workflows and enhance data processing efficiency.
Throughout my career, I have designed and implemented scalable data warehousing solutions using Snowflake and provided real-time data analysis with Google BigQuery. My proficiency in big data technologies such as PySpark and Hadoop has enabled me to tackle complex data challenges effectively. I am passionate about leveraging my skills to drive data-driven decision-making and contribute to innovative solutions in the tech industry.
Experience
Work history, roles, and key accomplishments
Data Engineer / ETL Specialist
USAA
Apr 2021 - Present (4 years 3 months)
Created Informatica PowerCenter mappings utilizing various transformations and tasks. Designed and implemented new mappings in Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud (IDMC) to streamline data processing. Optimized data pipelines by applying transformations such as aggregations, filters, and joins.
Data Engineer / ETL Specialist
Wipro Limited
Aug 2020 - Present (4 years 11 months)
Developed and maintained BigQuery for data extraction from Oracle and other source systems, performing analysis to fix production issues. Designed and developed Python & Unix scripts to automate operational tasks such as backups, data archiving, and monitoring. Created Informatica PowerCenter mappings utilizing various transformations and tasks.
Data Warehouse Specialist
TATA Consultancy Services Limited
Feb 2020 - Present (5 years 5 months)
Developed new features in BigQuery according to specification documents and optimized BigQuery scripts for data migration to Google Cloud Platform (GCP). Developed and managed SQL queries and PLSQL procedures to support project requirements. Monitored system health and metrics using Splunk, Dynatrace, and Akamai.
Data Warehouse Specialist
TATA Consultancy Services Limited
Oct 2018 - Present (6 years 9 months)
Developed Informatica PowerCenter mappings utilizing various transformations and optimized ETL processes using IICS for efficient data integration. Designed and developed Python & Unix scripts to automate operational tasks such as backups, data archiving, and monitoring. Automated MDM cloud deployments using GitLab CI/CD with AWS/Azure/GCP integration.
Web Developer
TATA Consultancy Services Limited
Jan 2018 - Present (7 years 6 months)
Developed and managed SQL queries and PLSQL procedures to support project requirements. Developed SSIS packages as per client requirements.
Computer Programmer
TATA Consultancy Services Limited
Feb 2017 - Present (8 years 5 months)
Created low-level design documents based on high-level design for DataStage and PL/SQL procedures. Analyzed, designed, and developed mappings/packages in DataStage per client specifications. Conducted performance tuning for DataStage mappings, including incremental aggregation and adjusting DTM buffer pool size and block size.
Computer Programmer
TATA Consultancy Services Limited
Jul 2013 - Present (12 years)
Developed low-level design documents based on high-level design for Informatica mappings and SSIS packages. Designed and developed mappings/packages in Informatica and SSIS based on client specifications. Conducted performance tuning for Informatica mappings, including incremental aggregation and adjusting DTM buffer pool and block sizes.
Technical Lead
TATA Consultancy Services Limited
Dec 2011 - Present (13 years 7 months)
Developed and modified Oracle and Unix scripts. Analyzed, designed, and developed Informatica mappings based on client specifications. Conducted extensive performance tuning of Informatica mappings, including incremental aggregation and adjustments to DTM buffer pool and block sizes.
Senior Developer
IBM India Pvt Ltd
Mar 2008 - Present (17 years 4 months)
Developed complex Informatica mappings using Aggregator, Union, and Update Strategy transformations to integrate data from multiple flat file sources. Performed performance tuning on mappings, including incremental aggregation and optimization of DTM buffer pool and block sizes. Developed and executed SQL queries and PLSQL procedures to support project requirements.
Developer
HSBC Software Development India Pvt Ltd
Dec 2006 - Present (18 years 7 months)
Developed SQL queries and PLSQL procedures for reports using DB2 SQL Assist and manual SQL scripting. Developed and optimized mappings using Informatica ETL tool based on client specifications. Optimized performance of long-running reports by analyzing tables and creating indexes.
Education
Degrees, certifications, and relevant coursework
Bharathiar University
Master of Computer Applications, Computer Applications
2002 - 2004
Completed a Master of Computer Applications degree, focusing on advanced topics in computer science and software development. Gained expertise in various programming languages, algorithms, and data structures.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Skills
Interested in hiring Tamilarasan?
You can contact Tamilarasan and 90k+ other talented remote workers on Himalayas.
Message TamilarasanFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
