Informatica ETL Developer

Houston, TX 77042

Posted: 05/22/2019 Employment Type: Permanent Job Category: IT/Ops Job Number: 12795

Blackstone Technology Group, an award winning technology consulting and staffing firm, is seeking an Informatica ETL Developer to join our team and work at our client site in Houston, TX.

Our client is a leading manufacturer of the world’ s most advanced drilling solutions. At our client, we are harnessing the strength of knowledge and innovation that is revolutionizing the future of energy. We build on what works, using our deep expertise to help minimize risk, increase up-time and improve performance in drilling operations around the globe. They are headquartered in Houston, TX
Duties:
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 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 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
  • 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
  • Must have legal right to work in the US
  • Strong written and oral communication skills required
  • Minimum 5 years? hands-on experience developing ETL code with Informatica? s PowerCenter software
  • Experience with Informatica? s Data Quality software 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
Education
  • Bachelors Degree
 
Blackstone Staffing Services is a division of Blackstone Technology Group, a global IT services and solutions firm that implements digital transformation solutions across commercial industry verticals and the US Federal Government. Blackstone? s global staff augmentation practice was founded in 1998. Blackstone Staffing Services has offices in San Francisco, Denver, Houston, Colorado Springs, and Washington, DC. We specialize in IT staffing and place both technical and creative talent across a variety of industries and sectors.

EOE of Minorities/Females/Veterans/Disabilities.
Informatica PowerCenter ETL Code SQL Erwin Data
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.