Description

Job Description:

  • Minimum of 6 years of experience with SSIS, SQL Server, and ETL processes.
  • Analyze and document the existing SSIS packages, including data sources, destinations, transformations, and control flows.
  • Create detailed documentation outlining package functionalities, dependencies, and schedules.
  • Document the current state of SQL Server databases, including schema, tables, views, stored procedures, and functions.
  • Capture metadata and data lineage for critical datasets and data flows within the databases.
  • Review and document existing SSRS reports, detailing data sources, datasets, report layouts, and expressions.
  • Maintain an inventory of all SSRS reports, including usage and access control information.
  • Strong SQL programming skills and experience with database design and data modeling.
  • Familiarity with cloud data platforms and services, particularly AWS and Snowflake.
  • Excellent analytical, problem-solving, and communication skills.
  • Ability to work independently and collaboratively in a fast-paced environment.
  • Experience with other ETL tools and data integration platforms is a plus