ETL SSIS Developer
Anveta, St Louis, MO, United States
ETL SSIS Developer (W2 Position)
Location: St louis, MO (Weekly 3 days onsite)
Duration : 6+ Months
Job Description :
Need 8 years of experience as a ETL SSIS Developer
ETL Development: Design, develop, and maintain ETL workflows using SSIS to extract, transform, and load data.
Data Integration: Integrate data from multiple sources (databases, flat files, APIs, cloud services) into SQL Server.
Performance Optimization: Tune ETL packages for efficiency, scalability, and reliability.
Data Quality & Validation: Implement checks to ensure accuracy, consistency, and completeness of data.
Automation: Schedule and monitor ETL jobs, ensuring timely data availability.
Collaboration: Work with data analysts, BI developers, and business stakeholders to gather requirements and deliver solutions.
Documentation & Support: Maintain technical documentation and provide support for ETL processes.
Continuous Improvement: Enhance ETL frameworks, adopt best practices, and explore automation opportunities.
Required Skills
Strong expertise in SQL Server Integration Services (SSIS).
Proficiency in SQL (queries, stored procedures, triggers, views).
Experience with data warehousing concepts (star schema, snowflake schema).
Knowledge of ETL best practices and performance tuning.
Familiarity with SSRS/SSAS and BI tools (Power BI, Tableau) is a plus.
Understanding of cloud data platforms (Azure Data Factory, AWS Glue) is desirable.
Soft Skills:
Strong analytical and problem-solving abilities.
Effective communication with technical and non-technical stakeholders.
Ability to work independently and in agile teams.
Please share profile's to sudheer@anveta.com
Location: St louis, MO (Weekly 3 days onsite)
Duration : 6+ Months
Job Description :
Need 8 years of experience as a ETL SSIS Developer
ETL Development: Design, develop, and maintain ETL workflows using SSIS to extract, transform, and load data.
Data Integration: Integrate data from multiple sources (databases, flat files, APIs, cloud services) into SQL Server.
Performance Optimization: Tune ETL packages for efficiency, scalability, and reliability.
Data Quality & Validation: Implement checks to ensure accuracy, consistency, and completeness of data.
Automation: Schedule and monitor ETL jobs, ensuring timely data availability.
Collaboration: Work with data analysts, BI developers, and business stakeholders to gather requirements and deliver solutions.
Documentation & Support: Maintain technical documentation and provide support for ETL processes.
Continuous Improvement: Enhance ETL frameworks, adopt best practices, and explore automation opportunities.
Required Skills
Strong expertise in SQL Server Integration Services (SSIS).
Proficiency in SQL (queries, stored procedures, triggers, views).
Experience with data warehousing concepts (star schema, snowflake schema).
Knowledge of ETL best practices and performance tuning.
Familiarity with SSRS/SSAS and BI tools (Power BI, Tableau) is a plus.
Understanding of cloud data platforms (Azure Data Factory, AWS Glue) is desirable.
Soft Skills:
Strong analytical and problem-solving abilities.
Effective communication with technical and non-technical stakeholders.
Ability to work independently and in agile teams.
Please share profile's to sudheer@anveta.com