ETL Architect

US Tech Solutions; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A global staff augmentation firm is seeking a professional in Jersey City to provide solutions in data integration and ETL development. Candidates should have a BS in Computer Science or a related field and 3-5 years of relevant experience, specifically in Informatica. This role involves working closely with the business intelligence team, developing technical documentation, and troubleshooting data integration issues. Strong communication and analytical skills are essential. Competitive salary and benefits are offered.

Qualifications

• 3-5 years development experience with database solutions.
• 5+ years experience in data integration (ETL), specifically using Informatica.
• Strong project experience in providing data integration solutions.

Responsibilities

• Assist in the identification/resolution of critical path issues related to ETL development.
• Provide solutions for designing and developing ETL mappings.
• Work with the business intelligence team to develop reporting solutions.

Skills

Informatica PowerCenter

Oracle SQL

Unix scripting

Data integration (ETL)

Business intelligence

Analytical skills

Communication skills

Team collaboration

Education

BS in Computer Science or related IT field

Job description

US Tech Solutions is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit our website www.ustechsolutions.com.

We are constantly on the lookout for professionals to fulfill the staffing needs of our clients, sets the correct expectation and thus becomes an accelerator in the mutual growth of the individual and the organization as well.

Keeping the same intent in mind, we would like you to consider the job opening with US Tech Solutions that fits your expertise and skillset.

Job Description

• Assist in the identification/resolution of critical path issues related to the generation of technical specifications and associated Informatica ETL development
• Provide solutions to design and develop ETL mappings and related activities; ability to articulate in architecture terms
• Strong ability to author technical solution documents, and architecture components
• Provide technical support and troubleshooting to data integration issues
• Work together with the business intelligence team to design and develop reporting and dashboard solutions
• Create and maintain detailed technical documentation on developments
• Provide solutions to fine tune ETLs and database components for performance
• Provide testing strategy and support execution
• Provide deployment and release management strategy and support

Qualifications

• BS in Computer Science ore related IT field, or equivalent work experience required
• Experience: 3-5 years development experience with database solutions (Oracle SQL, PL/SQL) and Unix scripting
• Hands on development experience 5+ years’ experience in data integration (ETL) specifically in Informatica PowerCenter9.5 and above
• Experience in developing data warehouse solutions in the Finance industry
• Ability to analyze information architectures understands and derives business requirements
• Ability to collaborate and work in a team environment
• Proactive thinking and ability to work under minimal supervision
• Excellent analytical and communication skills and ability to deal effectively with customers
• Good communication skills both oral and written to be able to work with both the technical and banking users
• Strong project experience in providing data integration solutions to Data Warehouse and/or Data Mart implementations