Expert - Informatica +Redshift Developer

EXPERT, Informatica + AWS Redshift Developer - Data Platforms, GTS

Sr.

Informatica ETL Developer
Responsibilities:
The role will play an active role in accelerating the Schneider Electric Big Data and Analytics environment and will contribute to the Schneider Digital initiatives for enhancing, automating and accelerating implementation of master data management, adoption of big data platforms, data excellence and data dictionary evolution, data security and eventually the business intelligence and analytics that is built on top of these platforms to derive insights that drive strategic decisions across corporate functions.

This role will be exposed to a global work culture, collaborating with different business units of Schneider Electric, and team members distributed between Paris, Grenoble, Bangalore and Barcelona

Responsibilities:

§ This is a strong technology and solution delivery role, accountable for the successful design, development, and delivery of ETL solutions on the corporate Data Platform - not only for self, also for a team of developers working on specific projects.

§ Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.

§ Drive design and determine the ETL requirements for BI projects.

§ Partners with ETL developers through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes.

§ Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns and best practices.

§ Work with team to ensure standards and patterns are followed.

§ Determines organizational strategies for data integrity validation processes.

§ Establishes policies and best practices for optimizing ETL data throughput/accessibility

§ Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.

§ Partner with the Data architect to drive improvements and enhancements to the current data landscape and future strategy.

§ Partner with Leadership team to ensure the successful delivery of projects.

§ Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed.

§ Identify opportunities for uses of those technologies to enhance current or anticipated information systems and business goals needs

§ Support ETL developers by providing technical assistance, troubleshooting and alternative development solutions.

§ Playing a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members and departments.

§ Evaluates existing applications that could address client requirements and makes recommendations from complex projects.

§ Identifies alternative uses of technologies that wil...