ETL Developer

Job Description:

Education Qualification

B.E / B.Tech / Masters in computer science , Electronics , Relevant technical certification

 Roles and 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.

• 
  Responsible for the delivery of the development activities he/she owns 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 initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• 
  Partner with the Data modelers to drive improvements and enhancements to the current data landscape and future strategy.
• 
  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
• 
  Evaluates existing applications that could address client requirements and makes recommendations from complex projects.
• 
  Identifies opportunities for solution sharing and reuse.
• 
  Assists in the development of ETL-related Service Level Agreements.
• 
  Communicates risks and ensures understanding of these risks.

Technology skills and project experience

• 7 years of experience in modeling and business system designs.
• 5 years hands on experience in Informatica ETL development.
• 3 years of Redshift or Oracle (or comparable database) experience with BI/DW deployments.
• Must have proven experience with STAR and SNOWFLAKE schema techniques.
• Development experience in minimum 1 year in Python scripting is mandatory. Having Unix scripting is an added advantage
• Proven track record as an ETL developer in delivering successful business intelligence developments with complex data sources.
• Strong analytical skills and enjoys solving complex technical problems.