KBR Lead ETL Developer in Houston, Texas
Title: Lead ETL Developer
Job Number: 1047125
KBR COMPANY INFORMATION
When you become part of the KBR team, your opportunities are endless. As a leading global engineering, construction, and services company, we support the hydrocarbon and government services markets on six continents. Serving our customers through diverse business units, we offer challenging assignments on some of the world's largest and most complex projects where our customers have come to value us, because they know We Deliver.
With operations in 40 countries, KBR has more than 25,800 people delivering services to customers in over 80 countries. Together they represent an unmatched reservoir of talent and experience in a wide range of markets.
Join us and you'll be part of a dynamic, elite team of professionals who understand what it takes to get a job done and has the experience, knowledge and determination to succeed.
Position Description/Job Responsibilities:
Data Integration Team Lead is responsible for leading a team of local (US) and offshore (India) ETL resources.
Functions as technical lead and acts as liaison between IT groups.
Provides training and direction to the Data Integration team members. Monitor work queues,assign, prioritize and coordinate activities of the Data Integration team. Proactively provides status reports to management and seek prioritization as needed.
Develops and manages data processing jobs that meet requirements for System Integration and Business Intelligence (BI) solutions. Works closely with business users and internal IT teams to determine functional and technical requirements.
Develops task lists, project plans and estimates based on functional and technical requirements.
Codes, tests, debugs, documents, and implements complex ETL and SQL logic.
Will be involved in 24x7 production support.
This position is not limited to the duties and responsibilites listed below.
Additional duties and responsibilities may be added.
Perform and oversee development, quality assurance reviews, documentation, system deployment, training, and project setup/support for the Enterprise Data Warehouse and ETL processes.
Lead the Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations and time zones.
Performing project setups, analyzes, designs data integration solutions.
Responsibilities also include selection, acquisition, installation and configuration of applications licensed from third parties, and interaction with vendors is required.
Investigate production ETL issues and work to determine the root cause of problems.
Interpreting and applying directions originating at a higher level.
Prepare detailed development cost estimates.
Provides input to development project plans.
Development of Data Models and processes
Conceptual schema: Understand and design of the Conceptual schema including the semantics of a domain being the scope of the model its entity classes, and relationships assertions about associations between pairs of entity classes.
Logical Database: Logical Database design which includes: Clarifies functional specifications and avoids assumption, Confirms business requirements, Facilitates business process improvement, Focuses on requirements independent of technology, Decreases system development time and cost, Facilitates data re-use and sharing, Foster seamless communication between applications, Establishes a consistent naming scheme
Physical Database: Physical Database design which includes: includes detailed specification of data elements, data types, indexing options and other parameters residing in the DBMS data dictionary.
Build specifications for extract, transform, and load processes, following standards for Informatica to facilitate the data mart/warehouse fact and dimension models as well as system integration.
Work with business to design specific subset of warehouse data for producing analytical data stores. Understanding elements of the data warehouse and facilitating the build of a warehouse to produce data marts that meet the business requirements.
Responsible for time scheduling, properly building jobs with appropriate failure notifications, and properly maintaining adequately documented run books of the jobs.
Review business requests for data design and data usage. Avoid redundant extracts by understanding gap analysis of available data and working to build interfaces for new data.
Work with business to gather/analyze requirements to determine extent of reporting and/or interface needs.
Ensure warehouse and database functions are in accordance with Data Governance policies as set forth by KBR policies and standards.
Collaborate with cross-functional teams to design solutions.
Maintain proper metadata tools in order to perform proper usage and impact analysis.
Perform data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data.
Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse.
Ensure consistency with existing databases and warehouses, enforcement of standards and consistent processes.
Work with the release management team to ensure that proper change management process is performed, as well as planning deployment timelines to avoid emergency migrations.
Define and recommend BI and integration standards, processes and technologies.
Research and recommend software technology direction.
Supervision and mentoring of staff; allocating and monitoring work.
Provide after-hours support as needed.
Bachelor’s degree in Computer Science / Computer Information Systems or related field or extensive applicable experience.
A minimum of 7 years of experience working with enterprise data warehouse projects.
A minimum of 7 years of experience with Informatica PowerCenter.
Experience with installation and configuration of Informatica PowerCenter.
Experience with SQL Tools such as Toad/SQL Navigator.
Extensive experience working with Oracle and Microsoft SQL Server databases.
SQL query and performance tuning.
Strong understanding of data analysis, data and process modeling and relational database concepts.
Excellent organizational, oral, written, and presentational communication skills in order to work with all levels of staff and management.
Extensive data warehousing/business intelligence development and architecture experience.
Extensive experience designing relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence.
Extensive experience deploying and supporting large, complex data warehouse/business intelligence solutions.
Extensive experience with system integrations.
Experience with data modeling tools such as Embarcadero or Erwin. Embarcadero experience is preferred.
Experience with Scheduling tools.
Experience with project planning and management, including making operational decisions, monitoring progress, taking corrective action, and communicating results.
Candidate must have a strong customer service orientation.
KBR offers a selection of competitive lifestyle benefits which could include a 401K plan with company match, medical, dental, vision, life insurance, AD&D, flexible spending account, disability, paid time off, or flexible work schedule. We support career advancement through professional training and development.
KBR is an equal opportunity employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.
Job: Information Technology