at Capgemini in Chicago, Illinois, United States
Job Description
Capgemini America,Inc. (Sogeti Division) has multiple positions, various levels in Chicago, ILand various, unanticipated sites throughout the U.S.
Job Title: Senior
Manager (Data Warehousing)
Job Location: 333 West Wacker Drive, Suite 300, Chicago,
IL 60606 and various, unanticipated sites throughout the U.S.
Job Type: Full Time
Duties: Design and
develop robust and scalable data models for data warehousing and data lake
solutions. Install and upgrade application tools and products on different
servers and apply patches. Create primary objects (tables, indexes, views) on
databases such as Teradata, Oracle, SQL Server. Perform performance tuning,
input/output tuning, and capacity planning. Design and develop ETL (Extract,
Transform & Load) solutions in Oracle PL/SQL, Informatica PowerCenter and
Azure Data Factory and Azure Databricks. Orchestrate and schedule ETL jobs on
tools such as Crontab, CA7 and Control-m. Develop scripts on UNIX/LINUX servers
using shell scripting. Deploy database changes, Informatica Powercenter objects
and UNIX scripts into production servers. Develop new packages/jobs on MS-SQL
Server Integration Services, MS-SQL Server Analytical Services and MS-SQL
Server Reporting Services. Design analytical reporting solutions on Enterprise
Reporting tools such as Business Objects, OBIEE, Tableau and PowerBI. Utilize
experience with ETL Tools: Informatica Powercenter; Reporting Tools: Business
Objects, OBIEE, Tableau; Databases: Teradata, Microsoft SQL Server, Oracle; Languages:
Shell Scripting, Oracle PL SQL; Operating Systems: Linux, MS-Windows; Version
Control Tools: Github, uDeploy, Artifactory; Services and Support Tools: Oracle
Data Warehouse Administration Console, CA7, Crontab.
Requirements: Employer will accept a Bachelor-s degree in Computer Science,
Engineering, Business or related field and 5 years of experience in the job
offered or Data Warehousing-related occupation.
Alternatively, employer will
accept a Master-s degree in Computer Science, Engineering, Business or related
field and 3 years of experience in the job offered or Data Warehousing-related
occupation.
Experience must include one year
of experience with each of the following skills:
1. ETL Tools: Informatica Powercenter
2. Reporting Tools: Business Objects, OBIEE, Tableau
3. Databases: Teradata, Microsoft SQL Server, Oracle
4. Languages: Shell Scripting, Oracle PL SQL
5. Operating Systems: Linux, MS-Windows
6. Version Control Tools: Github, uDeploy, Artifactory
7. Services and Support Tools: Oracle Data Warehouse AdministrationConsole, CA7, Crontab
Must be available to work on projects at
various, unanticipated locations throughout the United States.
638.9
Sogeti is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
