• SSIS Developer

    Insight Global (Sacramento, CA)


    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 [email protected] 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/.

     

    Skills and Requirements

     

    3-7 years of experience with SSIS and SQL server

     

    MS dynamics or salesforce experience

     

    Azure Synapse Analytic

     

    MS Azure Databricks

     

    Azure Data Factory Power Platform