ETL Architect

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.

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.

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.

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.

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.

Key responsibilities include:

• 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
• 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
• 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)
• Power Center
• Power Exchange
• Data Quality
• Oracle 10g and above
• Unix Shell Scripting (AIX, Linux)
• Scheduling Tools (any one of Tivoli, Autosys and Ctrl-M)
• SQL