ETL Developer with informatica

23 Nov 2024

Vacancy expired!

ETL Developer with informatica -(Senior Level : 9+ years)

Location:

Baltimore, MD/Fairfax, VA (Initial Remote and Onsite as needed)

Duration: Long Term Contract

Locals preferred
  • Provides ETL processing subject matter expertise to client projects
    • Designs and implements industry best ETL technologies to satisfy client requirements
    • Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources
    • Gathers and translates business requirements into analytical applications.
    • Collaborates with other project members and drive the development of BI initiatives.
    • Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes.
    • Establishes ETL environments according to project requirements
    • Design and develop ETL processes to satisfy all program area requirements
    • Develops and implements an efficient migration process to move ETL objects from development to test and production environments
    • Supports the project team throughout the design, development and testing process
    • Participates in all design reviews and requirement sessions, if required
    • Supports project documentation as required
    • Understands database design, programming concepts, data modeling and framework management.
    • Supports star schema modeling and implementation of a data warehouse
    • Communicates ideas to both technical and non-technical people in all levels of the organization.
    • Effectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to others
    • Develops advanced, and complex INFORMATICA
    • Works with Business Analysts, Data Architects, Enterprise Architects and ETL Architects to ensure business requirements are being met with the solution being developed.
    • Identify and reuse of ETL components and services to avoid duplicative implementations
    • Mentor other team members in developing, documenting and modifying ETL components
    • Support and administer the INFORMATICA environments
  • Key Attributes for this role include:
    • Full understanding and experience in implementing BI solutions and data warehousing is required
    • Full understanding of INFORMATICA 9 is required especially dealing with very large volumes of data, real time or micro batches
    • Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, database and tool optimization techniques and other such data architecture best practices is required.
    • Excellent oral and written communication skills is required
    • Excellent Analytical skills required
    • Flexibility/Adaptability is required, especially when working in a large team
    • Good Organization and Time Management skills required
    • Attention to Detail is required
    • Ability to Multi-task is required
  • Nice to Have:
    • Data architecture and modeling experience implementing proper data structures for a BI solution using tools such as INFORMATICA and COGNOS is required.
    • INFORMATICA 8 or 9 Certification
    • Scrum Master Experience or Certification

    Skills:
    • Data Warehousing – 5 year(s)
    • ETL – 5 year(s)
    • Informatica – 5 year(s)
    Oracle/SQL – 5 year(s)

    • ID: #23300379
    • State: Maryland Baltimore 21201 Baltimore USA
    • City: Baltimore
    • Salary: $70+
    • Job type: Contract
    • Showed: 2021-11-23
    • Deadline: 2022-01-21
    • Category: Et cetera