Overview

An exciting opportunity to showcase your ETL & Informatica expertise and help grow and mature the enterprise data warehouse in Teradata.

ETL Informatica Lead will help design, develop and provide operational support for ETL projects and activities. You will also be required to work with functional analysts, end users and other BI team members to design ETL solutions, convert user requirements and functional specs to technical designs and mentor BI team to use best practice ETL designs. Other responsibilities may include gathering BI/ reporting requirements, development, and maintenance of BI Reports, models and Cubes as needed.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Technical design, development, testing, documentation of Data Warehouse / ETL projects
  • Develop, implement and deploy ETL solutions to update data warehouse and datamarts
  • Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
  • Troubleshoot, debug and diagnose ETL issues
  • Provide production support and work with other IT team members and end users to resolve data refresh issues
  • Perform data profiling and logical/physical data modeling to build new ETL designs and solutions
  • Have the ability to work with users, BI and ERP teams to get ETL solutions developed and implemented
  • Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation
  • Meet with functional analysts and /or end users to gather/ clarify requirements as needed to complete BI/ DW projects
  • Participate in ad-hoc BI/ DW projects as required
  • Develop and enhance BI reports, models and Cubes and provide support as needed
  • Work with Offshore team to coordinate development work and operational support
  • Keep abreast of latest ETL technologies and plan effective use
  • Help build solutions pertaining to Predictive analytics and/or  Big data
  • Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods
  • Adhere to the processes and work policies defined by management

Basic Qualifications

EDUCATION and/or EXPERIENCE
  • Bachelor’s degree (B.S.) from four-year college or university.
  • Understanding of ERP business processes, data warehouse and BI concepts and ability to apply educational and practical experience to improvise business intelligence applications and provide simplified and standardized solutions to achieve the business objectives.
  • More than 7 years in ETL:
  • Expert knowledge of data warehouse architecture
  • Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
  • Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
  • Advanced experience in SQL, writing Stored procedures and tuning SQL, preferably using MS SQL Server.
  • Strong experience with Informatica PowerCenter.
  • Experience developing software applications as part of a team, employing practical and effective software design concepts.
  • Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning
  • Experience in troubleshooting data warehouse refresh issues and BI reports data validation with source systems.
  • Independent problem solving skills.
  • Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
  • Open to learn and acquire new skills.

Preferred Qualifications

  • Preferred experience with Informatica Cloud
  • Strong experience with ETL tool Informatica
  • Experience with Teradata SQL and Stored Procedures.
  • Experience designing staging areas for the ETL process.
  • Experience with UNIX Shell scripting.
  • Proficient with performance tuning in batch processes.
  • Experience in Tableau or other BI applications

Tagged as: Big Data, Data Visualization, Data Warehouse, ETL, Hadoop, Hive, Informatica, Tableau, Teradata

Before applying for this position you need to submit your online resume. Click the button below to continue.

About Highering Talent

Job Seekers: We catalyze increasing your earnings and mitigate challenges in browsing the best career opportunities, managing job search directly on your mobile device or desktop. Manage all of the jobs you have applied to in a convenience secure dashboard.