Informatica powercenter with Teradata Job at CLOUDSCOUTS SOFTWARE SOLUTIONS LLC, Topeka, KS

dTk1VEl0NjJxUHg5NDVvYURWZHU4cW1jZUE9PQ==
  • CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
  • Topeka, KS

Job Description

Job Description

Job Description

Remote : Informatica powercenter developer with Teradata exp. 
Most recent project must be Healthcare
10+ years and W2 role

H1b transfer is fine

H4 EAD,GC,USC 

Required Qualifications:
• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of experience writing complex SQL and performance tuning.
• 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities.
• 5+ years of Informatica PowerCenter administration experience.
• 2+ years of Unix Shell (Bash/Korn) scripting experience.
• Strong communication, collaboration, and mentoring skills.
• Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.
• Strong organizational and time management skills.

Preferred Qualifications:
• Residing in or near Springfield, IL.
• 5+ years of data warehouse development experience.
• 5+ years of data modeling experience using ERWIN or similar tools.
• 2+ years of experience with Azure Data Factory and Snowflake.
• Experience with scripting languages such as Python, R, or JavaScript (React).
• Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
• Experience with Medicaid, Medicare, or healthcare data systems.
• Experience working in Agile environments.
• Knowledge of BI and data integration technologies across relational and multidimensional
systems.

Key Responsibilities:
• Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and
load data from various agency sources.
• Automate data staging processes and optimize ETL job scheduling for performance and
efficiency.
• Administer and support ETL environments, including development and production systems.
• Perform repository backups, recovery operations, and system maintenance.
• Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica
transformations.
• Monitor and troubleshoot ETL jobs across development, testing, and production environments.
• Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in
Teradata.
• Collaborate with stakeholders to define requirements, document technical solutions, and
support project planning.
• Participate in unit, integration, and system testing.
• Provide technical support, mentoring, and guidance to team members.
• Communicate project status and deliverables to leadership and clients.
• Continuously learn and apply new technologies to enhance system performance and
capabilities.

Job Tags

Remote work, H1b,

Similar Jobs

The Oral Surgery Institute of the Carolinas

Surgical Assistant Job at The Oral Surgery Institute of the Carolinas

 ...Job Description Job Description Salary: Based on Experience Job Summary: The Surgical Assistant is involved with every aspect of surgical procedures and pre-operative processes, creating an environment for the delivery of safe patient care. The surgical assistant... 

City Year

Local Recruiter (Greater Boston) Job at City Year

 ...Location: Hybrid On-Site/Remote**Position Overview**The Local Recruiter will be responsible for generating interest and cultivating a pool...  ...will be able to work remotely from home on non-campus days. Travel to the City Year Boston office will be required throughout the... 

griddable.io

Web Marketing Manager (Slack) Job at griddable.io

Overview Youll be responsible for the day-to-day management of our website, ensuring a high-quality user experience, increasing non-paid traffic, and supporting our overall marketing goals. You will partner with the marketing, design, copy, localization and development...

Graphic Packaging International, Inc.

Supt., Paper Machine IV Job at Graphic Packaging International, Inc.

 ...managing the safe and reliable operations of equipment in the paper machine area of the mill. JOB FUNCTION: Job functions include...  ...of Science, Engineering. At Graphic Packaging International, we produce the paper cup that held your coffee this morning,... 

Signia by Hilton Atlanta

Marketing and Public Relations Manager Job at Signia by Hilton Atlanta

 ...Relations Manager A Marketing Public Relations Manager plays a crucial role in developing and implementing the annual marketing and PR plan, driving key objectives, current initiatives and relevant activities relating directly to the hotel. The role will be...