ETL Informatica Developer

Company: Della InfoTech Inc
Location: Tempe
Posted on: November 17, 2021

Job Description:

Job Title: ETL Developer (Informatica)Location: Remote with USADuration: 6 Months Contract (Possibility of Extension)Summary: Seeking a ETL Developer to be responsible for managing data availability, integration, transformation, and delivery to the data mart. Develops and implements comprehensive data integration processes, standardizes the presentation of information derived from multiple subledger transaction systems, and develops data sources necessary to support financial reporting needs.Job Responsibilities:

• Design, implement, automate and maintain large scale enterprise data ETL processes.
• Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart.
• Ensures ETL process is developed in modular fashion in shared folders and reusable objects to enforce consistency timely development.
• Reviews ETL production design for performance optimization.
• Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations.
• Plans and coordinates the implementation of new data requirements
• Oversees the data load production process and the implementation of new data load files in accordance with the department's change management process
• Resolves issues through troubleshooting and quick diagnoses.
• Ensures data quality by designing and implementing adequate internal controls and monitoring processes.
• Includes controls to identify individual ETL flows that are performance issues.
• Ensures controls are maintained when designing new structures by utilizing object naming conventions to encourage consistent development and ease of migration from development to test to production.
• Works closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications, as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, budgets, expenditures and policies.
• Participates in the research and resolution of enterprise data governance issues.Key Qualifying Skills:
  • Bachelor's degree in a technical field such as computer science, computer engineering or related field required
  • ETL Experience using Informatica power center, SQL , Good to have some python experience.
  • Strong ETL Developer with 5 to 8 years of experience
  • Looking for someone with Data reconciliation check & batch processing
  • Information Power Center (10.2 or 10.6, any will be fine though).
  • Should be responsible for managing data availability, integration, transformation, and delivery to the data mart
  • Strong Communication skills.
  • Bank/finance experience
  • Must have experience on ETL Informatica, Python, Unix & Data Modelling (Data warehouse. Database administration)
  • Nice to have: Bigdata Concepts is a plusContract length: 6 monthsJob Types: Full-time, ContractPay: From $60.00 per hourCOVID-19 considerations:Candidates can work remotely within USAExperience:
    • ETL Informatica: 5 years (Preferred)
    • Data reconciliation check & batch processing: 4 years (Preferred)
    • Python: 3 years (Preferred)Work Remotely:
      • Temporarily due to COVID-19

Keywords: Della InfoTech Inc, Tempe , ETL Informatica Developer, IT / Software / Systems , Tempe, Arizona