+1 844 678 44 27


Company : Optghar
Req/job Title : Sr. SSIS Developer
Job Ref No : 5985
Post Date : 07/06/2022
Country : USA
Job State/Province : Connecticut
Job City : milford
Experience : 1 - 9
OtherSkill :
Subject : Sr. SSIS Developer || Job Opening || Milford, CT
Description :

Job Description

  • 9+ years of rich experience in SQL SSIS with ETL and AWS cloud data and analytics space with solid understanding of Data warehousing product RedShift, ETL and SQL and 3+years with other ETL/Data integration tools and other Databases will be preferred.
  • 5+ years of experience in implementing cloud-based data lake/data warehouse technologies.
  • Must have experience working with high-volume data and building batch and near real-time ETL processes using AWS services such as Redshift.
  • Experience with AWS Redshift and Redshift Spectrum, AWS EMR, PySpark, Glue and Matillion,
  • Redshift Data warehouse experience
  • Lead data migration and integration efforts
  • Craft processes to ensure clean data
  • Prior experience with ETL tools like SSIS/Informatica and Databases like SQL server SSIS is required.
  • Experience working with RDBMS’s, SQL Server, Redshift, Snowflake, BigQuery, Teradata or Azure SQL -Data WarehouseExperience using Powershell and Python.
  • Prepare data for job runs. Support existing jobs. Solve, analyze and repair production issues. o Experience with S3 Object store and other Big Data storage platforms
  • Deep understanding of data mapping, data validation, data manipulation, data analysis use cases and Provide observations of the system and suggest automated steps to full-fill the business operations and the requirements.
  • 2+ years of experience with visualization tools (Power BI, Tableau or others) is an added advantage.
  • AWS Certified Big Data Specialty certification is a plus.