Lead ETL Developer

Job Number: 1812166 Business: GE Capital Business Segment: Capital - Staff About Us: Now is the time to join GE Capital in building a better tomorrow, today. If you thrive on being challenged, interacting with diverse technical teams and using your expertise to imagine, innovate and explore, then GE Capital's new Technology Center in New Orleans, LA is the best place for you.
Here the best and brightest technical experts will come together and use cutting-edge technologies to solve some of the world's toughest problems. Realize your potential today. Join us in an environment where you'll find endless learning opportunities, career growth and development, and a culture committed to innovation. Our state-of-the art facility, located in the heart of the Central Business District, offers next generation virtual meeting technology, collaborative workspaces, and breathtaking views of historic New Orleans.
Join GE Capital in leading innovation in Financial Services and one of the Country's fastest growing technology sectors, while living in New Orleans - a city steeped in culture offering diversity, community, and an unparalleled quality of life.
To learn more our Technology Center please view http://youtu.be/P3NNWUzzRkc Posted Position Title: Lead ETL Developer Career Level: Experienced Function: Information Technology Function Segment: Business Intelligence Location: United States : Louisiana City: New Orleans Postal Code: 70170 Relocation Assistance: Yes Role Summary/Purpose: GE is an equal opportunity employer, offering a great work environment, challenging career opportunities, professional training and competitive compensation.

Lead one or more simultaneous Data Warehouse projects for Business Intelligence and data warehousing initiatives. Work with ETL/DA architects in designing/enhancing ETL architecture. Perform hands on development and mappings using Informatica. Responsibilities include full lifecycle project management, solution design, and overall ETL design and development. Essential Responsibilities: Essential Responsibilities:

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.

Assists the systems development process, including planning and monitoring development efforts, reviewing deliverables, and communications to 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.

Lead Data Warehouse projects, plan and monitor development efforts:

Execute hands on Informatica Mapping and Development.

Coordinate SDLC activities to meet business requirements for integrated data.

Assess requirements for completeness and accuracy and determine if requirements are actionable for ETL Developers. Work with requirement providers to close issues and gaps.

Coordinate all aspects of the project with other teams, such as BI Reporting, Quality Assurance, Support, Infrastructure as well as business owners and management.

Perform impact assessment and scope the size of the effort based on the requirements.

Execute project plans to implement the ETL solutions.

Develop the solution and ensure that it fits into the overall ETL/Informatica architecture at GE Treasury.

Help shape the overall ETL/Informatica architecture. Identify, recommend and implement process and architecture improvements.

Assist with and validate the design of the solution and the production of all design/build phase deliverables.

Execute the build phase and quality assure (peer review) the code to ensure that it meets the requirements and adheres to the ETL architecture standards and best practices.

Mentor junior team members on Informatica and ETL best practices.

Resolve difficult design and build issues, troubleshoot bugs when developers are not able to do so.

Coordinate with the Quality Assurance team to plan and execute QA testing and resolve any defects.

Coordinate with deployment and support resources to ensure the solutions gets implemented smoothly into QA and Production environments.

Take an active role in joint solution design and be an advocate for long term quality in the process.

Lead/conduct source system analysis and data integration design.

Lead end to end data acquisition matching business requirements.

Write SQL to explore source data, data issues, etc.

Identify impact on existing model/solution triggered by new/changed requirements.

Work closely with business analysts, end users, developers and QA team to ensure technical compatibility. Qualifications/Requirements:

Bachelor's Degree with 2+ years of IT experience.

1+ years of experience with Informatica or other ETL tool including advanced features.

Eligibility Qualifications:

Must submit your application for employment through gecareers.com to be considered (Internals via COS)

Must be 18 years or older

Must be willing to comply with pre-employment screening, including but not limited to drug testing, reference verification, and background check.

Must be willing to work out of an office in New Orleans, LA

Must be willing to travel up to 10%, if applicable

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 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:

2+ years' experience developing data warehouse or ETL solutions.

Demonstrated experience leading a team, delivering, implementing data warehouse technologies.

Expert skills in identifying and capturing business rules and business requirementsDetailed understanding of ETL concepts, standards and best practices.

Ability to present highly technical concepts to a non-technical audience.

Excellent interpersonal, written/verbal communication, and leadership skills with the ability to quickly build credibility, influence and make recommendations to all levels.

Strong organizational skills - ability to effectively manage multiple projects simultaneously.

Solid SQL skills.

Solid understanding of relational databases (Oracle, SQL Server etc), data structures, data quality and cleansing strategies and experience analyzing large volumes of data.

Deep knowledge of data warehouse development life cycle methodologies and processes.

Experience with Treasury function, Financial Services/Banking Industry.

Experience with global data warehouse implementations.

Experience with ERwin and other data modeling tools.

Strong cross-functional team player working seamlessly within a matrixed structure.

Solid knowledge and experiences in loading stage, ODS and dimensional data models.