Overview
Skills
Job Details
Note: Need Only , Who can work on W2 or 1099.
Position: SSIS ETL Architect/Lead Location: Jacksonville, FL - (Onsite) Duration: Long Term Contract
Job Summary:
Have 15 years of experience in design, develop SSIS packages
Have experience using AI tools
Should have experience writing stored procedures and views
Can lead offshore team
Take complete responsibility of project delivery.
Have very good understanding of data and good analytical skillset
Key Responsibilities: Architecture & Design: Design end-to-end ETL/data warehouse architecture, create data models (SQL Server/ other DBs), and define standards for data integration.
SSIS Development: Develop complex SSIS packages with error handling, logging, transformations (Derived Columns, Conditional Splits), and dynamic package execution.
Data Sourcing: Extract data from diverse sources (flat files, Oracle, legacy systems) and load into SQL Server/Data Warehouses.
Leadership: Mentor junior developers, lead technical discussions, provide single point of contact, and manage team strategy.
Performance & Optimization: Tune SQL queries, optimize indexes, manage database backups, and ensure efficient data flow.
Collaboration: Work with Business Analysts, DBAs, and stakeholders to gather requirements and explain discrepancies.
Documentation: Maintain technical specs, solution designs, and ETL process documentation.
Thanks & Regards
Mahesh