Thirunavukkarasu Saminathan

• Worked in Macys Merchandising Pricing & Enterprise Data Warehouse applications.
• Bulk loading from OnPrem Teradata to Google Cloud bucket using scripts and loading them to BigQuery tables.
• Contributed to the design and development of Datawarehousing solutions including data modelling and ETL processes.
• Developed custom algorithms for advanced analytics, driving actionable insights from large datasets.
• Used CI/CD pipelines for continuous data ingestion from the cloud bucket.
• Writing Source and Target level validations fo the SCD - Slowly Changing Dimension tables.
• Performed data quality analysis using Dataplex by building scripts on BigQuery Tables/Views and integrated to the BQ console.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.

Macys Technology -

Genuine Parts Company (NAPA) - NAPA Digital NXP

• Expertise in identifying and analyzing the business need of the end-users and building the project plan to translate the functional requirements into the technical task that guide the execution of the project.
• Served as a liaison between third-party vendors, business owners, and the technical team.
• Proven ability in communicating highly technical content to non-technical people.
• Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS, and Mart.
• Involved in Design, analysis, Implementation, Testing, and support of ETL processes for Stage, ODS, and Mart.
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from diverse sources such as source flat files and oracle tables to target tables.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.
• Developed reusable Mapplets and Transformations. Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times. Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Involved in writing procedures, functions in PL/SQL
• Developed comprehensive ETL processes for accurate and efficient data extraction, transformation, and loading.

Target Corporation - Up Stream DC, Mainframe modernization of Retail Finance

• Conducted extensive gap analyses to identify areas for improvement in current processes, ultimately increasing efficiency and reliability of the entire system.
• Developed comprehensive ETL processes for accurate and efficient data extraction, transformation, and loading.
• Enhanced query execution times for faster reporting by optimizing SQL code and utilizing stored procedures.
• Performed regular audits of user access permissions, ensuring that only authorized individuals had access to sensitive information within the warehouse environment.
• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

Target Corporation - Multi Channel Inventory Management(MCIM)

• Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.
• Performed thorough testing on data integration projects to ensure accurate results.
• Collaborated closely with development teams to ensure seamless integration of ETL components, resulting in accurate and efficient data processing.