Sr. SQL Server Developer

About Capgemini <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

With more than 170,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2014 global revenues of EUR 10.5 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.com/ .

 

Rightshore ® is a trademark belonging to Capgemini

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.

 

Sr. SQL Server Developer 

Develop solution outline and support requirements gathering for SSIS-Dashboard projects

Lead and perform high level and detailed design of the ETL-SSIS

Build and maintaining data warehouse or DataMart

Support technical designs and documentation

Develop ETL data load processes, components and interfaces as per the approved technical design

Perform unit testing of the application Key requirements for this position are:

Graduate with 3+ yrs of hands on working experience in SSIS,SSAS,SSRS

Proven background as an SSIS developer

Sound knowledge of framework and lifecycle SSIS projects

Solid working experience in MS SSIS,SSAS,SSRS,DB-Sql Server,Unix,Scheduling tools like Autosys,Control M

A solid understanding of SOA technologies, tools, and governance

A solid understanding of Data Quality Management (DQM) processes.

Understanding of aggregation, summarization and reporting data marts

Good knowledge in data warehousing concepts.

Strong written and oral communications skills. Prefer candidates with following skills and experience:

Financial services industry experience strongly preferred

 

Basic Technical Requirements

Skills required are SQL Server 2012 (Expert), SSIS and Other Database Migration Tools

At least 7 years experience in Business intelligence/Information Management Domain

At least 3 years experience in SSIS

Proven experience designing and implementing various SSIS projects

 

Location:-NYC,NY