·Designing, developing, and maintaining ETL process using SQL server Integration services (SSIS).
·Extracting data from various data sources, transforming, and loading it into target systems.
·Ensuring data quality, integrity, and consistency across different systems.
·Developing and maintaining data warehouses, data lakes and data mart architecture.
·Optimizing ETL processes for performance, scalability and reliability.
·Troubleshooting and resolving data integration issues.
·Experience in migration SSIS jobs to Teradata pipeline/jobs.
·Performance tuning of SQL queries.
6+ years
·Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
·Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.
·Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.
·
SSIS ETL Developer • Seattle, WA