Job description:
role: lead data engineerlocation: remoteduration: long term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. ideal candidate will have the following skills: a successful history of manipulating, processing and extracting value from large, disconnected datasets. expertise in data modeling, data access and data storage techniques. the candidate should have foundational knowledge of dimensional modeling to build a data warehouse strong experience building transformational logic using sql on relational sql and nosql databases. skills using dbt framework for data transformation is plus robust programming skills and strong experience with python to ingest, transform and load the data experience building and optimizing big data data pipelines, architectures and data sets using tools like airflow. experience with aws cloud services: ec2, emr, rds, redshift

Resume:
<< sql, db2, accesslanguagesc++ ,java , /sqlinternet technologiesphp, perl, html, javascript, jspsoftware and toolsmicrostrategy, informatica, eclipse , data mining -wekaoperating systemswindows 7/vista/xp/2000/9x, linux experience 06/2013tocurrentdata & business intelligence engineerjones lange lasalle inc.–.3+ years of hands-on experience in bi and data warehousing projects experience in areas of r-olap, m-olap, star/snow-flake schema design, creation and maintenance of data marts/data warehouses 3+ years of hands-on experience in various database technologies including oracle, sql server , postgresql and db2 experience d microstrategy developer with expertise in microstrategy desktop, microstrategy web, dashboards certified oracle pl/sql developer associate good hands on data mining algorithms.for e.g.classification algorithms like c4.5, naive bayesian classifier, clustering algorithms like k-means, k-meloids, dbscan excellent understanding of etl techniques and tools experience in java enterprise edition (java ee), java server pages (jsp) and java database connectivity (jdbc) technologies.excellent, analytical and communication skills well acquainted with all stages of sdlc. 08/2012to 06/2013data analystsolarbridge technologies–.working closely with product team to understand business and responsible for modeling data and designing data warehouse.responsible for creation, interpretation and management of large datasets to achieve business goals.identify and solve issues concerning data management to improve data quality.responsible for data updates, indexing, and maintenance in production database responsible for developing end to end java application for database migration from postgresql to mysql responsible for developing unix shell scripts to automate production database scripts. 01/2008to 01/2011bi and database developer–.designed and implemented data warehouse and dashboard based solution for the toll systems in capacity of a team leader, handled a team of two developers to implement end to end solution for the toll systems using dashboards and data warehousing technologies analyzed various key performance indicators for toll system such as generated revenue, budgeted amount, forecasted amount and net profit designed and developed various dashboards to display key performance indicators designed, developed and deployed the desktop and web based reports using bi and data warehousing tool microstrategy created and managed oracle application table spaces, tables, views, indexes, schemas, synonyms required for the project handled deployment and administration of the application in production environments optimized performance of dashboards by developing summarized oracle database views analyzed, documented, and transformed user requirements to the technical team designed and developed database and dashboard based solution for leading retail manufacturer in usa participated in data warehouse design to provide solutions to various business needs in capacity of a senior database developer designed and developed the pl/sql stored procedures, functions and packages worked with the etl team and managed the user acceptance testing to ensure to data quality built object prompts like metric prompts and attribute prompts created facts and metrics using pass through functions like applysimple created transformations for time cycle reports that is fiscal year or month designed the database and dashboard based solution for leading home construction materials supplier company in usa created analytical report containing order kpi/analytics, status tracking, ageing analysis, and ranking top 10 customers built metrics like conditional and level metrics using microstrategy desktop designed and developed the static sql, /sql stored procedures, functions, packages to extract, transform and migrate data from various data sources to staging database with exception handling created reports, prompts, provided hyperlinks for drilling/navigation interacted with end users for creating customized reports. education expected in2013totomasters:computer sciencetexas state university-san marcos,gpa:computer scienceexpected in2008totobachelor of engineering:computer science-,gpa: , c++, clustering, communication skills, data management, data mining, modeling data warehouse, data warehouses, databases, database, data warehousing, designing, eclipse, etl, html, php, db2, indexing, informatica, internet technologies, interpretation, java, jsp, java server pages (jsp), javascript, jdbc, team leader, linux, access, windows 7, 2000, 9x, microstrategy, migration, sql, enterprise, navigation, olap, operating systems, oracle 9, oracle application, oracle database, developer, oracle pl/ /sql, perl, postgresql, profit, quality, retail, sdlc, scripts, sql server, sql server, tables, design, vista.