Vengateswaran Arunachalam

Team Collaboration & Leadership:

• Worked closely with data scientists and ML engineers to ensure data quality for advanced analytics.
• Managed and mentored technical DATA team comprising data architects, modelers, and engineers.

Data Architecture & Management:

• Oversaw data source mapping, movement, interfaces, and analytics, with emphasis on data quality.
• Engaged in systems integration, addressed compatibility issues, and provided coaching and career development.

Snowflake Implementation & Optimization:

• Integrated Snowflake, streamlining storage and queries, resulting in 30% improvement in data retrieval.
• Led migration efforts to Snowflake with focus on data integrity and utilized its features for data sharing and warehouse management.

Performance & Automation:

• Enhanced SQL query performance in Snowflake through analysis and caching, improving execution times.
• Automated ETL pipelines for data ingestion into Snowflake and set up monitoring/alerts for efficient resource utilization.

• Support platform development team and perform activities to resolve developer issues in timely and accurate fashion
• Design existing Datawarehouse/Data marts in new stacks(Incorta, Snowflake, Spark, Python)
• Design reverse ETL with complex data model.

• Involved in Data Warehousing and worked extensively on RDBMS (Oracle, MS SQL) and ETL tools such as Informatica, Shell Scripting, and Python.
• Facilitated knowledge transfer sessions for new resources.
• Handled structured data projects ranging from 1-10 TB in size.
• Defined Informatica job flows and processes.
  Gained expertise with Spark using Python.
• Managed loading data from UNIX file system to HDFS.

ETL & Data Management:

• Gathered client requirements for ETL objects and designed FTP data transfer jobs.
• Loaded data from LINUX file system to RDBMS using Informatica & Cron for automation.

Development & Scripting:

• Analyzed and transferred data to relational databases using Informatica & Python.
• Developed stored procedures and utilized BAPI and ABAP function calls in SAP.

Admin & Database Procedures:

• Administered repository with user logins and privilege assignments.
• Demonstrated expertise in writing and implementing PL/SQL procedures and functions.

SAP Integration:

• Employed mappings in Informatica leveraging BAPI and ABAP.
• Utilized Remote Functional Call (RFC) for inter-system communication.

Informatica Power Center Expertise:

• Utilized tools including Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed robust mappings using transformations like Filter, Expression, Sequence Generator, and more.

ETL Development:

• Translated high-level design specifications into ETL coding and mapping standards.
• Extracted data from flat files/RDBMS into staging and further populated onto Data Warehouse.

Procedural & Scripting:

• Designed procedures for data extraction across systems into Data Warehousing system.
• Created UNIX shell scripts to automate Informatica sessions.

System Configuration & Data Movement:

• Worked on loading data from various flat files to XML Targets.
• Installed and set up Informatica Client tools, developing ETL mappings for heterogeneous data feeds.