Spearheaded data extraction from multiple relational databases, legacy systems, and flat files into Oracle databases using Informatica Power Center, ensuring seamless data integration and transformation.Designed and maintained advanced ETL workflows leveraging Informatica Designer 10.1, incorporating diverse source systems such as Teradata, Oracle 10g, SQL Server, and flat files.Implemented robust data integration pipelines with SnapLogic, enhancing connectivity across varied data sources.Orchestrated end-to-end process scheduling using Autosys, establishing dependencies and file watchers for optimized workflow execution.Migrated critical data tables from on-premises (Netezza) to Snowflake, leveraging managed file processing (MFP) for efficient data handling.Employed Snowflake’s time travel and cloning features to streamline data management, ensuring high availability and data integrity.Utilized SnowSQL commands for comprehensive data operations, including GET, PUT, LIST, and COPY, contributing to dynamic ETL processes.Enhanced performance tuning through SQL query optimization and effective session configurations, boosting data processing efficiency.

Collaborated with business analysts to gather requirements and translate them into high-level (HLD) and low-level design (LLD) documents.Migrated existing data pipelines from Teradata to Snowflake, leveraging Snowsql and Informatica push-down optimization for enhanced performance.Developed and optimized Snowflake tables using strategic partitioning and clustering, ensuring efficient data retrieval.Implemented data staging with AWS S3 integration and utilized Snowflake Streams for effective change data capture (CDC) solutions.Managed data ingestion from varied sources, including Oracle, SQL Server, and Salesforce (SFDC), for comprehensive data integration.Monitored ETL performance and conducted performance tuning to optimize resource utilization and data processing.Supported a 24/7 production environment, providing timely on-call support and leveraging Unix shell scripting for job automation.

Led the design and development of data warehouse solutions, incorporating SCD Type 1 and Type 2 methodologies for flexible data management.Utilized Informatica Power Center to build and optimize complex ETL mappings, facilitating data transfer from varied sources to an enterprise data warehouse.Conducted extensive performance tuning for Teradata scripts using indexing, explain plans, and single AMP optimization techniques.Integrated and automated data pipelines to Snowflake, ensuring smooth data loading using bulk operations such as the COPY command.Managed data governance by participating in design discussions and conducting reviews with business analysts to establish optimal data mart designs.Devised and implemented error handling and audit mechanisms in ETL workflows, bolstering data reliability and traceability.Employed Fastload and Multiload utilities for efficient data population and handled pre-load data preparation with BTEQ scripting.

Leveraged Informatica Power Center client tools to develop scalable ETL mappings and workflows, ensuring data consistency across systems.Extracted and transformed data from relational databases, legacy systems, and flat files, employing extensive SQL query optimization for peak performance.Created reusable and non-reusable command tasks and workflows in Workflow Manager, promoting streamlined task execution.Contributed to comprehensive data profiling and cleansing efforts, enhancing data quality and reducing integration risks.Built parameter files and validation scripts for dynamic workflow execution, supporting agile and adaptable ETL processes.Conducted design reviews and collaborated with business stakeholders to produce proof-of-concept reports and detailed data marts using STAR schema designs.Maintained data governance standards and provided client guidance on test data management and best practices.