ETL Architect

360 IT Professionals; Southfield (MI); On-site; USD 120,000 - 150,000; Full time

Job summary

A technology solutions provider based in Southfield, MI is seeking an experienced ETL Architect to lead architecture and design in data warehousing projects. The ideal candidate will have 12-16 years of Informatica ETL development experience and at least 4 years specifically as an ETL Architect. Strong SQL skills in Oracle are essential, along with the ability to lead teams and ensure ETL quality throughout the development process. This position is contract to hire and candidates must be on W2 only.

Qualifications

• 12 to 16 years of Informatica ETL development experience required.
• 4 years as an Informatica ETL Architect.
• Mastery in data warehousing concepts necessary.
• Strong SQL skills in Oracle Partitioned Environment are a must.

Responsibilities

• Lead ETL architecture and design activities.
• Define and implement ETL development standards.
• Ensure ETL quality through code reviews.
• Develop technical work plans and coordinate work.

Skills

Informatica ETL development

Data warehousing concepts

SQL skills

Team leadership

Tools

Informatica PowerCenter

Oracle Database

Unix Shell Scripting

Job description

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and JQuery mobile.

Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us.

We make sure that we deliver performance driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.

Job Description

Position: ETL Architect

Location: Southfield, MI

Duration: Contract to hire

Need candidates on W2 only

15-17 yrs. Experience

• This person will lead teams and work with management and executives
• Must have excellent communication
• This person is not hands on but must be able to speak to and understand how things work (Healthcare)
• Must have 3-4 yrs. as an architect and be able to show their career progression
• Cognos and Business Objects are nice to have

The Informatica ETL Architect has the overall responsibility for assessing requirements and defining the strategy, technical architecture, implementation plan and delivery of data warehouse projects. The Informatica ETL Architect must have prior experience completing successful data warehousing implementations as well as broad background and experience with IT application development. This individual is responsible for establishing the long term strategy and technical architecture as well as the short term scope for a multi-phased data warehouse effort and should have strong professional consulting skills and the ability to communicate well at all levels of the organization.

Top Skill Set:

• Lead ETL architecture and design as well as data flow diagramming
• Define and implement ETL development standards & procedures
• Ensure ETL quality through code reviews and throughout inspection & knowledge sharing
• At least 12 years experience with Informatica in a Developer/Tech Lead role
• Knowledge of Health Care Insurance Payer Data Warehousing Preferred
• Ability to develop a technical work plan and assign work and coordinate across multiple developers and projects

Required Skills/Experience:

• 12 to 16 Years of Informatica ETL development experience
• At least 4 years experience as Informatica ETL Architect
• At least 8-10 years experience with Informatica in a Developer/Tech Lead role
• Mastery in data warehousing concepts. Candidate should be able to clearly communicate fundamental concepts during the interview and demonstrate previous experience in all aspects.
• MUST HAVE strong SQL skills in Oracle Partitioned Environment
• Experience in Business Intelligence reporting tools like Cognos and Business Objects preferred
• Experience in Oracle database programming using Partitioning, Materialized View and OLAP
• Experience in tuning Oracle queries/processes and performance management tools

TOOLS & TECHNOLOGIES: Informatica 8.x and above (9.1 Preferred) PowerCenter PowerExchange Data Quality Oracle 10g and above Unix Shell Scripting (AIX, Linux) Scheduling Tools (any one of Tivoli, Autosys and Ctrl-M) SQL