• Job Description

  Req#: JPC - 10140862

  Hi,

  Hope you are doing great.

  My name is Shivani Gupta from United Software Group Inc.

  I am aggressively recruiting for one of the position for ETL Informatica Admin at Minneapolis, MN, United States with one of our client. Please have a look at the job description below and if interested feel free to call me or revert to this email.

  If not, then you may refer anyone you may know looking for a job/job change.

  Job Title: ETL Informatica Admin

  Job Location: Minneapolis, MN

  Experience Required: 8+ Yrs.

  Interview: Telephonic & Skype

  Position Type: Contract

  Job Description:

  • Extensive experience in Informatica, EDG (optional), Oracle and Linux.
  • Install, configure, and administer the Informatica platform for maximum utilization and throughput.
  • Experience in power center version upgrades and migrations.
  • Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities.
  • Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades.
  • Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language.
  • Support production jobs with performance tuning and troubleshooting issues.
  • Identify, recommend and implement ETL process and architecture improvements.
  • Conduct impact assessment and determine size of effort based on requirements.
  • Interpreting and analyzing business requirements and converting them into high and low-level designs.
  • Designing and developing ETL mappings keeping in view the performance criteria.
  • End-to-end ownership for developing, unit testing and migrating the ETL code with quality and minimal supervision.
  • Writing tuned SQL queries.
  • Performance Tuning of ETL code.
  • Work closely with customers, business analysts and technology & project team to understand business requirements, drive the analysis and design of quality technical solutions that are aligned with business and technology strategies and comply with the organization's architectural standards.
  • Understand and follow-up through change management procedures to implement project deliverables.
  • Coordinating with support groups such as DBA, UNIX, Informatica admins to get the issues resolved in a quick turnaround time.
  • Working with data and ETL architects to help design an optimal solution.

  Required Qualification:

  • Bachelor’s degree in Computer Science or similar field or equivalent work experience.
  • 4 to 8 years of experience with Informatica Power Center on Data Warehousing or Data Integration projects.
  • Proven ability to write high quality code.
  • Comfortable in writing complex ETL code.
  • Experience in writing complex SQL queries.
  • Experience in Oracle Environment using tools like Toad, Oracle SQL Developer.
  • Good knowledge of relational database preferably ORACLE and SQL Server.
  • Basic Knowledge of UNIX/LINUX shell scripting.
  • Strong problem-solving, multi-tasking and organizational skills.
  • Good written and verbal communication skills.
  • Demonstrated experience of working in a team spread across multiple locations.

  Preferred Qualification:

  • TWS scheduler hands-on experience.
  • Experience in Informatica Power exchange.

  Please share your updated resume at shivani.g@usgrpinc.com or feel free to contact me at 614-401-5196

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice