at Capgemini America, Inc. in Chicago, Illinois, United States
Job Description
Capgemini America, Inc. (Sogeti division) seeks IT professionals to fill multiple positions in Chicago, IL and various unanticipated sites throughout the U.S. Entry through Sr. level positions available.
Duties: Design and develop ETL framework using SSIS, Azure Data Factory. Prepare Impact Analysis documents based on Business requirement to identify gaps to help in timeline estimation. Design and develop Data Storage and Processing layers using Azure Data Lake Store, Azure Data Warehouse, Azure Databricks, COSMOS, and T-SQL. Design and develop Data Presentation layer using Multi-Dimensional, Tabular Model (SSAS). Design and develop Data Visualization dashboards using SSRS, Power BI. Design, develop, and automate unit integration testing scripts using SCOPE, T-SQL, U-SQL, Spark-SQL etc. Design and manage monitoring Azure VMs, Services. Troubleshoot and performance improvement analysis on Azure VMs and services. Enable code maintenance and deployment through GIT; and update sprint work items progress in Visual Studio Online (VSO) for visibility. Utilize experience with Databases: SQL Server, TSQL, SQL Server database administration; Big Data Technology: Cosmos, Azure Storage, Azure Service Bus; Cloud: Azure web and worker roles, data storage, service bus; Services and Support Tools: Windows services, server and service monitoring; OLAP Tools: SQL Server Analysis Services, SQL Data warehouse, Azure Data Lake; and Version Control Tools: GIT.
