Tamilarasan Muthusamy - Data Engineer / ETL Specialist - USAA | Himalayas
Tamilarasan MuthusamyTM
Open to opportunities

Tamilarasan Muthusamy

@tamilarasanmuthusamy

Experienced Data Engineer with a strong foundation in ETL and cloud computing.

United States
Message

What I'm looking for

I am looking for a role that fosters innovation, encourages continuous learning, and values collaboration within a dynamic team environment.

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

US

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.

WL

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.

TL

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.

TL

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.

TL

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.

TL

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.

TL

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.

TL

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.

IL

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.

HL

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 logoBU

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.

Find 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!

Sign up
Himalayas profile for an example user named Frankie Sullivan