ETL Developer, Informatica

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, create, and test ETL scripts on the Informatica platform in accordance with requirements, adhering to development standards and best practices.

• Collaborate with business analysts to collect business requirements from end-users and convert them into technical specifications.

• Collect requirements to establish data definitions, transformation logic, as well as logical and physical designs of the data model, data flow, and processes.

• Lead and strategize complex database design, development, implementation, administration, tuning, ETL, and backup and recovery for assigned projects.

• Create and develop ETL processes utilizing Informatica Power Center.

• Possess the ability to analyze database schemas, triggers, and stored procedures.

• Design, develop, implement, and maintain custom Oracle applications using PL/SQL.

• Conduct code reviews of developed solutions.

• Have hands-on experience with database design, normalization, data lakes, structured/semi-structured/unstructured datasets, and familiarity with HDFS, Kafka, ETL, RDBMS, NoSQL, SQL, Data Engineering, and related tools, programming languages, and technologies.

• Test solutions to ensure requirements have been satisfied; create test plans, test scripts, and test conditions based on business and system requirements.

• Provide end-user support during post-deployment phases; evaluate all feedback to ensure that necessary corrections to issues are addressed.

⛳️ Requirements

• A minimum of 8+ years in ETL and at least 6+ years of experience with Informatica is essential.

• At least eight years of experience in application development.

• Strong understanding of the software development lifecycle, including requirements gathering, analysis/design, development tools/technologies, release/version control, modern testing methodologies, and deployment management.

🏝️ Benefits

• Paid vacation & sick leave

• Health insurance coverage

• Career training

• Performance bonus programs

• 401K contribution & employer match

• 11 Federal holidays