ETL Engineer (informatica)

09 Feb 2025

Vacancy expired!

ETL Data EngineerLocation: Jacksonville, FLJob Details:

Job Responsibilities• Perform hands-on ETL Development, adoption of modern software engineering & delivery practices using AWS Developers to build Data Pipeline for the optimized layer• Monitor, maintain and continue to build out a complex auto-scaling AWS infrastructure• Draw on your knowledge and experience to successfully run ETL data transfers• Advise the ETL development team on development best practices• Workflow and Process Building and Management• Develop and assist in leading tech design for future projects• Will work on Talend and Informatica Tools• Work closely with Manager to understand needs around client stakeholder management• Demonstrate a passion for learning and willingness to adopt new technologies• Contribute to a culture of innovation, ideas, and continuous improvement along with a great attitude, solid communication skills, willingness to learn and collaborate• Ensure clear documentation of created/modified functionality• Responsible for interfacing and influencing with the business lines as well as others across IT• Responsible for tasks related to the data acquisition platform of an active global financial data warehouse

Key Skills• Informatica Power Center 9.x/10x, Talend Open Studio, Java, Oracle 12c, PostgresSql, Unix, Scheduling Tools• Development, testing and support of high volume data transformation processes• Development, testing and support of transaction control architecture for a highly concurrent active data warehousing platform• Thorough understanding of ETL using Informatica or Talend Studio• Proficiency in ETL Platforms: concepts, methodologies, processes, architectures and technologies• Data Models: Conceptual, Logical, and Physical & Dimensional/Relational Data Model Design• SQL Concepts & SQL Statements Optimization and Execution. Indexes and Indexing Strategies Materialized Views, Clusters, Caching, Partitioning, and Parallel Processing• Unix Scripting: Shell scripts, Perl etc• Scheduling: Control -M , Autosys or Obsidian• Knowledge or experience with Database Architectures: Transactional Data Stores, Operational Data Stores, Data Warehouses, Data Marts• Knowledge of any Enterprise-Level Database server: Oracle and/or Postgres SQL

Desirable Skills• Informatica Power Center 9.x/10x, Talend Open Studio, Java, Oracle 12c, PostgresSql, Unix, Scheduling Tools

Qualifications• Bachelors Degree or equivalent

Experience• Experience with Talend studio building jobs for data migration and data warehousing on multiple projects• Experience working with an AWS platform. Experienced using Talend connectors for AWS S3, Redshift and RDS• Experience working with Rational relational databases like Oracle or PostgreSQL• Experience with major ETL Platforms Knowledge: Informatica, Talend

Employment Type

BenefitsPermanent • Company 401k scheme matching up to 5% of salary• Private medical insurance• Dental and vision coverage• Life assurance• Short-term and long-term disability coverage

  • ID: #49096871
  • State: Florida Jacksonville 32099 Jacksonville USA
  • City: Jacksonville
  • Salary: $60,000 - $80,000
  • Job type: Permanent
  • Showed: 2023-02-09
  • Deadline: 2023-03-31
  • Category: Et cetera