NOV is seeking an experienced ETL Manager who will work with business users and members of the technical team on the design and development of highly scalable ETL processes utilizing Informatica Power Center. The position requires skills with Oracle and Microsoft SQL Server Databases, SQL Queries, PL/ SQL and T-SQL Languages, Stored Procedures, an understanding of ERP applications, common Data Warehouse architecture, design, development, and deployment of Business Intelligence systems.
Additional responsibilities of this role will include the following:
· Lead a skilled ETL development team in delivering best practice solutions to support data warehousing and business reporting activities
· Ensure that best practices are implemented for data movement,data quality, data cleansing,
and other ETL-related activities
· Develop and ensure adherence to locally defined standards for all developed components
· Maintain "common code" libraries, so objects can be shared for all environments (Dev, Test,
and Production)
· Document designs and architect data maps, develop data quality components and establish
and/or conduct unit tests
· Participate in requirements, design, and development reviews when needed
· Conduct or participate in meetings with owners of key system components to fully
understand current data and systems environments
· Assist in production support by resolving source data issues and refining transformation rules
· Analyze source system data and work with technical and business representatives to
determine strategies for handling data anomalies that are identified
· Design ETL processes and develop source-to-target data mappings, integration workflows,
and load processes that assist in implementing enterprise-class data warehousing solutions
· Use the Informatica platform to extract, transform, and load data through development,
testing, and integration of ETL routines, using ETL tools and external programming/scripting
languages as necessary
· Assist in writing unit test cases when necessary
· Provide data analysis and technical documentation for both source and target mappings
· Identify problems, develop ideas, and propose solutions within differing situations requiring
analytical, evaluative, or constructive thinking in daily work
· Prepare and present ideas and recommendations to colleagues and upper management
· Apply creative thinking to identify possible reporting solution alternatives
· Other duties assigned as needed
· Experience with CDC (Change Data Capture) using Informatica Power
Exchange is preferred
Qualifications:
- Bachelor's degree in Computer Science, Management Information Systems, or work equivalent
- Must have legal right to work in the US
- Strong written and oral communication skills required
- Minimum 2 years experience as a supervisor of a development team, preferably an ETL development team
- Minimum 3 years experience developing ETL code with Informaticas PowerCenter software
- High level of SQL language proficiency with common database platforms is mandatory
- Experience working with SQL Server SSIS, stored procedures using T-SQL, and SQL optimization is a plus
- Working knowledge of BI architecture and data warehousing concepts
- Knowledge and experience with other Informatica products, such as PowerExchange CDC
- Knowledge and experience with Erwin data modeling is a plus
- Able to critically think and be solution-oriented
- Strong interpersonal skills and able to work easily with client personnel
- Great organizational, time management, and problem solving skills
by via developer jobs - Stack Overflow