ETL Architect
At a glance
Mid-level Data Engineering role at Integrated Resources INC. New York · no salary stated · we estimate $130,000–$185,500.
Integrated Resources INC has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Design and build Informatica ETL processes that bring data in from multiple sources
- Shape end-to-end ETL solutions and deliver data warehouse and integration projects hands-on
- Work with architects, project managers, operations, modelers, developers, administrators, DBAs and testers
- Improve database performance with engineering teams through tuning, complex SQL and indexing
What you bring
- Seven to ten years of hands-on Informatica ETL design and development
- Practical UNIX skills, including scripting for automation, alerts or scheduled jobs
- Strong command of relational database design
Who this fits
This hands-on delivery role suits a mid-level ETL architect who can work across technical project teams. The position is onsite in New York City for six months.
From the employer
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.
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
Kind Regards
Sachin Gaikwad
Technical Recruiter
Integrated Resources, Inc.
Direct Line : 732-429-1920
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.