Lead ETL Architect

TrueBridge Resources, a professional services staffing firm, is assisting a client with a Direct Hire search in the Phila suburbs. This position offers an outstanding compensation and benefits package in a very dynamic work environment.
ETL Architect

This senior lead position will be in the Products and Technology Group and will play a key role in the design of the new ETL data integration architecture as well as the phased implementation. Strong coordination with the current Datawarehouse operations team will be required to understand the current state and then jointly define a migration path from old code to new code from a development and support perspective.

This position is ideal for a candidate who has a good mix of senior level communication and planning experience combined with a strong desire to provide hands-on design and problem solving support to project teams as they build out the next generation product on a daily basis.

Responsibilities include:

• Working with current Datawarehouse operations team to understand the current DW architecture state and challenges experienced
• Defining a roadmap/design document for the new data integration architecture (ETL) that ensures flexibility, scalability, offshore development/support capability, and strong principles of audit, balance and control.
• Developing an architecture standards document for future code design, team based-development and code release management in the new architecture.
• Working with current Datawarehouse team to define a phased migration path from the old architecture/ETL code to new architecture/ETL product.
• Working with the project team to validate the scope and requirements for the incremental releases of the new and converted existing ETL jobs.
• Serving as a primary thought leader on the data integration tool (IBM Data Stage) and its capabilities. Working with the Lead Business Intelligence Architect to ensure that the next generation ETL architecture provides the data required to meet downstream Business Intelligence requirements
• Working closely with the Datawarehouse operations team to ensure a smooth transition from new product development to production operation and support.

Requirements:

• 10+ years of full life cycle experience in Data Warehousing and ETL/Data Integration
• A successful track record of delivering complex data integration projects on time.
• Significant experience providing technical design review, development plan critique, code review, test plan/results review
• Deep experience with IBM DataStage is required - setup, configuration, design best practices, performance optimization, team based development approaches.
• Global data integration platform rollout experience (eg data integration from multiple regions in different time zones, character sets, and business rules)
• Strong experience with relational database technology supporting data warehouses/BI reporting (specific Oracle experience is preferred but not required)
• Some level of experience with reporting and analytics tools - OLAP tools, Business Objects, Cognos, Microstrategy
• Experience with Datastage on Linux/Unix platform.
• Knowledge of metadata technologies, techniques and approaches for capturing ETL metadata
• Knowledge of data profiling technologies, techniques and approaches for utilizing as part of upfront analysis and production control operations.
• Knowledge of service-oriented architecture and familiarity with using services to capture upstream events passed via an enterprise service bus into a Datawarehouse.
• Strong leadership, communication and collaboration skills
• BA/BS in Computer Science, Business or related field
• Work with a team of 10 - 15

Additional Candidate Information:

• Candidates must have great communication skills
• Candidates must have experience with high volume ETL environments
• Candidates must have experience implementing ETL for a Datawarehouse in a global environment
• Multi data, currency, time zone
• Candidates must be a Data Stage expert
• Will redesign the ETL architecture
• Will perform a phased release
• Candidates must have knowledge of a global environment
• Candidates must be need to be proficient with Metadata technologies
• Profile stage and Superglue