Skip to Main Content
← Back to Jobs

ETL Administrator

SGA Farmington Hills, MI
  • Expired: 18 days ago. Applications are no longer accepted.
Software Guidance & Assistance, Inc., (SGA), is searching for an ETL Administrator for a Contract assignment with one of our premier financial services clients in Farmington Hills, MI.

Responsibilities:
  • Working knowledge in Installation, Configuration and Upgrade of Informatica Services Platform
  • Set up Highly Available Power Center Enterprise domain and configuring services to run on GRID
  • Manage roles and users on folder, relational connections, back-end server etc
  • Assist with design and implementation of Informatica suite of tools.
  • Develop solutions to leverage ETL tools and suggest process improvements.
  • Provide ongoing maintenance and support of assigned ETL flows and their Client applications.
  • Collaborate with ETL developers and resolve application related issues.
  • Research and provide alternatives and recommendations based on best practices and application functionality.
  • Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problems
  • Gains necessary input/approval of requirements and design and participates in code reviews and may perform code review for others
  • Conduct root cause analysis and resolve production problems and data issues.
  • Validate the data in the database and also responsible for testing the routines developed.
  • Lead user sessions for requirements gathering and testing.
  • Assists in requirements gathering and creates system and user documentation, technical solution documentation etc.
  • Create test plans, test cases, test scripts and performs functional testing of the tool
  • Assist developers with problems and resolves issues independently

Required Skills:
  • Minimum 8+ Years Experience
  • Bachelor's Degree in Computer Science or equivalent
  • Must have experience with the administration of the following ETL Tools:
  • Informatica PowerCenter, PowerExchange
  • Informatica MetaData Manager / Informatica Analyst
  • Informatica Data Validation Option
  • Informatica Change Data Capture
Preferred Skills:
  • Nice to have experience:
  • Informatica Pro-Active monitoring
  • Informatica Data Masking
  • Informatica Enterprise Data Catalog
  • Informatica Axon
  • Hadoop kerberized environment
  • High level of proficiency in advanced query development and design.
  • Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems

SGA is a Certified Women's Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. We encourage Veterans to apply. To view all of our available job postings and/or to learn more about SGA please visit us online at www.sgainc.com.

SGA

Address

Farmington Hills, MI
USA