For the given job description <<A mid-sized telecom company is looking for a Sr Data Engineer to join their Business Intelligence Insights team. This team is responsible for all of the data migration, data clean up, data integration, and warehousing for the company.
In this role, you will primarily be responsible for data migration and clean up in existing platforms as well as newly or soon to be integrated systems. It is necessary to be well versed in MS SQL, with the ability to import data, manipulate data and put it back in, querying, and building indexes. It is also crucial to be versed with SSIS to load and validate dimensions and measures. Lastly, it will be important for this person to have exposure and understanding of Salesforce - ability to import data, query data, get data out of Salesforce, and use SOQL.
This position is currently slated as a 12-month contract, with possibility to extend or convert to an FTE. This role is offering a pay rate of $58-68hr. During the contract period, health benefits and a 401k are offered by Insight Global. Priority is given to candidates sitting in Boston, Colorado, or Long Island, however the role is fully remote. If you're interested, please apply today!

Must-Haves*7 years of Data Engineering experience*5+ years of experience with MS SQL or SOQL*Experience with ETL tools, specifically SSIS*Familiarity and understanding of Salesforce if not SOQL
PlusesOracle or PostgreSQL experienceTalend, Matillion, or similar tool>> the resume: <<Summary7+ years of IT
Industry experience in in designing and developing data mining/analytics solutions,
data centric integration, developing and
maintaining Business analytics.Adept in data query, data migration, data analysis, predictive
modeling, machine learning, data mining, and data visualization implementations with extensive use of SQL, Python, R, Java, and Unix Shell scripting with platform of Toad, Oracle developer, Jupyter Notebook, Pycharm, R-Studio, Tableau, Hadoop with Spark.Experience in
predictive analytic procedures used in supervised learning (Classification,
Regression, Decision trees,
Random Forest, SVM, Neural Networks),
unsupervised learning (Clustering-k-Means and PCA), and reinforcement learning.Solid theory background for machine learning, data mining, text mining, graph mining, statistics modeling, NLP and deep learning.Expert in Natural
Language Processing like POS Tagging, Parsing, Named Entity Recognition,
Relationship extraction, Information       Retrieval, Sentimental
Classification, Machine Translation, etc.Solid knowledge of deep learning
algorithms like CNN, RNN, LSTM, GRU, etc. for text mining and image processing.Professional in writing complex SQL queries on Oracle, MS SQL server, Teradata and MySQL using a lot of subqueries, joins, aggregate functions, analytical functions, and temporary tables, etc.Worked on Big Data Analytics, Hadoop ecosystems (Hadoop, Sqoop, Hive, Pig, Mapreduce) and Spark for big data migration, cleaning, transformation, processing, query and analysisFamiliar with software lifecycle includes requirement collecting/documentation, development, and testing for Unit, Smoke , integration, system, non-functional testing regarding performance,
scalability, usability, enduration,
load, and volume testing, and regression
testing, multivariate testing (A/B testing) and system maintenance.Work with business domain experts and application developers to identify data relevant analysis / mining and, develop new predictive / analytical modeling methods and/or tools in Financial (like loan and foreign exchange), Product, Customer, Sales domains, etc.Experience in data
aggregation and reduction techniques of large data sets with high performance
and parallel computing for high performance
analytical projects.Involved in
diagnosing and resolving predictive / analytical model performance issues,
monitoring analytical system performance

·      
and implementing
efficiency improvements.Conversant with MS
SQL/ Oracle PLSQL and RDBMS. Contributed in data definitions for new database
file/table development and/or changes to
existing ones as needed for analysis and mining purpose.Experienced Oracle
PL/SQL Developer for designing, developing, debugging , maintaining and
administrating database in Oracle RDBMS. Solid
experience in PL/SQL and SQL programming and performance tuning.Familiarity with
Oracle data warehousing features such as star & snowflake data modeling
schemas, materialized views, bitmap indexes, Index
Organized Tables, external tables etc., and OLTP system using B-tree index,
Hash Join, etc.Experienced in
front-end developing using Java, Javascript, C++ and back-end developing using
C.Professional in
integrating and maintaining code using version control tools PVCS, SVN,
CVS.Solid experience and
knowledge in ETL and Data warehousing concepts.Data Processing experience in
designing, implementing transformation
processes using ETL tool.Involved in all aspects of ETL- requirement gathering
with standard interfaces to be used by operational
sources, data cleaning, data loading strategies, ETL mappings designing,
documentation and ETL jobs performance testing.Using Unix
bash/corn shell scripting to do backend process operation, system resources

checking, job
scheduling, batch data loading, performance tuning and reporting.Conversant with
Project Management deliverables and SDLC phases – Waterfall and Agile.A self-starter, team
player, excellent communicator, prolific researcher.Expert technical
documentation skills. Strong interpersonal and communication skills (both
written and oral); ability to communicate with
people in a wide variety of areas and at various levels from technical
specialists to senior management.
SkillsRoles:
Data Scientist, Data Analyst, Business System Analyst, Oracle PLSQL developerData Visualization: D3.js, Tableau, R visualization packages, Microsoft ExcelData Analytics Tools/Programming:















Python (numpy,
scipy, pandas, scikit-learn, gensim, keras), R(caret, weka, ggplot ), MATLAB,
Microsoft SQL Server, Oracle PLSQLMachine Learning Algorithms: classification, regression, clustering, feature engineeringBig Data Tools: Hadoop, MapReduce, SQOOP, Pig, Hive, NOSQL, Cassandra, SparkOthers:Deep Learning, NLP, Topic Modeling, Sklearn, Graph Mining, Text Mining, C, C++ , Java, Javascript, ASP,
Shell Scripting
Experience08/2011to09/2016Data ScientistLockheed Martin Corporation–Yuma,AZ,Actively develop
predictive models and strategies for effective fraud detection for credit and

customer
banking activities using Kmeans clustering using Python.Assisted senior data
scientist to do text mining on customer review/comment data, using topic
modeling

and sentimental
classification, using deep learning algorithms like CNN, RNN, LSTM, GRU, to

remediate according financial products using Python.Assisted
senior quantitative analyst in assessing risk management of financial
derivative products like foreign exchange products, bonds, funds, etc. using
machine learning
techniques for providing appropriate investment recommendations using
Collaborative filtering recommender
system using Python.Mentored
sophisticated organizations on large scale customer data and analytics using
advanced

machine
learning and statistical models relying for issuing loan using Random Forest using R.Performed
k-Means clustering in order to understand customer backgrounds and segment the

customers
based on the customer transaction behavior information for customized product

offering,
customized and priority service, to improve existing profitable relationships
and to avoid customer churn, etc using R.Worked on
Interactive Dashboards for building story and presenting to business using
Tableau.Implementing
Hadoop to provision big data analytics platforms for customer data. Used

MapReduce,
Sqoop, Hive and Spark to migrate and analyze large call-quality-data datasets
from

multiple Data
sources like integrated funds transfer system like FedWire, CHIPS, SWIFT for

securities,
treasury or derivatives, and web-based cash management systems eGifts,
GiftsWEB, GiftsWEB EDD for fraud detection and risk management, for accounts
based on positive pay, and Automated Cash Handling, balance reporting, etc.Installed and
configured Hadoop cluster in Test and Production environments; Moving data from
Oracle 9i database to HDFS and vice-versa using SQOOP; Collecting and
aggregating large amounts of log data using Apache Flume and staging data in
HDFS for further analysis; Developed multiple MapReduce jobs in java for data
cleaning and preprocessing; Writing Pig scripts to transform raw data from
several data sources into forming baseline data;  Solved performance
issues in Hive and Pig scripts with understanding of Joins, Group and aggregation
and how does it translate to MapReduce jobs; Developed Oozie workflow
for scheduling and coordinating the ETL process; Using Spark for further data
analysis/mining.Experience in
using Sequence files, RCFile, AVRO and HAR file formats.Work with
Data Analytics team to develop time series and optimization.Involved in development and maintenance of
Oracle database using PLSQL and back-end

development
using C/C++ for intra-net management system for Employee Management System

(EMS)
and Agent Pay-out System (APS).04/2009to08/2011Business System AnalystAccenture–Overland Park,KS,Project Summary:This project is in
Application service group for Mercury system in Canon USA, Inc. , which mainly
in charge of the new item request, item disclosure between companies, item data
import from other Canon Americas companies to Canon USA., Canon Americas Master
inquiry, Model tree maintenance, model configurations, and camera/video
merchandise Maintenance for Canon Americas systems includes- S21 for Canon USA
merchandise master, S98 for Panama, CCI21 for Canada, S85 for Mexico, Chili,
Brazil, and Argentina, Ideal for Latin Americas countries.Hardware/Software:Windows Vista/NT/XP/7, Linux, Oracle 11g/10g/9i/8i,
SQL*PLUS , Oracle SQL developer, Toad, 
Microsoft SQL Server management studio 2008,Microsoft Visual Studio
6.0,ODBC/JDBC , Microsoft IIS 5.1.1, Putty, Cygwin, Winmerge, VPN, ITG project
management system, PQedit, IIS, Autosys-PC-Xware 5.1.0, MS Word, Excel, Access,
Project, VisioResponsibilities:Operational support for Canon Americas Mercury
system, includes data adjustment/research, batch data loading, system
migration, Technical and functional specification documentation, reports,
business process alignment, workflow stuck, and reconciliation, etc.Break/Fix any issues or bugs collected from
client and development regarding setup, performance, functionality, and
workflow stuck, etc.System Enhancement regarding functionality and
performance, etc.Reproduce and review existing oracle 9i schema
objects includes tables, temporary tables, views, materialized views, indexes,
triggers, procedures, functions, packages based on customer requirement and
system upgrade using Toad and Oracle SQL developer tools.Review and analyze ASP code for UMC Mercury
application web development for data research and system feature fix and
enhancement using Visual Interdev 6.0.Query real-time data regarding Canon Americas
new item request, item status inquiry, item data disclosure and import, model
configuration and maintenance, warranty maintenance, and model configuration
inquiry , etc.  using complex SQL queries
on Oracle 9i Canon mercury database.Using Unix bash/corn shell scripting to do backend process operation, system resources checking, job scheduling, batch data loading, performance tuning and reporting.Maintain scheduled day and night batch jobs for mercury system using Autosys-PC-Xware and Unix box and check the MQ series using PQ edit.Implement client, session, action, module,
service, instance level end-to-end application tracing using SQL trace with
TKPROF, and Explain plan to check execution plans for high-load and Top SQL
statement.Using Cygwin/ FTP- Putty with Unix Bash shell to
make a tunnel for Oracle database connection.Using Tortoise SVN for code check-out, update,
and release–comparison, etc.Tracking and documenting tickets for development
and reproduction Using ITG ticket tracking system.Assisted QA and build team to be involved
in unit, smoke, integration, system, UAT, non-functional testing regarding
performance, scalability, usability,  enduration, load, and volume testing, and  regression testing and maintenance using SOUP UI and Seapine QA Wizard Pro for product release.Data loading using Imp/exp, data pump, and
external tables from Americas Mercury system to S21-CUSA merchandise master, to
Ross-CUSA retails system, and Global Mercury system.2008to04/2009Oracle PLSQL DeveloperCognizant Technology Solutions–Novi,MI,Project Summary:NYU Langone Medical Center,
a world-class patient-centered integrated 
academic medical center, is one of the nation’s premier centers for
excellence in healthcare, biomedical research, and medical education. The project
is to develop new oracle database objects on online Health Information Managment system on FindWdev instance/server for 29 NYU medical school departments using in clinical,
education, research, and foundational areas, etc., to be used as Oracle staging
area to store the loaded data from NYU Medical Dash DWH from different source
systems, to provide further data to be
loaded into DWH for historical record, Decision support and Datamart for
reports,  and Cube for UI display.Hardware/Software:Unix,
Oracle 11g, Oracle developer 11g, Oracle EBS 11, ERP R12, IBM DataStage 8.0
(Designer, Director, Manager, Parallel Extender), Oracle Enterprise Manager, MS
SQL server management studio 2008, Toad for Oracle 9.0, TSQL & PL/SQL, XML,
Erwin, Microsoft Visio, Autosys, IBM Data stage 8, Oracle reports 11g.Responsibilities:Independently develop Oracle
database objects includes tables, views, materialized views, indexes, triggers,
functions, procedures, packages, etc.Cooperated with BA, SME to
collect and document database design requirements and do data modeling with DB
architect using Erwin and Microsoft Visio.Assisted DBA for job
scheduling, data loading, and performance tuning using OEM, SQL tuning/access
advisor, hints,  explain plan , SQL trace
and V$ performance views under Unix.Write complicated queries
using a lot of aggregate functions, joins, analytical functions, subqueries ,
etc. to provide real-time data from
Oracle DB  for client and UI development
supporting.Checking execution plan using
explain plan together with SQL trace with TKPROF using trcsess under unix to
realized end-to-end application tracing.Add optimization hints into
high–load and top SQL statements to change the optimization goal, access
method, join method, join order, and parallelization, etc.Designed and developed ETL
processes using DataStage designer to load data from Oracle to staging database
and from staging to the target Data Warehouse.Worked with Datastage Manager
for importing metadata from repository, new job Categories and creating new
data elements.Used DataStage stages namely
Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join,
Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the
ETL Coding.Job scheduling using Autosys.

Coorporated with QA team for
debugging, unit, system, functional, UI, regression testing for new ISO release
production.Working on Linux system for
batch data loading, job scheduling, and system resource checking, etc.Assisted back-end developer for reviewing and debugging C program for Health information management systems.Involved in
web development of online Health information management systems using JAVA.Reviewed and
reproduced online JAVA reports of Health information management system, checked
DB references in it for intelligent Decision Support System
EducationExpected in2016totoMaster of Science:Computer ScienceUniversity of California-Los Angeles,CAGPA:GPA:3.78Courses:















-Statistics Programming -Databases and
Knowledge Bases -Graphs and Network Flows

-Language and Thought -Current Topics in
Computer Theory(Machine Learning Algorithm) -Computer Science Classics(Basic
Data Science) -Data Mining and
Big Data Analytics -System SecurityExpected in2010totoMaster of Science:Electrical EngineeringUniversity of Bridgeport-Bridgeport,CTGPA:GPA:3.62Courses: Computer Networks -Database Management Systems -Data and Computer Communications -Data StructuresExpected in2007totoBachelor of Science:Telecommunications EngineeringJilin University-Changchun,JilinGPA:GPA: 3.50>>. The result is, 

Fit assessment: Potential Fit