Data Integration Lead

Data Integration Lead Location: Alpharetta, Georgia Fulltime Permanent Role Skills: SSIS-SQL Server Integ Services, Abinitio, Alteryx,BI - Oracle Data Integrator, BI - Oracle Warehouse Builder, BI - SAP Hana, BI -Oracle BI Enterprise Edi, Collibra, Composite Information Server, Data Modeling, Denodo, ERWin/ERStudio/Rational, Greenplum, IBM - Quality Stage, IBM DataStage,IDQ-Informatica-DataQualityMgt,Informatica,Informatica Metadata Manager, Netezza, Pentaho,S AP BPC,SAP Business Warehouse/HANA,SAP Busn Obj Data Servi/Integr, SSAS-SQL Server Analysis Serv, SSIS-SQL Server Integ Services, Talend, Teradata, IBM DataStage, Pentaho, SAP Busn Obj Data Servi/Integr, SSAS-SQL Server Analysis Serv, Talend Job Description: Primary Responsibilities Develop, design, tune and maintain SSIS packages to perform the ETL process. Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process. Write scripts for automated testing of data in the target facts and dimensions. Capture audit information during all phases of the ETL process. Write and maintain documentation of the ETL processes via process flow diagrams. Collaborate with business users, support team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse. Secondary Responsibilities Design, build and deploy reports in SQL Server Reporting Services (SSRS). Should be good in SSAS and MDX Skills and Experience

• 8-10 years of experience using Microsoft SQL Server Database, SSIS , SSRS,SSAS is required with the development of database/data warehouse/data mart solutions
• 8 + Years of Strong SSIS 2016 and SQL 2016 Development & support experience.
• Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies,
• Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements
• Will be expected to mentor colleagues and be proactive in developing colleague skill .
• Must be flexible to new situations and challenges
• Good time management skills
• Problem solving skills are required.
• Candidate should be willing to work on extended overlap hours and weekends based on the client needs
• Strong Communication Skills