SQL Developer with Informatica experience Job at Global Applications Solution, Alpharetta, GA

QnZ0WjRLSDVsUHNYczI3a09QL0M3TXpCRGc9PQ==
  • Global Applications Solution
  • Alpharetta, GA

Job Description

Job Summary

We're looking for a skilled SQL Developer with expertise in Informatica to join our team. The ideal candidate will be responsible for designing, developing, and maintaining SQL databases and ETL processes using Informatica PowerCenter. This role requires strong analytical skills, a deep understanding of database design principles, and a proven track record of creating efficient and reliable data solutions.

Key Responsibilities

  • Database Development: Design, create, and maintain SQL databases, including tables, views, stored procedures, and functions. Optimize and tune SQL queries for maximum performance.
  • ETL Development: Develop, test, and deploy ETL processes using Informatica PowerCenter. This includes creating mappings, transformations, and workflows to extract data from various sources, transform it, and load it into a data warehouse or other target systems.
  • Data Analysis: Analyze data requirements and design appropriate database schemas and ETL solutions. Troubleshoot data-related issues and ensure data integrity and quality.
  • Performance Tuning: Monitor and analyze database and ETL job performance. Implement optimizations to improve speed and efficiency.
  • Collaboration: Work closely with data architects, business analysts, and other developers to understand project requirements and deliver effective data solutions.
  • Documentation: Create and maintain technical documentation for all database and ETL processes, including design specifications, data flow diagrams, and operational procedures.

Required Skills & Qualifications

  • SQL Expertise: Strong proficiency in writing complex SQL queries, stored procedures, functions, and triggers. Experience with database design and normalization.
  • Informatica PowerCenter: Hands-on experience with Informatica PowerCenter, including knowledge of mappings, transformations (e.g., Aggregator, Router, Joiner), and workflow management.
  • Database Management Systems (DBMS): Experience with one or more major database platforms such as Oracle, SQL Server, PostgreSQL, or MySQL.
  • Data Warehousing: Solid understanding of data warehousing concepts, dimensional modeling (star and snowflake schemas), and ETL best practices.
  • Operating Systems: Familiarity with Linux/Unix command-line tools for scripting and job scheduling.
  • Soft Skills: Excellent problem-solving and analytical skills. Strong communication and collaboration abilities to work effectively in a team environment.
  • Education: A Bachelor's degree in Computer Science, Information Technology, or a related field.

Preferred Qualifications

  • Experience with other ETL tools (e.g., SSIS, Talend) is a plus.
  • Familiarity with cloud-based data platforms (e.g., AWS Redshift, Azure Synapse, Google BigQuery).
  • Knowledge of scripting languages like Python or Shell scripting.

Job Tags

Similar Jobs

Rio Grande Regional Hospital

New Graduate Registered Nurse Job at Rio Grande Regional Hospital

 ...the growth and development of our future nurses! The HCA Nurse Residency Program is...  ...long program designed to give you hands-on experience to help establish valuable clinical and...  ...No previous experience needed Some travel maybe needed for training Rio Grande... 

Prime HealthCare Staffing

Travel Outpatient Clinic RN Job at Prime HealthCare Staffing

 ...Job Description Prime HealthCare Staffing is seeking a travel nurse RN Outpatient PreOp / PACU - Post Anesthesia Care for a travel nursing job in Thermopolis, Wyoming. Job Description & Requirements ~ Specialty: PreOp / PACU - Post Anesthesia Care ~ Discipline... 

Assured Nursing

Travel Clinic Registered Nurse Job at Assured Nursing

 ...Job Description Assured Nursing is seeking a travel nurse RN Clinic for a travel nursing job in Nantucket, Massachusetts. Job Description & Requirements ~ Specialty: Clinic ~ Discipline: RN ~ Start Date: 03/09/2026~ Duration: 13 weeks ~40 hours per week... 

Dignity Health Medical Group - Phoenix - CommonSpirit Health

Endocrinology - Physician Job at Dignity Health Medical Group - Phoenix - CommonSpirit Health

 ...The role requires an MD or DO, completion of accredited Internal Medicine residency and Endocrinology fellowship, board certification,...  ...desert preserves, and 200 miles of trails 3 major professional sports teams including the Arizona Diamondbacks (MLB), the Arizona... 

Elsevier

Manager of Software Engineering- Node React AWS (Philadelphia) Job at Elsevier

 ...management, direction, and vision to software engineers and/or development employees including offshore contractors/consultants and interns...  ...Agile/Scrum teams. Strong technical background in modern web, cloud, and mobile development. Hands-on experience in clinical...