Senior ETL Data Engineer

<p><b>Company Overview</b></p>

<p><i>Nabors is a leading provider of advanced technology for the energy industry. With operations in about 20 countries, Nabors has established a global network of people, technology and equipment to deploy solutions that deliver safe, efficient and responsible hydrocarbon production. By leveraging its core competencies, particularly in drilling, engineering, automation, data science and manufacturing, Nabors aims to innovate the future of energy and enable the transition to a lower carbon world.</i></p>

<p>&nbsp;</p>

<p>Nabors is committed to providing equal employment opportunities to all employees and applicants and prohibiting discrimination and harassment of any type without regard to race, religion, age, color, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This applies to all terms and conditions of employment including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. To learn more about our Fair Employment practices, please refer to the Nabors Code of Conduct.</p>

<p>&nbsp;</p>

<p><b>JOB SUMMARY</b></p>

<p>&nbsp;</p>

<p>Senior ETL Data Engineer will work with members of the BI technical team on the design and development of highly scalable ETL processes and data warehouse utilizing tools such as Oracle, and Informatica for a diverse set of projects. This position requires a strong understanding of the Data Warehouse architecture, design, development, and deployment of business intelligence systems.</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p><b>DUTIES AND RESPONSIBILITIES</b></p>

<p>&nbsp;</p>

<ul>
<li>Act as the SME for all ETL/Informatica related matters, work with functional teams, clarify ETL requirements and business rules.</li>
<li>Understand business requirements and translate them to technical specifications.</li>
<li>Create Complex Informatica mappings in Power Center Designer to meet the data integration, cleansing and migration needs.</li>
<li>Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components.</li>
<li>Understand and experience maintaining a multi-terabyte enterprise data warehouse with an accompanying nightly update cycle within a team of like-minded and skilled professionals.</li>
<li>Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests.</li>
<li>Involved in Integration testing, validating test cases, Performance tuning techniques.</li>
<li>Work on Identifying and resolving various major production fixes and provide innovative solutions to meet the needs of the business.</li>
<li>Optimize and tune ETL processes, utilize reusability, parameterization, workflow design, caching, parallel processing, and other performance tuning.</li>
<li>Provide production support for all ETL processes and maintenance. Develop and unit test Unix Shell Scripts for file validation as well as format the input or output data as part of Pre/Post ETL tasks.</li>
<li>Implement data cleansing and maintain proper normalization of enterprise data to support Decision making and reporting.</li>
<li>Applying data visualization and statistical programming tools to enterprise data to advance and enable key mission outcomes</li>
</ul>

<p><b>MINIMUM QUALIFICATIONS/SKILLS</b></p>

<p>&nbsp;</p>

<ul>
<li>Must have 8+ years of Informatica and data warehousing experience.</li>
<li>Bachelor&
39;s degree in Computer Engineering, MIS, Engineering, or foreign degree equivalent</li>
<li>In depth knowledge of Informatica 9.x/10.x Power Center and Power Exchange as a developer.</li>
<li>6+ years developing and designing Informatica mappings and testing the performance of ETL code; Informatica ETL Architecture, writing complex SQL queries, and stored procedure; Data Analysis and Data modeling.</li>
<li>Experience in creating technical design and mapping specifications. Must have some development experience in a Unix/Linux environment and UNIX shell scripting.</li>
<li>Must have experience with data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture.</li>
<li>Experience with large databases and DW Implementation in Oracle, Postgres SQL, Teradata, mySQL etc</li>
<li>Experience in processing data from Data Lake like MapR.</li>
<li>Experience working in environments with tools like Power BI, MicroStrategy, Spotfire etc</li>
<li>Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.</li>
<li>Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.</li>
<li>Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.</li>
<li>Power BI ETL with Dataflows.</li>
<li>Experience with distributed data/computing tools: Hadoop, Hive, Spark, Oracle, MySQL, Cosmos DB, Mongo DB etc.</li>
<li>Strong analytical and problem-solving capabilities. Ability to work independently and in a team environment.</li>
<li>Hands-on experience with table spaces, indexes, partitions, and query performance tuning.</li>
<li>Ability to collaborate with enterprise architects, business architects, analysts, and development teams to deliver rapid iterations of complex solutions. Able to work in fast-paced environment</li>
</ul>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p><b>PREFERRED QUALIFICATIONS </b></p>

<ul>
<li>Data Quality Tools: Informatica Data Quality, Address Doctor, Identity Resolution</li>
<li>Data Mana gement Tools: Informatica MDM, Data Masking, Cloud MDM, Changed Data Capture, Snowflake.</li>
<li>Data Replication Tools: Database Archiving, Test Data Management, Fast Clone</li>
<li>Analytics Tools: Power BI, MicroStrategy, Spotfire</li>
<li>Cloud Platforms: Azure</li>
<li>Oil and Gas domain experience</li>
</ul>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p><b>PHYSICAL REQUIREMENTS / WORKING CONDITIONS </b></p>

<p>The primary location for this position is an office environment.</p>

<p>&nbsp;</p>

<ul>
</ul>

<p><img alt=