Job Description :

 Sr. ETL Informatica Developer

Houston , TX

Long Term Contract 

Must have Linkedin profile*

*Must take an Informatica Assessment*

Description

We are seeking a Sr. 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 

  • Bachelor's degree in Business, 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 7 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
  • 4+ 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
             

Similar Jobs you may be interested in ..