Snowflake Developer

Job Title: Snowflake Developer Client Company: USAA - Plano Zip Code: 76002 Location: Plano, TX

W2 Only During COVID it’s REMOTE

Required Skills: • Snowflake. Need to have 5-7+ years of dev exp (**Must have Snowflake development, non-negotiable) • Tableau • Hadoop • Agile methodologies are very important

Basic Qualifications:

• 5+ years of BI Development/Architecture • 3+ years of Data Integration with SNOWFLAKE • 1+ years of experience with Hadoop

Additional Skills: • Big Data Development (Hadoop, Spark, Kafka, Hive, etc...) • Python • DataStage • Apache NiFi

Job Description: • Assist in developing, executing, and communicating project plans, timelines, and deliverables lists associated with the DataMart transformation • Assist in enhancing BI workflows • Analyze changes for the existing ETL or target tables to implement changes • Design, Develop, Implement (DDI) and maintain the data flows (source, target, and data definitions/metadata) • Convert user-developed SQL code to appropriate source-target mappings and associated code/ jobs per standards set by USAA. • Optimize (for speed and maintainability) and maintain existing ETL code • Automate data flows using Apache Nifi, Kafka or DataStage, as appropriate. • Design, Implement, and Maintain the reusable components for Extract, Transform, and Load (ETL) jobs. • DDI of necessary validation, reconciliation, and quality controls. • DDI of control M jobs for Daily \ weekly \ Monthly batch data processing. • Design, Develop, Implement and Maintain the data models (logical and physical) the data with business partners. • Knowledge transfer and documentation of data models and data flows to USAA Full Time Employees • Provide DDI Services for BDW (Bank Data Warehouse) migration and retirement. • Analyze changes required in target platform to accommodate BDW data • Design and implement required changes to target models • Design, develop and implement ETL to load and integrate target data structures • Create test infrastructure to validate migration and validate • General Purpose Datamart (GPM) • Optimize the strategic GPM data architecture. • Design, Implement, and Maintain data flows between non-strategic platforms and Netezza or other strategic platform (source, target, and data definitions/metadata) • Enhance the Bank Foundation Layer on Hadoop. • Design, develop and implement controls for the Bank Data Foundation Layer. • Modify/ customize the enterprise framework and validate for Bank • Design and develop reusable components to extract / load data to downstream marts and databases. • Design, develop and implement ETL to load and integrate target data structures • Provide DDI Services for Bank Compliance Requirements • Analyze changes required in target platform to accommodate compliance requirements. • Design and implement required changes to target models • Design, develop and implement ETL to load and integrate target data structures • DDI of necessary audit, validation, reconciliation, and quality controls. • Create test infrastructure to validate migration and validate

Preferred Requirements:

• Hadoop platforms such as Horton Data Platform to include but not limited to: • Hadoop Distributed File System (HDFS) • Apache Hive • Apache Spark • Apache Tez • Apache Yarn • RDBMS: DB2, SQL Server, Oracle • Netezza, Sailfish • Snowflake • Python and assorted libraries and IDE’s • Perl • Korn & Bash shell scripts • Apache Nifi and Kafka • IBM Infosphere DataStage • BMC Control M

Thanks & Regards,

Mohan Kumar B | Technical Recruiter | Wave Solutions Inc. | 1444 N. Farnsworth Ave, Suite 302, Aurora, IL - 60505 | Email: kumar@wavsols.com Direct #: 630-566-9398| Fax: 630-566-9398 Main #:6305669398, EXT: 108 Website: www.wavsols.com LinkedIn: https://www.linkedin.com/in/mohan-kumar-bangaru-b424467b/