ETL Data Modeler||San Antonio, TX||No H1B/OPT

*Position:* ETL Data Modeler *Duration:* 24+Months Contract *Location:* San Antonio, TX *Skype Hire* *No H1B/OPT*   *Must Have Skills: *10 year work exp- SAS, Tableau & BO, Banking/Financial background, SQL, DB, Data models *Required experience:* · Data Models – Experienced in Data Mart (Star Structures) and Warehouse Data Model designs (Normalized) · SQL · ETL experience using either Informatica or Data Stage or an equivalent technology ·...

*Position:* ETL Data Modeler
*Duration:* 24+Months Contract
*Location:* San Antonio, TX
*Skype Hire*
*No H1B/OPT*

 
*Must Have Skills: *10 year work exp- SAS, Tableau & BO, Banking/Financial background, SQL, DB, Data models

*Required experience:*

· Data Models – Experienced in Data Mart (Star Structures) and Warehouse Data Model designs (Normalized)
· SQL
· ETL experience using either Informatica or Data Stage or an equivalent technology
· UNIX shell scripting
· Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations
· Advanced ETL experience using either Informatica or Data Stage
· Strong collaboration skills
· Strong SQL skills including complex query building and query performance tuning
· SAS
· Tableau and Business Objects
· Previous experience working in banking/financial services; Mortgage, Bank Business/Regulatory Controls
· Scaled Agile program/project management experience
· Intermediate SQL writing skills
· Demonstrated knowledge of databases, data models, and information management principles and practices
· Data Modeler ETL Dvlp, BI/DW Lead (Business Intelligence/Data Warehouse)
· Data analysis skills - ability to dig in and understand complex models and business processes
· UDB, SQL Server, Oracle, My SQL, Netezza or Teradata database experience
· Strong understanding of Data warehousing design concepts/skills
· Strong UNIX shell scripting skills (primarily in COBOL, Perl)
· Data profiling experience
· Defining and implementing data integration architecture
· Strong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of  operational environments
· Proven problem-solving / problem resolution abilities.
· Demonstrated ability to translate business processes to applicable requirement types(functional, technical, etc)
· Microsoft Office (Outlook, Excel, Word, PowerPoint, Access)
· Control-m scheduling tool
· Proficiency in scripting (in order of preference): Korn, Perl

*Preferred (candidates with any of the following, will take preference):*

Familiar with Agile Development Methodology
UDB/DB2
Netezza
Dimensional data modeling skills
StarTeam Software Configuration Management Tool
Business Objects (Webi, Xcelsius, Crystal Reports) or an equivalent
technology
MS Analysis Services
General Host Knowledge
StarTeam Software Configuration Management Tool




Satyendra

Recruiter –*Engineering & IT*

*Office*: *949-201-4822 *201 *

18100 Von Karman Avenue

Suite 850,Irvine,92612

*satyendra@monteksys.com*

www.monteksys.com