Extract Transfer Load Data Jobs in Trumbull, CT (NOW HIRING)

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

ETL Development and Architecture

Greenwich, CT

3 Years contract

Need GC and USC

Top Three Skills:

1. ETL Development and Architecture expertise leveraging SSIS on a SQL Server platform. (SSIS is a must have) Any knowledge of other ETL tools would be a plus as well.

2. Hedge Fund/Financials work experience, understanding of investment data and terminology from the Buy Side*.

3. Business facing with excellent communication and the ability to gather complex requirements from various teams across the organization.

4. Attribution Analysis and Asset Allocation expertise in prior projects will be a major plus within this organization.

Job Description:

The Information Technology Group of AQR Capital Management is seeking an experienced Data Warehouse and Business Intelligence professional to help the firm expand its use of data and BI tools to meet corporate goals and objectives. The individual will be providing optimal DW/ETL architecture and design for the enterprise DW environment. This includes gathering requirements, designing, working with the BI team and rolling solutions to end users. This individual will act as an advocate of DW/ETL best practices. Candidate must have effective communication skills and the ability to interact professionally within a diverse group of staff and user community. Candidate must be able to work productively in teams and to mentor or instruct others while effectively prioritizing their own tasks. Successful candidates will have great technology and problem solving skills, a solid work ethic, and an eagerness to learn in a highly intellectual, collaborative environment.

ROLE

Responsible for leading the strategic design and maintenance of Data Warehouse and ETL platforms.

Direct, organize, and lead projects in the implementation and use of ETL software tools and systems.

Design, code, test, and document all new or modified ETL processes, applications, and programs.

Manage the design, development, architecture, and delivery of all AQR internal and external reports.

Assist in the design of BI solutions to ensure interoperability with DW/ETL solutions.

Assist in analyzing user requirements and, based on findings, design ETL processes based on the functional specifications.

Adhere to best practices in change control and documentation.

REQUIREMENTS

8+ years of hands-on experience with DW/ETL processes, data architecture and business requirements gathering/analysis.

Expert knowledge of one ETL tool (Informatica, SSIS, Ab Initio etc.) - preferably SSIS

Sound knowledge of data warehouse methodologies.

Sound knowledge of data warehouse design methodologies (Kimball, Inmon etc.)

Strong SQL skills.

Good understanding of financial markets and products.

Direct experience in implementing enterprise DW/ETL processes and decision support.

Strong ability to analyze user requirements and build DW/ETL processes to specifications.

Direct hands-on experience with ad hoc query programs and reporting software.

OPTIONAL (Nice to Have)

Knowledge of data mining and predictive analysis

Understanding of .Net (C#) and/or Java

Understanding of fund structures and strategies.

If you are interested please share your resume to preethib@usmsystems(dot)com or can directly call me on 703 468 0398