Microsoft SQL Server Integration Services (SSIS) Application Developer

About Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services-all powered by the world's largest network of Advanced Technology and Intelligent Operations centers. Our 514,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at www.accenture.com
Accenture | Let there be change
We embrace change to create 360-degree value
www.accenture.com

• 
  
• Project Role :Application Developer
• Project Role Description :Design, build and configure applications to meet business process and application requirements.
• Management Level :10
• Work Experience :4-6 years
• Work location :Gurugram
• Must Have Skills :Microsoft SQL Server Integration Services (SSIS)
• Good To Have Skills :Microsoft SQL Server
• Job Requirements :
  • 
    
  • Key Responsibilities : Gather requirements for data pipeline connections Creation of new pipelines in StreamSetsMaintenance of StreamSets Hadoop SQL scripts Transformation ActivityWorking with Data Analyst to ensure proper support around data visualizationsManage permissions around Hadoop StreamSets accessResponsible for ongoing day to day management of the data analytic services platform StreamSets HadoopDaily review monitoring of successful pipeline integrations job zone refresh
    
  • Technical Experience : 8 years in-depth experience in working with a relational database system eg MSSQL, PostgreSQL 2 Highly knowledgeable in ETL/ELT processes, both design and implementation via SSIS or some other ELT/ETL tool 3 7 years in-depth experience in working with a data warehouse and knowledgeable on data warehouse modelling techniques 4 Good experience in building data pipelines that ingests various types of data sources into a database or data lake and populating a structured warehouse or data mart
    
  • Professional Attributes : Ability to learn fast Open to learn new tool
    
  • Educational Qualification : N/A
    
  • Additional Information : N/A

15 years of full time education