Job Ref: 13886 Print Job

MS SQL Server SSIS/T-SQL programmer

Adaps has been scouted to source Senior MS SQL Server SSIS programmer for one of our Large Insurance clients at Mel CBD

Purpose:
Provide SQL and SSIS expertise to project teams in the design and development of data extraction and transformation (ETL) processes.
Responsible for the design, build and run of data pipelines to efficiently move operational data from primary source systems to various targets and reporting platforms using SSIS and other related technologies

Responsibilities:

  • SSIS package development – including testing, configuration, automation, and operation.
  • Database Development: SQL, TSQL, unit testing, analysis, design, technical document writing, logical database design, physical data modelling, automation scripting, and performance tuning
  • Experience in data migration, cleansing, extracting and integrating across systems
  • Interacting with multi-platforms and languages; specifically – Microsoft/Azure stack, Dynamics CRM, DES, Oracle, C# .NET, XML
  • Formulation of SSIS source management guidelines and standards, and alignment with DevOps practices
  • Assess, select and integrate any data tools, components, and frameworks
  • Measure, evaluate, and performance tune pipeline performance.
  • Assist with production and operational support – defect resolution, session monitoring, data fixes, data quality issues, performance issues. Assist with project release preparatory planning.
  • Work collaboratively with other IT functions, business units, external contractors, consultants and vendors. Demonstrated interpersonal skills.
  • Understanding data and how it is used in target systems and business context
  • Compliance: Ensure that all the activities and deliverables comply with the requirements, coding standards, CLIENT policies, architectural principles, and current application design.
  • Timely delivery: Deliver tasks on the agreed delivery times and the quality.
  • Participate in identifying process, quality and system improvements, continuously learn new techniques, methodologies and technologies, look for and initiate improvement initiatives.
  • Record and report all the activities as instructed by management.
  • Optimising, debugged and maintained the load SSIS packages
  • Rotational L1, L2 and L3 on call 24x7x365 support for system. Must be flexible to work weekends & evenings and shift schedules as pertains to on call rotations
  • Other responsibilities as directed by the management

Qualifications

  • Tertiary qualification in an IT discipline
  • Relevant tertiary qualification at degree level
  • 3+ years’ experience in SSIS and related technologies

Ideal experience & delivered Performance

  • Microsoft Dynamics CRM, Azure/cloud technology, C# NET, DES,
  • Attunity, KingswaySoft Adaptor (KWS)
  • Oracle experience and skills

Highly desirable

  • Microsoft Dynamics CRM, Azure/cloud technology, C# NET, DES,
  • Attunity, KingswaySoft Adaptor (KWS)
  • Oracle experience and skills

Key Challenges:

  • Large Transformation Programmer – ability to work effectively across a large programme in various technologies (Oracle, SQL, Azure)
  • Mixed Technology landscape – Oracle/Cobol/.NET heritage systems with expansion into Microsoft, Azure and cloud
  • Communication – Effective use of communication channels in interactions with customers, vendors, management and team.
  • Picking up new skills and technologies

Key Relational-Internal

  • Database Team (DBA and Application Development)
  • CRM Platform Team
  • Testing Services
  • Business SMEs
  • Incident & Problem management team
  • Change Management Team

How to apply:
Please apply using the link below or call Ricky on 03 8506 6521 for further details. Applications closes based on the volume of applications received. Only short-listed candidates will be contacted.
Adaps is an equal opportunity employer that actively embraces diversity in its workforce through accurate community representation of gender, culture; thought and work arrangements.
Connect with Adaps:
Website: www.adaps.com.au