Overview
An exciting opportunity to showcase your ETL & Informatica expertise and help grow and mature the enterprise data warehouse in Snowflake.
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 the BI team to use best practice ETL designs. Other responsibilities may include gathering BI/ reporting requirements, and developing, and maintenance of BI Reports, models, and Cubes as needed.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Technical design, development, testing, and 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 preparing 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 the Offshore team to coordinate development work and operational support
- Keep abreast of the 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
- Bachelor’s degree (B.S.) from a 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 business objectives.
- More than 7 years in ETL:
- Expert knowledge of data warehouse architecture
- Expertise in dimensional modeling, and star schema designs including best practices for use of indexes, partitioning, and data loading.
- Expertise in dimensional modeling, and 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 learning and acquiring 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
You must sign in to apply for this position.
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.