Epicareer Might not Working Properly
Learn More
A

SQL SSIS Developer

Salary undisclosed

Apply on


Original
Simplified

SQL SSIS

Charlotte North Carolina (Hybrid role)

W2 Candidates ( with minimum validity of 12 months)

Must have: SQL-SSIS with ETL & Bigdata

At least four (4) years of that experience must have been in a lead capacity.

Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.
Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.

Proficient in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation

3 years of experience in the past 4 years in working with SQL database architecture, data modeling, normalization, and performance optimization.
3 years of experience in the past 4 years in working with Microsoft Azure Cloud platform, including familiarity with other Azure services like Azure Data Lake Storage, Azure Databricks, Azure Data Factory, and Azure DevOps.
3 years of experience in the past 4 years in working with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata
3 years of experience in the past 4 years in working with years of experience in big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka
3 years of experience in the past 4 years in working with data visualization tools like Power BI to create insightful visualizations and reports based on data stored in Synapse Data Warehouse.
3 years of experience in the past 4 years in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job