ETL Developer

Responsibilities:

• Analyze requirements from clients and work with development team to provide meaningful analysis on data to satisfy client s business needs.
• Design, maintain and develop efficient SQL & PL/SQL languages to maintain ETL code.
• Design, build and configure applications to meet business process and application requirements.
• Works with analyst and developers to create ETL routines.
• Assist in the development, maintenance, and support of data mart application.
• Troubleshoot and tune existing data mart applications.
• Assist in creating new or enhanced components of the data mart.
• Implement best practices and methodologies and function as a technical expert in the design, development, modification and debugging of data models, databases, etc.
• Support the development of new software or enhancements to existing software and integrate into new or modified systems and/or operational environments.
• Assist reporting team in optimizing the ETL process to ensure that business requirements are met.
• Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
• Create and/or implement logical data models that represent the abstract structure of assigned information in the form of data cubes and or star schemas.
• Use the EDW Metadata repository, Informatica Metadata Manager.
• Ensure that the final Metadata repository is a structured, integrated, and homogeneous vision of the whole data warehousing system.
• Provide metadata management support ensuring the function of the repository.
• Cultivate positive, trusting, and cooperative working relationships with all persons supporting the work, including government employees and other vendors.
• Work in self-contained, cross-functional teams capable of delivering complete products, including research, design, architecture, engineering, support, and documentation.
• Collaborate closely with technology leads and developers across various teams to assess current state and implement process improvements.

Key Skills:

• Tools/Software.
• SQL.
•  Parameterization.
•  Scripting Language.
•  Organization.
•  Creativity.
• Debugging/Problem Solving.