Technology Analyst | Business Intelligence - Integration | MSBI (SSIS)

Ipolarity LLC

Raleigh, NC

JOB DETAILS
SKILLS
Agile Programming Methodologies, Business Intelligence, DNA, Data Modeling, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Identify Issues, Microsoft SQL Server, On Call, Pager, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Query Optimization, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Snowflake Schema, Stored Procedures, Technology Analysis
LOCATION
Raleigh, NC
POSTED
3 days ago

POC: Sam Chavez

ATTENTION ALL SUPPLIERS!!!

READ BEFORE SUBMITTING:
UPDATED CONTACT NUMBER and EMAIL ID is a MANDATORY REQUEST from our client for all the submissions
We prioritize endorsing those with complete and accurate information
Avoid submitting duplicate profiles. We will Reject/Disqualify immediately.
Make sure that candidate's interview schedules are updated. Please inform the candidate to keep their lines open.
Please submit profiles within the max proposed rate.
Please make sure to TAG the profiles correctly if the candidate has WORKED FOR INFOSYS as a SUBCON or FTE.

MANDATORY: Please include in the resume the candidate s complete & updated contact information (Phone number, Email address and Skype ID) as well as a set of 5 interview timeslots over a 72-hour period after submitting the profile when the hiring managers could potentially reach to them. PROFILES WITHOUT THE REQUIRED DETAILS and TIME SLOTS will be REJECTED.

Job Title: Technology Analyst | Business Intelligence - Integration | MSBI (SSIS) Senior SSIS Developer
Work Location & Reporting Address: Raleigh, NC 27603 or any Infosys hub in the US (Onsite-Hybrid. Candidates willing to relocate to client s location or Infosys hub location will be considered)
Contract duration: 12
MAX VENDOR RATE: $80 per hour max
Target Start Date: 27 Jul 2026
Does this position require Visa independent candidates only? Yes

Must Have Skills:
Advanced SSIS
Advanced SQL

Nice to Have Skills:
Agile Knowledge

Detailed Job Description:
Designing and developing ETL pipelines using SQL and other technologies such as SSIS.
Writing and optimizing complex SQL queries for data transformation and loading into SQL Server/Snowflake.
Implementing data models in SQL server/Snowflake, including schema design and optimization.
Ensuring data quality, integrity, and consistency by implementing data validation and cleansing procedures.
Monitoring and troubleshooting ETL pipelines and SQL server/Snowflake data warehouse performance using monitoring tools.
Experience in production support handling an on-call pager with experience in troubleshooting & resolving issues/incidents.
Experience in performance tuning of existing SSIS packages & SQL code/stored procedures.

Minimum Years of Experience:
8+ years

Certifications Needed:

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

Interview Process (Is face to face required?)
Virtual

Any additional information you would like to share about the project specs/nature of work:

Project Code: Arch Re 2023 DNA HYD1STP

About the Company

I

Ipolarity LLC