Data Analyst (Sql is Must)

company banner
Capgemini
data analyst,sql
Full Time, Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

 About Capgemini

 With almost 200,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2017 global revenues of USD 15.78 billion. Together with its clients, Capgemini creates and delivers business and technology solutions that fit their needs and drive the results they want. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model. Learn more about us at http://www.capgemini.comRightshore ® is a trademark belonging to Capgemini  

Title: Data Analyst (SQL is Must) 

Duties & Responsibilities: 

  • Over 3-6 years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in financial domain.
  • Over 2+years of experience in PL/SQL.
  • IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL Server databases
  • Proficient in Oracle SQL, PL/SQL; ability to write and understand Procedures, Functions, troubleshoot and performance tune procedures
  • Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing. 

Basic Technical Requirements 

  • Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files and XML files. 
  • Experience writing shell scripts on UNIX platforms. 
  • Extensively worked in ETL process consisting of Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Mapping, Conversion.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
  • Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts
  • Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.  

Desirable Skills: 

  • Informatica Power Center and Power Exchange experience is a plus.

Capgemini 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.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

 

Click the following link for more information on your rights as an Applicant: http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

 



Company Information

Global leader in consulting, technology, outsourcing, and local professional services. Capgemini is headquartered in Paris, France and operates in over 40 countries. We are, above all, a people company — 180,000 people worldwide. Read more: www.capgemini.com/about
Dice Id : KANBAY
Position Id : 213958

Similar Positions at Capgemini

PL/SQL Developer
  • Hartford, CT
  • 3 weeks ago
Business Analyst / Data Analyst
  • Charlotte, NC
  • 2 weeks ago
Enterprise Architect - EPM, OFSAA, FTP
  • Jersey City, NJ
  • 6 days ago
Data Modeler
  • Dallas, TX
  • 2 weeks ago
Data Engineer
  • Charlotte, NC
  • 4 weeks ago
Business Analyst (CCAR & Basel)
  • Tampa, FL
  • 4 days ago
Informatica Lead (Siebel OR Guidewire)
  • Woodland Hills, CA
  • 4 days ago