Manager (Data Warehousing Specialists)

Capgemini America, Inc. (Sogeti Division) has multiple positions, various levels in Chicago, IL and various, unanticipated sites throughout the U.S.

Job Title: Manager (Data Warehousing Specialists)

Job Location: 333 West Wacker Drive, Suite 300, Chicago, IL 60606 and various, unanticipated sites throughout the U.S.

Job Type: Full Time

Duties: Use expertise in the various data management and data engineering tools. Use expertise in Informatica Managed File Transfer, Informatica Data Engineering Integration, Informatica Enterprise Data Processing, Informatica Master Data Management, Informatica Big Data Quality, and Microsoft ADLS. Build and supervise Software Architectural standards - Software Application Development and Maintenance. Evaluate technical specifications to review solutions for new and existing functional requirements for clients. Convert business requirements into technical design for the developers. Involved in designing of ETL process to load the client-specific details in the database tables along with validating the data to help financial and risk analysis. Design and develop client’s enterprise software architecture. Build utility framework for file handling and file conversion process of difference source file formats. Build reusable components for project specific requirements. Utilize experience with Languages: UNIX Shell Scripting, SQL; Operating Systems: Windows; Services and Support Tools: MS Office 2010, Winscp, Informatica Master Data Management; Version Control Tools: GitHUB; Big Data Technology: Informatica Big Data Quality and Informatica Data Engineering Integration, Hive, HDFS; Databases: SQL Server; Data Wrangling: Informatica Enterprise Data Prep.

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 Specialist-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 Specialist-related occupation.

Experience must include one year of experience with each of the following skills:
Languages: UNIX Shell Scripting, SQL
Operating Systems: Windows
Services and Support Tools: MS Office 2010, Winscp, Informatica Master Data Management
Version Control Tools: GitHUB
Big Data Technology: Informatica Big Data Quality and Informatica Data Engineering Integration, Hive, HDFS
Databases: SQL Server
Data Wrangling: Informatica Enterprise Data Prep Must be available to work on projects at various, unanticipated locations throughout the United States.
742.3
500
For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #923