SCT-Tech Enablement-Data Integeration
ey
Job Description
- A minimum of 5+ years of experience into BI/Data integration/ETL/DWH solutions in cloud and on-premises platforms such as Informatica/ PC/IICS/Alteryx/Talend/ Azure Data Factory (ADF)/SSIS/SSAS/SSRS and experience on any reporting tool like Power BI, Tableau, OBIEE etc.
- Performing Data Analysis and Data Manipulation as per client requirements.
- Expert in Data Modelling to simplify business concepts.
- Create extensive ER Diagrams to help business in decision making.
- Working experience with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using data integration technologies
- Should be able to develop sophisticated workflows & macros (Batch, Iterative, etc.) in Alteryx with enterprise data.
- Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool
- Perform end-to-end Data validation to maintain accuracy of data sets.
- Support client needs by developing SSIS Packages in Visual Studio (version 2012 or higher) or Azure Data Factory (Extensive hands-on experience implementing data migration and data processing using Azure Data Factory).
- Support client needs by delivering Various Integrations with third party applications.
- Experience in pulling data from a variety of data source types using appropriate connection managers as per Client needs.
- Develop, Customize, Deploy, maintain SSIS packages as per client business requirements.
- Should have thorough knowledge in creating dynamic packages in Visual Studio with multiple concepts such as - reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment etc.
- Experience working with clients throughout various parts of implementation lifecycle.
- Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.
- Analysing and translating business needs into long-term solution data models.
- Evaluating existing Data Warehouses or Systems.
- Strong knowledge of database structure systems and data mining