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: Complete complex BI ecosystems and design / develop solutions based on SQL, SSIS, Azure Databricks, Azure Data Factory, Azure Synapse,SQL SSAS. Design and develop PL /SQL procedures /ETL Jobs with optimized processing time. Communicate design, requirement, feature set, functionality, usability, and limitations of subsystem to team, development lead and manager. Design and code high quality database solutions within a fast-paced sprint release cycle. Create visualizations, reports, and dashboards based on business requirement. Develop Pyspark, Spark-SQL scripts in performing the Data cleaning and Data Transformation and deployed the notebooks on to the Data Factory enabling automation of pipelines.Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria. Create Technical Design Specification documentation that clearly articulates the design and code being implemented. Translate technical specifications into finished programs and systems and develop solutions to handle large volume data sets that are typical with BI Solutions. Assist in architectural design reviews and ensure technology stack selection is relevant. Utilize experience with Languages: VB.Net, C#, VBScript, SQL, PL/SQL; Data Analytic Tools: Power BI, Azure Synapse; Databases: SQL Server 2012, MySQL, MS Access and Microsoft Visio; ETL Tools: Data Marts, SSIS, SSRS and SSAS; Cloud: Azure Data Lake, Azure SQL,Azure Data Warehouse, Azure Data Bricks, Azure Data Factory.
