Key Responsibilities:

Design, develop, and deploy SSIS packages for ETL processes to support data migration, integration, and transformation.Write and optimize complex SQL queries, stored procedures, and functions for both SQL Server (T-SQL) and Oracle (PL/SQL).Work with Oracle databases to create PL/SQL procedures, triggers, and packages for back-end processing.Collaborate with analysts, data architects, and business users to understand data requirements.Perform data validation, cleansing, and quality checks.Monitor and troubleshoot ETL jobs using SQL Server Agent and Oracle Scheduler.Participate in performance tuning, indexing strategies, and database optimization efforts.Implement error handling and logging in SSIS packages for troubleshooting and auditing.Maintain documentation related to data flows, SSIS package structures, and database designs.

Required Skills & Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field.7+ years of hands-on experience with SSIS, SQL Server, and T-SQL.7+ years of experience in PL/SQL development in Oracle environments.Strong understanding of data warehousing, ETL best practices, and relational database concepts.Proficiency in using SQL Server Data Tools (SSDT) and Oracle SQL Developer.Experience in handling large datasets and optimizing data flow performance.Familiarity with version control systems such as Git or TFS.Excellent problem-solving and analytical skills.