Job Title: SSIS Developer
Candidate must be on our W2
Location: Irvine CA (Hybrid/Onsite)
Experience Required: 510 years
Job Type: FullTime
About Purple Drive Technologies:
At Purple Drive Technologies we specialize in providing comprehensive information technology services consulting and digital solutions tailored for enterprises and system integrators. Headquartered in Irvine California with a base in India we pride ourselves on building effective teams through proven efficiencies.
Required Technical Skills:
Primary Skills:
- Strong experience in designing developing and deploying ETL solutions using SQL Server Integration Services (SSIS).
- Proficiency in writing complex SQL queries stored procedures and performance tuning in MS SQL Server.
- Expertise in building and maintaining data pipelines data integration workflows and data migration solutions.
- Experience in handling large datasets and implementing data transformations aggregations and cleansing operations in SSIS.
- Knowledge of data warehousing concepts including star and snowflake schemas.
Secondary Skills:
- Familiarity with SSRS (SQL Server Reporting Services) for creating reports and dashboards.
- Experience with Power BI or other visualization tools for data presentation.
- Knowledge of Azure Data Factory and its integration with SSIS for hybrid data solutions.
- Exposure to DevOps practices for ETL development including version control and CI/CD pipelines.
- Understanding of data security governance and compliance in ETL processes.
SQL,tensor,Power BI,ETL,Python,NoSQL