Position:  Lead Talend Consultant

Location: Richmond VA (Onsite)

Duration: Contract

Job Description:

Job Description

14+ Year Profile.

• 1 Strong understanding of Data warehousing Dimensional Modeling ETL etc and RDBMS concepts
• 2 Minimum 5 years working experience with Talend ETL tool
• 3 Minimum 5 years working experience in SQL Stored Procedures and Table Design
• 4 Minimum 5 years working experience in SQL Query optimization and ETL Data loading Performance
• 5 Minimum 2 years working experience in Snowflake Cloud Data warehouse
• 6 Experience as a Data Engineer in Hadoop Platforms on components like HIVE KAFKA NiFi Spark etc is a big plus
• 7 Minimum 2 years working experience in shell scripting
• 8 Experience in real time streaming technologies is preferred
• 9 Experience deploying machine learning models and automating processes in production is a plus
• 10 Experience with cloud technologiesAWS Azure GCP is big plus
• Responsibilities
• As a core member of team of Data EngineersETL Developers responsibilities include but not limited to
• 1 Design Develop and maintain secure consistent and reliable ETL solutions supporting critical business processes across the various Business Units
• 2 Ensure data solutions are compliant with enterprise security standards
• 3 Work in complex multiplatform environments on multiple project assignments
• 4 Develop and perform tests and validate data flows and prepare ETL processes to meet complex business requirements including designing and implementing of complex endtoend solutions using BI platforms
• 5 Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment
• 6 Partner with various infrastructure teams application teams and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes
• 7 Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability
• 8 Define and capture metadata and rules associated with ETL processes
• 9 Assist production support team in providing resolutions to production job failures data issues and performance tuning