Lead Informatica ETL Developer - Irving, TX - Georgia IT Inc.

Irving, TX

About the Job

Lead Informatica ETL Developer (with strong SQL/UNIX)
Location: Irving, TX
Duration: Contract
Bill Rate: DOE (W2/1099)

No Visa Sponsorship available for this job. No third-party agencies corp. to corp.

interview: Face-to-face REQUIRED
This position requires:

Bachelor's degree or equivalent combination of education and experience preferred.
6+ years' experience of data architecture with one or more of the following: Teradata, Oracle, SQL Server.
4+ years' experience with Informatica ETL development required.
4+ years UNIX shell scripting.
Excellent SQL skills for complex data analysis and data quality assurance.
Exceptional data modeling skills.
Strong analytical and problem solving capabilities.
Hands-on experience with table spaces, indexes, partitions, and query performance tuning.
Demonstrated ability to work independently and with large teams.
Demonstrated Ability to communicate and gather requirements from the Business.
Ability to partner with enterprise architects, business architects, analysts and development teams to deliver rapid iterations of complex solutions.
Excellent oral and written communication skills.

Technical Skills:

Teradata, Oracle, MS SQL Server.
Experience using ETL tools (ex. Informatica, Golden Gate, etc.).
Advanced SQL query techniques and automating import / export tasks using Teradata utilities.
Mastery of stored procedures, SQL coding, queries, index and database IO performance tuning.
Comprehensive understanding of Data Warehouse design principles.
Ability to proactively identify, troubleshoot and resolve complex data integrity issues.
Teradata Certification preferred.
Subscription-based industry experience preferred.

Required Skills:

ETL, Informatica, Scripting, Shell Scripting, SQL, SQL Queries, Stored procedures, Teradata, UNIX

Preferred Skills:

Reporting; Business Intelligence; Data Warehouse; Erwin; Data Modeling

Source : Georgia IT Inc.