Lead ETL Data Warehousing SQL (Azure)

Lead Etl Data Warehousing Sql (Azure) Location: Dallas, TX (Onsite) Only on W2 OR Own corporation Qualifications: 15+ years of experience in ETL & Data Warehousing Excellent leadership & communication skills In depth knowledge on SSIS ETL Tool and good working knowledge on Power BI Worked on data sources such as SAP and Salesforce Very good knowledge of SSIS (ETL Tool), StreamSets (ETL Tool), Azure Cloud, ADF, Azure Synapse Analytics & Azure Hub Events Executed at least 2 Azure Cloud Data Warehousing projects Worked at least 4 projects using Agile/SAFe methodology Demonstrated working knowledge on ITIL V4 concepts such as Incident Management, Problem Management, Change Management & Knowledge Management Working experience on any DevOps tools like GitHub, Jenkins, etc & on semi-structured data formats like JSON, Parquet and/or XML files & written complex SQL queries for data analysis and extraction In depth understanding on Data Warehousing, Data Analysis, Data Profiling, Data Quality & Data Mapping Cross global location experience and led a team of at least 15+ members in a global delivery model Experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions Responsibilities: Lead nearshore and offshore team to do production support of existing EDW, design, build & deploy enhancements and bug fixes to existing EDW Support the existing EDW system built using Azure SQL, Microsoft SSIS, StreamSets & Power BI Be on call to support job incidents on rotational basis Work with business and technology stakeholders to communicate EDW incidents/problems and manage their expectations Leverage ITIL concepts to circumvent incidents, manage problems and document knowledge Analyze the different source systems, profile data, understand, document & fix Data Quality issues Gather requirements and business process knowledge in order to transform the data in a way that is geared towards the needs of end users Write complex SQLs to extract & format source data for ETL/data pipeline Create design documents, Source to Target Mapping documents and any supporting documents needed for deployment/migration Design, Develop and Test ETL/Data pipelines Write Unit Test cases, execute Unit Testing and document Unit Test results Deploy ETL/Data pipelines Use DevOps tools to version, push/pull code and deploy across environments Support team during troubleshooting & debugging defects & bug fixes, business requests, environment migrations & other adhoc requests Maintain and improve already existing processes ETL - Strong SSIR, SSRS - Strong SQL - Strong Data Warehousing - Strong Azure, Azure data factory --Min exp Power BI - Min Exp Dash boards creation -- Strong Thanks & Regards Mohan sai Technical recruiter Phone# View phone number on click.appcast.io|View email address on click.appcast.io Software Technology, Inc Software Technology Inc