Mitchell Martin - Kennesaw, GA

posted 4 months ago

Full-time - Mid Level
Kennesaw, GA
Administrative and Support Services

About the position

The Sr Informatica/ETL/Oracle Developer position is a critical role that requires a seasoned professional with extensive experience in Informatica ETL workflows and Oracle development. This hybrid position is available for candidates located in Richmond, VA, Jacksonville, FL, Kennesaw, GA, or Alpharetta, GA, and is strictly a W-2 contract role. The ideal candidate will have a strong background in Informatica PowerCenter, specifically version 10.4, and will be responsible for developing and optimizing ETL processes to ensure efficient data integration and performance tuning. In this role, you will be expected to leverage your 6 to 8 years of hands-on application development experience to manage and deliver high-quality ETL solutions. You will work closely with offshore teams, ensuring that deliverables are met on time and to specification. Your expertise in Oracle PL/SQL will be essential, as you will be required to perform performance tuning and analysis of Oracle queries. Additionally, familiarity with CI/CD tools such as Bitbucket and Ansible Tower on the Horizon platform will be crucial for successful deployments. The position also demands a solid understanding of Agile methodologies, including participation in Scrum teams, sprint planning, and retrospectives, utilizing tools like JIRA for project management. You will be involved in job scheduling using Autosys and will need to demonstrate excellent object-oriented analysis and design skills, as well as system integration capabilities. The ability to optimize data load performance in both Informatica and Oracle environments is a key requirement for this role.

Responsibilities

  • Develop and optimize ETL workflows using Informatica PowerCenter 10.4.
  • Perform Oracle PL/SQL development and performance tuning.
  • Manage and deliver ETL solutions while collaborating with offshore teams.
  • Utilize CI/CD tools such as Bitbucket and Ansible Tower for deployments.
  • Participate in Agile methodologies, including Scrum team activities and sprint planning.
  • Schedule jobs using Autosys and ensure timely execution of ETL processes.
  • Conduct performance tuning and analysis of Oracle queries and Informatica workflows.
  • Implement object-oriented analysis and design principles in system integration.

Requirements

  • 6 to 8 years of hands-on application development experience in Informatica ETL workflows.
  • Proficiency in Informatica PowerCenter and Oracle PL/SQL development.
  • Experience with performance tuning and analysis in Oracle and Informatica.
  • Familiarity with CI/CD tools such as Bitbucket and Ansible Tower.
  • Knowledge of Agile methodology and experience with JIRA.
  • Experience with SQL Server databases and job scheduling using Autosys.
  • Strong object-oriented analysis and design skills.

Nice-to-haves

  • Experience with Python and Java is a huge plus.
  • Knowledge of banking or finance sector is preferred.
  • Prior client experience in a regulatory environment is beneficial.
  • Experience with Axiom and Hadoop, data integration, Big Data, Python, and Spark.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service