Senior ETL Data Architect

Job Number: 1775019 Business: GE Capital Business Segment: Capital - Staff About Us: Headquartered in Norwalk, Connecticut, GE Capital offers consumers and businesses around the globe an array of financial products and services. For over 1 million businesses, we provide real estate, equipment and inventory financing; fleet services; working capital; and funds for corporate acquisitions, refinancings and restructurings. For our 130 million consumer customers, we offer credit cards, retail sales finance programs, home, car and personal loans and credit insurance. Posted Position Title: Sr. ETL Data Architect Career Level: Experienced Function: Information Technology Function Segment: Business Intelligence Location: United States : Connecticut City: Norwalk Postal Code: 06851-1168 Relocation Assistance: No Role Summary/Purpose: GE is an equal opportunity employer, offering a great work environment, challenging career opportunities, professional training and competitive compensation.

Provides leadership and technical expertise in the development of the enterprise data warehouse; directs the systems development process, including planning and monitoring development efforts, reviewing deliverables and communicating to management; ensures users' effective, accurate and easy access to data; translates users information requirements into system specifications. Essential Responsibilities:

Directs the systems development process, including planning and monitoring development efforts, reviewing deliverables, and communications to management.

Analyze business needs and information requirements, define optimum system requirements to meet business needs, and prioritize and manage new requirements.

Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration.

Conducts business analysis, event modeling, logical and physical database design, database optimization, load strategy design and implementation, security and change management. Ensures users' effective, accurate and easy access to data; translate user information requirements into data.

Verifies decision support program specifications with users for reliability, accuracy and functionality Qualifications/Requirements: Basic Qualifications:

Bachelor's Degree with 7+ years IT experience.

4+ years experience in data warehousing.

7+ years experience in relational data warehousing design.

Eligibility Requirements:

You must apply via COS (internals) or www.gecareers.com (externals) to be considered for this position

Legal authorization to work in the U.S. is required. We will not sponsor individuals for employment visas, now or in the future, for this job opening.

You must be able to satisfy the requirements of Section 19 of the Federal Deposit Insurance Act.

Must be willing to comply with pre-employment screening, including but not limited to drug testing, reference verification, and background check. Additional Eligibility Qualifications: GE will only employ those who are legally authorized to work in the United States for this opening. Any offer of employment is conditioned upon the successful completion of a background investigation and drug screen. Desired Characteristics:

Minimum 7 years of industry experience with an emphasis on ETL for Business Intelligence/data warehousing solutions in the financial services industry.

Must have multiple full lifecycle project experience in developing ETL solutions as a developer and architect; experience working multiple concurrent, complex projects.

Deep understanding of ETL concepts, standards and best practices.

Hands-on experience with Informatica PowerCenter (preferably
8.x). Experience with ETL Architecture.

Strong database development, SQL, physical database design and data modeling experience.

Experience in analyzing source system, data flows, and delivering data architecture designs.

Experience in data warehousing ETL design and architecture.

Prior experience building enterprise data warehouses.

Prior expierence with Oracle's OFSAA and data foundation

Prior expierence with ETL tools (Informatica)

Prior experience with Teradata FSLDM

Prior experience with Oracle's Financial Services Data foundation/Data Model

Understanding of source and target data structures and data acquisition processes.

Experience in normalized and dimensional logical modeling.

Experience in analyzing source system, data flows, and delivering data architecture designs.

3+ years experience in data warehousing.

5+ years experience in relational data warehousing design.

Experience in normalized and dimensional logical modeling.

Experience in analyzing source system, data flows, and delivering data architecture designs.

Possesses SQL skills