ETL Architect

Company Description

A Few Words About Us Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.

Job Description

Position: ETL Architect

Location: NYC

Duration: 6 months

 

 

Job Description:

This opportunity is for individuals who have Hands-on experience in data warehouse design and development. The Role demands more than a typical ETL lead role as it interacts outwardly on projects with architects, PM's, OPS, data modelers, developers, admins, DBA's and testers. This is a hands-on delivery-focused role, and the individual will be responsible for technical delivery of data warehouse and data integration projects 


Must have skills

• 7-10 years Hands on experience with Informatica ETL in designing and developing ETL processes based on multiple sources using ETL tools

• Experience in Architecting end to end ETL solutions 

• Hands on UNIX experience. Scripting (e.g. shell, perl, alerts, cron, automation)

• Expert at all aspects of relational database design

• Experience working with engineering team with respect to database-related performance tuning, writing of complex SQL, indexing, etc.

Good to Have:

• Experience with IDQ, MDM, other ETL tools

• Experience with dashboard and report development

• Experience with financial services firms will be preferred


Additional Information

Kind Regards

 

Sachin Gaikwad

Technical Recruiter

Integrated Resources, Inc.

Direct Line : 732-429-1920