Data Engineer
Resume:
Techno-functional professional with expertise in independently leading projects by understanding the requirements and providing go-live support; targeting assignments with an organisation of high repute
Location Preference: Bangalore
Executive Profile
Offering approx. 11 years of experience in software consultancy in big database, technical project execution, application architecture
Proficient in grasping the big picture, conceptualizing, developing, and implementing solutions
Worked with data ingestion, cleaning and consolidation processes with large distributed systems (Big Data and Data Lakes) from an architecture and development perspective
Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
Involved in designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
I involved in performing source system analysis.
I have used BI Tools like Tableau and Cognos.
Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implements versioning of the ETL repository and supporting code as necessary. I have worked in creating mappings in TALEND for more than 3 years using tMap, tJoin, tReplicate, tParallelize, tConvertType,, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc.
I have worked with Talend Big Data, Hadoop, Hive and used Talend Big data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.
I have used file format XML and JSON for more than 3 years.
Excellence in writing Python & HQL scripts, developing business logic, preparing complex queries and developing customized business reports as per business requirement
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Maintain conceptual, logical and physical data models along with corresponding metadata.
Good knowledge of metadata management, data modeling, and related tools (Erwin and ER Studio)
Acquired expertise in working in Star schema and snowflake schema for more than 6 years.
Worked on setup backup methods for high availability of database and minimal downtime and complete recovery of data
Received pat on the back, value innovation, achiever of the quarter, team of the quarter and various other recognitions
An innovative & result-oriented professional with strong planning, communication, interpersonal & analytical skills
Education
B.Tech. in Electronics & Telecommunications Engineering from Biju Pattanayak University of Technology in 2008
Certification:
GCP Certified Professional
Since Nov’18
Infogain, Bangalore as Technology Lead
Key Result Areas:
Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
I have created mapping documents for all Facts and Dimension tables
Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
I participated in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
I involved in designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
I involved in design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV,JSON,and Flat file structures.
I have used BI Tools like Tableau and Cognos.
Key Impact Areas
Informatica
Talend
Hadoop/Hive/Spark
Google Cloud
Requirement Gathering
SQL/PLSQL/Python/Shell
DWH/Data Modelling
Solution Design
Tableau/Cognos
Previous Experience
Jul’17 – Aug’18
KPIT Technology Limited, Bangalore as Tech Lead
Jun’14 – May’17
Capgemini Technology Services Limited, Mumbai as Senior Software Engineer
Sep’09– June’14
PWC (client), Mumbai as Software Engineer
Nov’08 –Aug’09
NR Switch N Radio Services Pvt. Ltd., Kota as Trainee Engineer
Major Projects (Recent 5)
At Infogain, Location as Technology Lead
Project Name- NCR Customer Insight
Period-2019-2020
Technology – Hive, Talend Enterprise Big Data Edition 6.4.1, Apache Dremio,,Bitbucket,Tableau
Description – The Project is about of building of new data lake in Hadoop using hive and create the virtual data set by using Dremio for the use of tableau and to give the input to spark ml
Project Name: Data Monetization
Period: 2018 to 2019
Technologies: Informatica Power Centre 10.x, Power exchange,Oracle 11g,, Toad, Control M, Putty, Winscp,Data modelling,Erwin studio,Cognos
Description: This project is about analysis of the various report published by various government body like CDC, FDA, ATSDR, EPA and WHO, along with reports need to be submitted by various provider to government regulatory environment
Project Name: Loyalty Bonus
Period: 2017 to 2018
Technologies: Hive, Talend Data Integration 6.4.1, Talend Administrator Console, esp scheduling tool, my SQL, netezza,data modelling,Tale,Oracle exadata,XML,JSON,Tableau
Description: A customer loyalty program is a structured and long-term marketing effort which provides incentives to repeat customers who demonstrate loyal buying behavior. Successful programs are designed to motivate customers in a business's target market to return often, make frequent purchases, and shun competitors.
Project Name: Quality Analytics Data
Period: 2016 to 2017
Technologies: Talend Data Integration 6.0.1, Json, Parquet,DB2,SQL,Unix, Talend Administrator Console,Tableau
Description: Quality Data Analytics is a unique combination of flexible online database query and browsing capabilities and advanced statistical analysis tools in one uniform, browser based analysis environment
Project Name: SMBC
Period: 2016 to 2017
Technologies: ETL Informatica, Oracle, SQL, PLQL, Unix,data Modelling,Cognos
Description: SMBC Project is integration of major Insurance company with SMBC for Loan insurance. The goal of this project was to integrate required functionalities in existing Finance mart & to apply different rules to allocate Accounting data at the lowest levels of Customer Structure hierarchy
S SEKHAR DAS
***********@*****.***
1.
Personal Details
Date of Birth: 1st July 1985
Language Known: English, Hindi & Odia
Address: Flat 305, Vakil Daffodils, Chandapura, Bangalore
Contact this candidate