This is a full time, direct hire position working for our client. 3 days on-site a week.

Requirements:

• A minimum of 5 years of demonstrated experience in ETL processes using enterprise-level ETL tools (e.g., Informatica, SSIS, Talend, Matillion, Pentaho).
• Bachelor’s degree in computer science, information technology, or a related field.
• Proficiency in SQL and expertise in database systems, with a preference for experience in enterprise relational databases, such as Snowflake.
• Hands-on experience with Microsoft and Unix platforms.
• Strong knowledge of scripting languages (e.g., Powershell) and job schedulers.
• Familiarity with various integration patterns, including Flat Files and Web Services.
• Solid understanding of fundamental data modeling concepts, including ER Diagrams and normalization.
• Experience with data warehousing techniques, such as dimensional modeling and star schema.
• Ability to write technical documentation effectively.
• Excellent troubleshooting and problem-solving skills, with the capability to debug complex code efficiently.
• Aptitude for understanding the business context of problems to ensure optimal solutions.
• Strong communication skills and the ability to work in a fast-paced, high-impact environment.

Responsibilities:

• Conduct data profiling, source-target mappings, ETL development, SQL tuning, optimization, testing, and implementation.
• Provide business and technical analysis for Data Warehouse and Business Intelligence initiatives.
• Influence data warehouse design with recommendations for efficient data structuring.
• Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architects and Business Intelligence developers.
• Lead both onshore and offshore developers to ensure efficient delivery of high-quality solutions.
• Mentor ETL developers and conduct peer reviews, offering feedback on ETL design and implementation.
• Design and develop ETL code, ETL audit controls, and scheduling processes.
• Develop testing strategies and conduct testing to identify and resolve data quality issues.
• Collaborate with Business Intelligence Developers throughout dashboard and application development, including requirements gathering, design feedback, and acceptance testing.
• Independently build custom solutions, even when requirements are not clearly defined.
• Stay current with emerging technologies and industry best practices.

Preferred Skills/Experience:

• Familiarity with Python.
• Experience with XML/XSLT.
• Knowledge of Snowflake and Talend.
• Cloud platform experience (AWS/Azure).