Lead Data Architect- ETL

Job Title - Lead Data Architect - ETL

Exp: Minimum 17+ Years

Hybrid role: Must be available to come into office 3 days/week

Minimum Requirements:

• Evaluates users' requests for new data elements and systems and incorporates into the existing shared data
• Install and use Data Modeling tools like Tableau, Azure Data Factory (ADF), Informatica and etc.
• Develop logical and physical Data Models and Entity Relationship Diagrams.
• Implement database objects in an Oracle cloud RDBMS, Salesforce CRM.
• Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases.
• Generate scripts to be in the database using data modeler tools.
• Incorporating changes to data model design.
• Write source to target mapping instructions as needed to support ETL development.
• Develop stored procedures, database triggers and complex PL/SQL packages where needed.
• Perform requirement analysis and provide data mapping guidance to application and development teams.
• Coordination and Collaboration: Work with various teams, including IT support, development, and operations, to gather information and expertise.
• Relies on limited experience and judgment to plan and accomplish goals.
• A certain degree of creativity, out of the box thinking, and latitude is required.
• Works under limited supervision with considerable latitude for the use of initiative and independent judgment.
• Communication: Keep stakeholders informed about the status of problems and solutions.
• Familiar with standard concepts, practices, and procedures within a particular field.
• Strong understanding of ETL (Extract, Transform, Load) to extract, transform, and load data, enabling businesses to use data for analysis and decision-making, extracting data from various sources, such as databases, files, and cloud services.
• Certification in Azure Data Factory (ADF), Informatica preferred.
• Experience understanding PERL scripts is a plus.
• Experience creating Tableau dashboard.