For the given job description <<Publicis Sapient  Public Sector is looking for a Senior Associate, Data Engineer to be part of our team of top-notch technologists. You will lead and deliver technical solutions for large-scale digital transformation projects. Working with the latest data technologies in the industry, you will be instrumental in helping our clients evolve for a more digital future.Great Place to Work Certified in the US: https:www.greatplacetowork.comcertified-company1000228
Primary Skill: Data Warehouse and ETL
Qualifications:Must-Haves:***Application open to ONLY U.S. Citizens and Permanent Residents******Must be eligible to obtain U.S. Government Clearance (Public Trust)***6+yrs of demonstrable exp in data platforms involving the implementation of end-to-end data pipelinesHands-on exp with at least one of the leading public cloud data platforms (Amazon Web Services, Azure, or Google Cloud)Exp in implementing data pipelines for both streaming and batch integrations using tools; Google Cloud Dataflow, Azure Data Factory, ksqlDBExp working with code repositories and continuous integrationExp in data modeling, warehouse design, and factdimension implementationsStrong SQL knowledge to develop efficient and complex queriesExp working with Microsoft SQL ServerExp in data processing, transformation, and manipulation using Python (1+ yr exp)Exp developing, maintaining, and troubleshooting complex ETL processes using Microsoft SSISData ingest, validation, and enrichment pipeline design and implementationBachelor's degree in Computer Science, Engineering, or a related field
Nice to have:Exp in SnowflakesExp in Tableau Power BI, familiarity with ArcGIS would be an assetCertifications for any of the cloud services like AWS, Google Cloud, AzureLogical programming in Spark PySpark  Scala
Benefits of Working Here:Flexible vacation policyUnlimited PTO's15 company paid holidays annuallyWork Your World programGenerous parental leave and new parent transition programTuition reimbursementCorporate gift matching program>> the resume: <<Professional SummaryOver 8+ years of progressive professional experience in analysis, Design, Development and Implementation as a Sr. Data Engineer and Data Modeler/Data Analyst.Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.Good knowledge in Data Quality & Data Governance practices & processes.Highly Qualified with about 5 years of experience in building Big data applications, creating data lakes to manage structured and unstructured data.Well versed with Agile with Scrum, Waterfall Model and Test-driven Development (TDD) methodologies.Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).Worked with Java based ETL tool, Talend and Implemented Integration solutions for cloud platforms with Informatica Cloud.Extensive experience in setting up CI CD pipelines using tools such as Jenkins, Github Nexus, and Maven.Experience developing On - premise and Real Time processes.Experience on Migrating SQL database to Azure data lake, Azure data lake analytics, Azure SQL database, Data Bricks and Azure SQL Data Warehouse and Controlling and granting database access and migrating on premise databases to Azure Data Lake Store using Azure Data FactoryStrong experience in Big Data technologies like Spark, Spark SQL, Pyspark, Hadoop, HDFS, Hive, Sqoop, Flume, Kafka, Spark StreamingExperience in job workflow scheduling and monitoring tools like Oozie, M2.Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.Experience in designing dashboards, reports, performing ad-hoc analysis and visualizations using Tableau, Power BI.Hands-on experience on NoSQL databases like Snowflake, HBase, Cassandra and Mongo DB.Experience in building and architecting multiple Data pipelines, end to end ETL and ELT process for Data ingestion and transformation in GCP and coordinating tasks among the team.Expertise in DBMS conceptsExperience in GCP Dataproc, GCS, Cloud functions, Big Table and Big Query.Experience in writing and executing unit, system, integration and UATscripts in data warehouse projects.Worked on different file formats like Parquet, Avro, ORC and Flat files.Designing star schema, Snowflake schema for Data Warehouse, ODS architectureExperience with Apache Spark ecosystem using Spark-Core, SQL, Data Frames and RDD's.Experienced in data manipulation using python.Hands-on experience working at Amazon Web Services (AWS) using Elastic Map Reduce Redshift, and EC2 for data processing, AWS glue, RDS, S3, Lambda.Proficient in installing, configuring and using Apache Hadoop ecosystems such as MapReduce, Hive, Pig, Flume, Yarn, HBase, Sqoop, Spark, Storm, Kafka, Oozie, and Zookeeper.Experience in integrating Kafka with Spark streaming for high speed data processing.Extensive experience in developing and driving strategic direction of SAP operating system (SAP ECC) and SAP business intelligence (SAP BI) systemDevelop effective working relationships with client teams to understand and support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.
SkillsTechnical SkillsHadoop/Spark Ecosystem:Hadoop, MapReduce, Hive/impala, YARN, Kafka, Flume, Sqoop, Oozie, Zookeeper, SparkDatabases: Oracle, My Sql, SQL Server, PostgreSQL, HBase, Snowflake, Cassandra, Mongo DBCloud computing : Amazon Web Services (AWS), Amazon Redshift, MS Azure, Azure blob storage, Azure Data Factory, Azure Synapse & Google cloud Platform(Big Query, Big Table, Dataproc)BI Tools: Business Objects XI, Tableau 9.1, Power BIQuery Languages: SQL, PL/SQL, T-SQLScripting Languages: Unix, PythonOperating Systems: Linux, Windows, Ubuntu, UnixSDLC Methodology: Agile, Scrum, Waterfall, UML
Work History10/2020toCurrentSr. Data EngineerHumana Inc.–Riverton,WY,Involved in requirements gathering, analysis, design, development, change management, deploymentInvolved in development of real time streaming applications using PySpark, Apache Flink, Kafka, Hive on distributed Hadoop ClusterUtilized Apache Spark with Python to develop and execute Big Data Analytics and Machine learning applications, executed machine Learning use cases under Spark ML and MilibExtracted data from heterogeneous sources and performed complex business logic on network data to normalize raw data which can be utilized by BI teams to detect anomaliesDesigned and developed Flink pipelines to consume streaming data from Kafka and applied business logic to massage and transform and serialize raw dataDeveloped a common Flink module for serializing and deserializing AVRO data by applying schemaDeveloped Spark streaming pipeline to batch real time data, detect anomalies by applying business logic and write anomalies to Hbase tableImplemented layered architecture for Hadoop to modularize designDeveloped framework scripts to enable quick developmentDesigned reusable shell scripts for Hive, Sqoop, Flink and PIG jobsStandardize error handling, logging and metadata management processesIndexed processed data and created dashboards and alerts in splunk to be utilized/ action by support teamsResponsible for operations and support of Big data Analytics platform, Splunk and Tableau visualizationManaged, developed, and designed dashboard control panel for customers and Administrators using Tableau, PostgresQL and REST API callsDesigned and Developed applications using Apache Spark, Scala, Python, Nifi, S3, AWS EMR on AWS cloud to format, cleanse, validate, create schema and build data stores on S3Developed CI-CD pipelines to automate build and deploy to Dev, QA, and production environmentsSupported production jobs and developed several automated processes to handle errors and notificationsAlso, tuned performance of slow jobs by improving design and configuration changes of PySpark jobsCreated standard report Subscriptions and Data Driven Report SubscriptionsTools: Hadoop, Map Reduce, Spark, Spark MLLib, Tableau, SQL, Excel, PIG, Hive, AWS, PostgresQL, Python, PySpark, Flink, SQL Server 2012, T-SQL, CI-CD, Git, XML, Tableau.01/2018to09/2020Sr. GCP Data EngineerCognizant Technology Solutions–Lake Forest,CA,Developed multi cloud strategies in better using GCP (for its PAAS) and Azure (for its SAAS)Involved in loading and transforming large sets of the structured, semi-structured dataset and analysing them by running Hive queriesDeveloped custom python program including CI/CD rules for Google cloud data catalog for metadata managementDesign and develop spark job with Scala to implement end to end data pipeline for batch processingDo fact dimensional modeling and proposed solution to load itProcessing data with Scala, spark, spark SQL and load in hive partition tables in parquet file formatDevelop spark job with partitioned RDD (like hash, range, custom) for faster processingDevelop and deploy the outcome using spark and Scala code in Hadoop cluster running on GCPDevelop near real time data pipeline using flume, Kafka and spark stream to ingest client data from their web log server and apply transformationPerforms data analysis and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN and MB MDRAssist service developers in finding relevant content in the existing reference modelsLike Access, Excel, CV, Oracle, flat files using connectors, tasks and transformations provided by AWS Data PipelineUtilized Spark SQL API in PySpark to extract and load data and perform SQL queriesWorked on developing Pyspark script to encrypting the raw data by using Hashing algorithms concepts on client specified columnsResponsible for Design, Development, and testing of the database and Developed Stored Procedures, Views, and TriggersDeveloped Python-based API (RESTful Web Service) to track revenue and perform revenue analysisCompiling and validating data from all departments and Presenting to Director OperationDevelop SQOOP script and SQOOP job to ingest data from client provided database in batch fashion on incremental basisUse DISTCP to load files from S3 to HDFS and Processing, cleansing and filtering data using Scala, Spark, Spark SQL, HIVE, Impala Query and Load in Hive tables for data scientists to apply their ML algorithms and generate recommendations as part of data lake processing layerBuild data pipelines in airflow in CP for ETL related jobs using different airflow operators both old and newer operatorsCreated Big Query authorized views for row level security or exposing the data to other teamsGood knowledge in using cloud shell for various tasks and deploying services.06/2016to12/2017Big Data EngineerHoneywell–Altamonte Springs,FL,Implemented a generic ETL framework with high availability for bringing related data for Hadoop & Cassandra from various FRANCHI sources using sparkExperienced in using Platfora a data visualization tool specific for Hadoop, and created various Lens and Viz boards for a real-time visualization from hive tablesQueried and analysed data from Cassandra for quick searching, sorting and grouping through COLImplemented various Data Modelling techniques for CassandraJoined various tables in Cassandra using spark and Scala and ran analytics on top of themParticipated in various upgrades and troubleshooting activities across enterprisesKnowledge in performance troubleshooting and tuning Hadoop clustersApplied Spark advanced procedures like text analytics and processing using in-memory processingImplemented Apache Drill on Hadoop to join data from SQL and No SQL databases and store it in HadoopCreated architecture stack blueprint for data access with NoSQL Database Cassandra;Brought data from various sources into Hadoop and Cassandra using KafkaExperienced in using Tidal enterprise scheduler and Ooze Operational Services for coordinating the cluster and scheduling workflowsApplied spark streaming for real time data transformingCreated multiple dashboards in tableau for multiple business needsInstalled and configured Hive and written Hive UDFs and used piggy bank, a repository of UDF's for Pig LatinImplemented Partitioning, Dynamic Partitions and Buckets in HIVE for efficient data accessExported the analysed data to the relational databases using Sqoop for visualization and to generate reports for the BI team Using TableauImplemented Composite server for the data virtualization needs and created multiple views for restricted data access using a REST APIDevised and led the implementation of next generation architecture for more efficient data ingestion and processingCreated and implemented various shell scripts for automating the jobsImplemented Apache Sentry to restrict the access on the hive tables on a group levelEmployed AVRO format for the entire data ingestion forecaster operation and less space utilizationExperienced in managing and reviewing Hadoop log filesWorked in an Agile environment, and used rally tools to maintain the user stories and tasksWorked with Enterprise data support teams to install Hadoop updates, patches, version upgrades as required and fixed problems, which were raised after the upgradesImplemented test scripts to support test-driven development and continuous integrationUsed Spark for Parallel data processing and better performancesTools: Map Reduce, HDFS, Hive, pig, Impala, Cassandra, spark, Scala, solr, Java, SQL, Tableau, PIG, Zookeeper, Sqoop, Teradata, CentOS, Pentaho.06/2014to11/2015Data EngineerITC InfoTech–City,,IndiaWorked on configuration and monitoring Hadoop cluster using Cloudera distributionInvolved in migrating data from on prem Cloudera cluster to AWS EC2 instances deployed on EMR cluster and developed ETL pipeline to extract logs and store in AWS S3 Data Lake and further processed it using PySparkMoved files between HDFS and AWS S3 and worked with S3 bucket in AWS on a regular basisResponsible for developing data pipelines using Flume, Sqoop and Pig to extract the data from weblogs and store them in HDFSMigrated data between various data sources like Teradata, Oracle, and MySQL to HDFS by using SqoopUsed HCatalog to access Hive table metadata from MapReduce and Pig codeDeveloped a data pipeline using Kafka and Storm for streaming data and to store it into HDFSUsed Informatica Powercenter for cleaning, managing, and integrating data from different sources for ETL and loaded into a single warehouse repositoryUsed Impala to read, write and query the Hadoop data in HDFS from HBase and constructed Impala scripts to reduce query response timeAnalysed data stored in S3 buckets using SQL, PySpark and stored the processes data in Redshift and validated data sets by implementing Spark componentsPerformed ETL operations using Python, SQL on many data sets to obtain metricsPrepared data according to analyst requirements on the extracted data using Pandas and NumPy modules in PythonInvolved in designing and developing automation test scripts using PythonInvolved in writing multiple python scripts to extract data from different API’sCreated HBase tables using Shell to load large sets of data from different databasesInvolved in scheduling Time based Oozie workflow engine to run multiple Hive and Pig jobsDeveloped flow XML files using Apache NiFi to process and ingest data into HDFSWorked on performance tuning of Apache NiFi workflow to optimize the data ingestion speedsResponsible for collecting and aggregating large amounts of log data using Flume and staging it into HDFS for further analysisWorked on integration of Apache Storm with Kafka to perform web analytics and upload streaming data from Kafka to HBase and HiveResponsible for developing data pipelines using Apache Kafka by implementing Kafka producers and consumersUsed Hive optimization techniques like partitioning and bucketing to provide better performance with HiveQL queriesLoaded large amounts of data to HBase using MapReduce jobsWorked on developing UDFs to work with Hive and wrote our tests in ScalaUsed zookeeper to maintain configurations across clusters and for better synchronization, grouping and reliable distributed coordinationWorked with Kerberos and Apache sentry for security and authorization on HadoopUsed Git for version controlTools: Cloudera CDH4, Hadoop 2.x (HDFS, MapReduce, Yarn, Sqoop, Hive), AWS, EC2, S3, Redshift, Impala, Spark, Pig, SQL, HBase, Kafka, Zookeeper, Flume, Oozie, HCatalog, NiFi, Storm, Informatica, Python, MySQL, Scala, Teradata, Oracle, Git.
EducationExpected in2013totoBachelor’s:Computer ScienceCBIT-Hyderabad,GPA:
SkillsTechnical SkillsHadoop/Spark Ecosystem:Hadoop, MapReduce, Hive/impala, YARN, Kafka, Flume, Sqoop, Oozie, Zookeeper, SparkDatabases: Oracle, My Sql, SQL Server, PostgreSQL, HBase, Snowflake, Cassandra, Mongo DBCloud computing : Amazon Web Services (AWS), Amazon Redshift, MS Azure, Azure blob storage, Azure Data Factory, Azure Synapse & Google cloud Platform(Big Query, Big Table, Dataproc)BI Tools: Business Objects XI, Tableau 9.1, Power BIQuery Languages: SQL, PL/SQL, T-SQLScripting Languages: Unix, PythonOperating Systems: Linux, Windows, Ubuntu, UnixSDLC Methodology: Agile, Scrum, Waterfall, UML>>. The result is, Potential Fit

Fit assessment: Potential Fit