Informatica ETL Team Lead
SHOULD HAVE WORKED IN A ONSHORE-OFFSHORE MODEL
SHOULD HAVE LEAD A TEAM
SHOUDL HAVE WORKED WITH BUSINESS AND IT DIRECTLY
Bachelor's degree in Information Systems, Computer Science, Computer Engineering, Engineering,
Minimum five years of experience developing with ETL toolsets and/or Data Virtualization toolsets (e.g. Talend Integration Suite, Informatica, Denodo)
Minimum five years of SQL experience
Minimum two years of experience with multi-dimensional data modeling for a data warehouse and data marts
Minimum two years of Oracle/MSSQL/Teradata Database knowledge (e.g. table creation, insert, update, deletes)
Minimum two years of experience working on Linux/Unix Servers or Windows Servers (e.g. experience with navigation, editing files)
Build and maintain strong peer relationships within the team and across the organization
Lead projects and activities to maintain and upgrade our ETL toolsets
Ability to design, develop, test, monitor, and troubleshoot our environment using our ETL/Data Virtualization toolsets (e.g. Talend, Denodo, PL/SQL)
Help team provide problem resolution support for existing production ETL jobs which includes on-call rotation
Ensure quality and accuracy of the data mapped from staging environments to the target reporting environments
Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds defined by the business customer
Engage stakeholders to translate business requirements into technical designs to map and load data from source systems to the data warehouse
Communicate and accurately document all architectural decisions, plans, goals, and functional requirements
Maintain metadata with data definitions, relationships, sources, and consumers
Possess or have the ability to learn how to architect, develop, and support our Microstrategy enterprise report environment
Contribute to the companys Enterprise Reporting strategy and roadmap
Contribute to the companys Data Modeling (data warehouse and data virtualization) strategy and roadmap
Actively participate in Data Governance initiatives led by the business
Demonstrates project management skills and may serve as a technical lead on IT projects.
Builds business councils, develops governance agreements between customers and developers, develops reports and presentations for senior management, and facilitates planning processes.
Maintain knowledge of new technologies and methods for area of expertise and have knowledge sharing sessions with the team
Ability to develop and communicate a technical vision that is easily understood by all levels of management.
Provides technical guidance or business process expertise, technical leadership, coaching and mentoring to team members.
Demonstrated initiative to maintain technical currency through outside studies and training
Performs other duties as assigned by management
ETL toolsets and/or Data Virtualization toolsets, Oracle/MSSQL/Teradata Database knowledge, multi-dimensional data modeling for a data warehouse, on Linux/Unix Servers or Windows Servers