Module Lead - SSIS Developer Job

6-8 Years

• Should have 6+ yrs of experience in SSIS, and SQL.

  Experience in developing the complex Data flows and transformations in SSIS from different source and destination systems.
  Experience in deploying SSIS experience and scheduling the SQL Jobs.
  Experience in Writing complex SQL queries and in performance tuning of query execution.
  ETL - Should be proficient in MS SSIS and strong SQL / PLSQL scripting
  Should have data migration experience from on-prim tool to cloud or another on-prim
  Experience on any ETL tool will be advantage
  Should be an expert in writing stored procedures, functions, and inline SQL Queries using T-SQL
  Should have good hands-on experience working with SQL Server ,Oracle and My SQL
  Should have expertise in Microsoft Business Intelligence Suite - SSIS, SSRS, SSAS, Power BI.

  Responsibilities:
  Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements
  Create and maintain documentation of ETL processes, including data mappings, transformations, and workflows.
  Test and debug ETL processes to ensure accuracy and completeness of data.
  Participate in code reviews to ensure code quality and adherence to best practices.
  Work with data analysts to understand data sources and ensure data quality and consistency.
  Troubleshoot and resolve issues related to ETL processes.
  Assist with deployment and monitoring of ETL processes.
  Work with clients to understand business requirements and ensure the required business functionality of each data element is met
  Interpret and analyze multi-dimensional medical, provider, pharmacy claims data as well as enrollment data to accurately assess and demonstrate key insights into key trends and opportunities
  Hands-on experience in Agile methodology