ETL Senior Developer
Advance American Tech, Inc. - Atlanta, GA
Apply NowJob Description
Senior ETL developer with extensive experience in Informatica Cloud (IICS), Teradata Macros, Stored Procedures and TPT Scripting. Ability to wear multiple hats in a fast-paced environment. Sr. ETL Developer will be responsible for the Informatica mapping development, design, architecture of Tasks/Workflows, and maintenance of Data Warehouse. Individual will be responsible for the mapping of data from legacy system to new data storage environment. Individual will be responsible for the accuracy of deliverables for the project. Requires the management and organization of highly technical data and requires advanced skills with computers and proficiency with data-oriented computer languages such as SQL. Requires superior analytical skills and organizational skills. Sr. Developer will be part of a larger team within a business unit. Requires the ability to explain complex technical concepts to technical and non-technical staff. Since development of data models and logical workflows is common, a developer must also exhibit advanced visualization skills, as well as creative problem-solving. Other preferred qualifications: Experience in using Informatica Power Center/Informatica Cloud with Teradata, DB2 and SQL Server databases. Expertise in using Informatica Cloud (IICS) for ETL development Experience using Teradata utilities to include MultiLoad, FastLoad, FastExport, BTEQ, TPump, TPT and Teradata SQL Assistant Experience building data marts, data structures, data storages, data warehouses, data archives, and data analysis Extensive experience with RHEL Linux for Shell Scripting and Cron Jobs. Strong experience in developing of Complex database objects like Stored Procedures, Functions, Tables, Views, Indexes, Constraints, Synonyms, Materialized Views using SQL and stored procedures. Expert level experience in creating requirement specifications, Detailed Design specification, Architecture Diagrams and end - user Manuel Experience in sourcing data from DB2, SQL Server and Oracle databases Experience utilizing Teradata Macros and various Teradata analytic functions Experience working on Teradata 16.2.1 or latest version Working experience with Teradata SQL Assistant Extensive experience writing complex SQL Queries using joins, sub queries and correlated sub queries Certification in Informatica Cloud - Data Integration preferred. Budget Information Critical Hire Code (Assigned by Approver) Background Verification Standard Background Verification (Required for all new proposals)1 - SSN Name Search 1 - State Criminal Record verification (past 7 years covering each State in which the candidate has resided) 1 - Federal Criminal Records Verification (past 7 years) 1 - Motor Vehicle Records Search 1 - Global Monitor Check (formerly Patriot/OFAC/Terrorist(Suppliers Only) To order, click on the link to the right: Order Standard Background VerificationInstructionsThe completed Background Verification will be attached (via an automated feed) to the candidates user profile under the Attachments Section. Please make sure to always include the applicable proposal ID, contract ID, or requisition ID in the reference field when ordering. It is also very important to double check that the name on the order being requested matches the candidate's name in the Covendis system. Otherwise, the completed report will not be successfully uploaded to the candidates profile. Agency Terms and Agreements Please read and understand the following statement carefully:I understand that a person who enters into an agreement in restraint of trade or in restraint of free and open competition in any transaction with the state may, upon conviction thereof, be punished by imprisonment for not less than one nor more than five years pursuant to OCGA 16-10-22. I further agree that when there is a prior agreement or understanding between a vendor and a state agency or state employee regarding the acceptance of any offer, such conduct is collusive, fraudulent and in restraint of trade and in restraint of free and open competition on the part of both the vendor and the state agency or state employee. Do you agree with the above statement?I Agree Type Qualification Description Competency Experience Required
Created: 2026-04-02