What are the responsibilities and job description for the SSIS Developer with AWS position at Logix Guru?
ob Title: SSIS Developer with AWS
Location: Pittsburgh PA
Job type: 6 months Contract
Banking domain Preferred
Job Summar
yWe are seeking a highly skilled and hands-on SSIS with AWS experience to join our team onsite in either Pittsburgh . The ideal candidate will have strong expertise in SQL development, ETL processes using SSIS, and dashboard/report development using Power BI. Experience working with financial data and cloud environments, particularly AWS, is highly preferred
.Required Experienc
- e5–10 years of experience in SQL development, SSIS, and Power B
- IStrong experience designing and developing ETL workflows using SSI
- SAdvanced SQL skills including stored procedures, performance tuning, and data modelin
- gExpertise in creating interactive dashboards and reports in Power B
- IExperience integrating and transforming data from multiple data source
- sHands-on experience with AWS services and cloud-based data solution
- sStrong troubleshooting and analytical skill
- sAbility to work independently in an onsite environmen
tPreferred Qualification
- sExperience working with financial or banking dat
- aKnowledge of data warehousing concepts and best practice
- sFamiliarity with AWS services such as S3, Redshift, RDS, Lambda, or Glu
- eExperience with data governance and reporting standard
sKey Responsibilitie
- sDesign, develop, and maintain SSIS packages and ETL pipeline
- sDevelop and optimize SQL queries, stored procedures, and database solution
- sBuild and maintain Power BI dashboards, reports, and visualization
- sWork with business stakeholders to gather reporting and analytics requirement
- sManage data integration across on-premise and AWS cloud environment
- sEnsure data accuracy, integrity, and performance optimizatio
- nSupport ongoing enhancements and troubleshooting activitie