NOV is seeking an experienced ETL Informatica Developer who will work with business users and members of the technical team on the design and development of highly scalable ETL processes utilizing Informatica. The position requires skills with Oracle Database, PL/SQL, Microsoft SQL Server, and SQL Queries, an understanding of common Data Warehouse architecture, design, development, and deployment of Business Intelligence systems.
Additional responsibilities of this role will include the following:
- Develop and implement technical best practices for data movement, data transformation, 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 data flow and establish and/or conduct unit tests
- Participate in requirements, design, and development reviews
- 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 management
- Apply creative thinking to identify possible reporting solution alternatives
- Other duties assigned as needed
Qualifications:
- Bachelor's degree in Business, Computer Science, Management Information Systems, or work equivalent
- Must have legal right to work in the US with green card or citizenship
- Strong written and oral communication skills required
- Minimum 5 years hands-on experience developing ETL code with Informaticas PowerCenter software
-
3+ years of experience with SQL queries, stored procedures using Pl/SQL, and SQL optimization
- Experience with ERP application data structure is a plus
- High level of SQL language proficiency with common database platforms, such as SQL Server and Oracle, is mandatory
- Knowledge and experience with other Informatica products is a plus
- Knowledge and experience with Erwin data modeling is a plus
- 3+ years of business/technology work experience preferred
- Working knowledge of BI architecture and data warehousing concepts is a plus
- Able to critically think and be solution-oriented
- Strong interpersonal skills and able to work easily with client personnel
- Works well independently and within a team
- Great organizational, time management, and problem solving skills
- Possess a professional demeanor.
by via developer jobs - Stack Overflow
No comments:
Post a Comment