Job Description
Insight Globals client, a system integrator supporting a State of CA department is seeking to hire a SSIS Developer to support a MS Power Platforms modernization project. This developer will join an active program where the development and testing phases have already been completed and they are now entering the production phase. The developer will be responsible for running complex SQL queries and identifying and troubleshooting any errors along the way. This resource will need to have hands on experience creating and troubleshooting SSIS and be proficient in MS dynamics, salesforce, and power platforms.
• Develop and execute SSIS ETL loads
• Write and optimize complex SQL stored procedures
• Use Kingsway soft to migrate large datasets from SQL to Microsoft Dynamics 365 (Dataverse)
• Coordinate with internal teams to understand data requirements and objectives.
• Conduct data mapping, data transformation, and data validation.
• Ensure data integrity and quality throughout the migration process.
• Identify potential risks and develop mitigation plans.
pay range: $45-50/hr
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
3-7 years of experience with SSIS and SQL server
MS dynamics or salesforce experience
Azure Synapse Analytic
MS Azure Databricks
Azure Data Factory
Nice to Have Skills & Experience
Power Platform
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.