Sr SQL Developer with Informatica

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Informatica
MySQL
SQL
Informatica PowerCenter
Microsoft SSIS

Job Details

We are excited to share with you the job description for the Sr SQL Developer with Informatica at Global Applications. Based on your background and experience, we believe this could be a great opportunity for you.

The Role:

Job Title: Sr SQL Developer with Informatica

Location : Alpharetta GA Hybrid

Duration : Long Term Contract

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.