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:
Technical Skills:
Required Skills:
Preferred Skills:
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.