.x, MapReduce, HDFS, Hive, Pig, Sqoop, Oozie, Flume, Hbase, MapR, ZooKeeper, Impala, Spark, and ETL Teradata 13.x/14.x/15.x & Informatica 8.x/9.x and Databases Teradata, MS SQL and Oracle
*5+ Years of Experience in Tableau and Hadoop development
*4 years experience in Business Intelligence and ETL development in Informatica and Teradata
*Sound knowledge in Software Development Life Cycle (SDLC) and Agile/Scrum methodologies involving Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Maintenance
*Experience in Data Warehouse environment with emphasis on data modeling involving design, coupled with strong knowledge of end-to-end data warehouse development life cycle (data integration, logical & physical modeling, & data delivery) supporting enterprise analytics & BI Solution
*Expert in gathering requirements and authoring Business Requirement Documents (BRD) into Functional and Technical specifications and identifying interface and business process flows
*Proficient in gathering and creating Requirements engineering, Requirements management, Solution scoping & evaluation and create RACI, Use case/ User stories and Work flow diagrams, Gap analysis
*Expertise in designing and developing Views, dashboards & stories using data visualization tool Tableau 10.x/9.x/8.x (Desktop/Server) using data from multiple sources like RDBMS,Hadoop Hive, Oracle and Excel/Flat Files and statistical sources like R
*Extensive experience in Tableau Desktop and creating Tableau workbooks, Dashboards, Stories with interactive Prompts and expertise in Tableau Administration using tabcmd/tabadmin commands
*Experience in developing rich interactive Tableau visualizations using various visualizations like Heat and Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams and Geographic Visualizations
*Extensive working knowledge in various reporting objects like Dimensions, Measures, Facts, Hierarchies, Transformations, Filters, Calculated fields, Sets, Groups, Actions, Parameters, Prompts in Tableau and publishing the dashboards onto Tableau Servers
*Very Strong in writing, debugging SQL/T - SQL queries for Data Analysis, cleansing and Data Quality
*Strong experience in RDBMs/NoSQL databases and sound knowledge on data mining using R
*Extensive experience in using Teradata BTEQ, FLOAD, MLOAD, TPUMP,TPT and FEXPORT utilities
*In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance
*Sound knowledge on Teradata administrator and View point tools in managing database server health
*Excellent understanding of Hadoop/Big Data architecture and its components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce programming paradigm
*Experience in Importing and exporting data into HDFS and writing Hive queries, PIG Scripts and Sqoop
*Experience in working with different data sources like text, delimited files, xml files, Json files, SQL server, Oracle to load data into Hive, HBase and Impala tables
*Expertise in writing UNIX shell scripts and ingesting data into HDFS using Sqoop and Flume
*Solid Linux and Windows administration skills, and understanding of system performance (memory, CPU, disk, I/O and network I/O)
*Experience in real-time Big Data solutions using HBase, Hive handling billions of records
*Strong experience in writing database objects like Stored Procedures, Functions, Triggers and Cursors
*Advance knowledge, excellent concepts and experienced in decision support system (DSS), querying and analysis, Extraction transformation loading (ETL)/Teradata and data warehousing
*Expertise in data warehouse architecture and designing star schema, snowflake schema, FACT and Dimensional Tables, Physical and Logical Data modeling using Erwin and Sybase power designer
*Extensive experience in developing Extraction, Transformation, Loading (ETL) to load data from/to various sources into data warehouse and data marts using Teradata tools and utilities and Informatica
*Experience in doing data quality, unit testing the code and coordinate with the business and technology teams to identify and resolving issues
*Expertise in Microsoft suite of application Excel, Access, Word, Power Point,Visio, SQL Server, SSRS/SSIS
*Good Knowledge on AWS ( Amazon Web services ), EC2, AMI, Elastic Map Reduce, Redshift and S3
*Highly self motivated and team evolved person with ability to grasp things quickly and possesses excellent interpersonal, technical and communication skills
*Strong teamwork, project management and leadership skills with the ability to take initiative and work effectively in a variety of demanding situations; Acted as a Lead and managed a team of 10 resources
*Excellent attention to detail and results oriented with a track record demonstrating strong problem solving and analytical skills ; Strong oral, written and presentation skills
*Sound working knowledge on Banking and Finance domain projects involving mortgage life cycle
(Underwriting, origination and servicing) and Capital Markets