11/06/2023 updated
JP
100 % available
Data Engineer, ETL Developer, Datascience
India
Only remote
BTechC (Programming Language)Agile MethodologyAmazon Web ServicesIBM System IAtlassian ConfluenceAtlassian JiraUnit TestingMicrosoft AzureBash ShellBug ManagementUnixCloud ComputingCloud DatabaseCode ReviewDatabases
ABAP, Agile, Alteryx, Redshift, AWS, Hadoop, Hive, spark, ADP, Azure Data Factory, Bash, C, Cloud, Cloud Technologies, Cloud Database, Cloud migration, code review, Confluence, Control M, Customer Data, data cleansing, Data lake, Big Data Tools, Data Migration, data profiling, Data Flow, Databases, database, ETL, ETL Tools, Sequential Files, FTP, GIT, DB2, Datastage, AS400, IBM's, IBM WebSphere, Idoc, Data Engineer, Jira, Json, Jenkins, Job scheduling, LLMs, Machine Learning, ML, Azure, Microsoft Azure, SQL Server, SharePoint, MS Windows, MySQL, node, Operating Systems, Oracle, PL/SQL, Parser, Performance tuning, Power BI, Putty, Python, SAP, BAPI, SQL Scripting, SQL, SAP Finance, Scala, Snowflake, Bug fixing, debugging, debug, Application Development, Version management, Swift, Tableau, Teradata, Tivoli, Reporting Tools, Unit Testing, UNIX, UNIX Shell Scripting, UNIX Shell, workbooks
Experience
Professional experience5 - 10 years
Freelancer since2018
Languages
EnglishFluentTeluguFluent
Project history
It is IBM Internal Application which acts as interface handler among various interfaces like (Dauche
bank, ADP,Swift bank, IBM,ODM etc.,) and is a back bone for all of the Awards/Recognition data, that
flows in from the global recognition vendor to the various payroll systems of IBM.
.
Roles and Responsibilities:
* Extracted the data from database tables and Flat File data sources, Transformed and Loaded
into Target through FTP/SFTP
* Responsible for interacting with the Business clients and taking part in review of
requirements document discussions.
* Did the data profiling and prepared source to target documents based on profiling results.
* Preparing the low-level design documentation according to client's specification.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Designing of the ETL Processes using different parallel job stages such as Join, Merge,Lookup,
Filter, Dataset, Transformer, sort, and Aggregator
* Responsible for Code check-in, Version management and all the implementation activities
* Provided the support for testing team in SIT phase.
* Provided the Support for UAT on data load.
* Involved in implementation work and successfully implemented in stage and production
environments and supported.
* Working as L3 support also for any urgent critical issues in prod.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Responsible for driving the status calls and technical calls within team and other dependent
teams
bank, ADP,Swift bank, IBM,ODM etc.,) and is a back bone for all of the Awards/Recognition data, that
flows in from the global recognition vendor to the various payroll systems of IBM.
.
Roles and Responsibilities:
* Extracted the data from database tables and Flat File data sources, Transformed and Loaded
into Target through FTP/SFTP
* Responsible for interacting with the Business clients and taking part in review of
requirements document discussions.
* Did the data profiling and prepared source to target documents based on profiling results.
* Preparing the low-level design documentation according to client's specification.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Designing of the ETL Processes using different parallel job stages such as Join, Merge,Lookup,
Filter, Dataset, Transformer, sort, and Aggregator
* Responsible for Code check-in, Version management and all the implementation activities
* Provided the support for testing team in SIT phase.
* Provided the Support for UAT on data load.
* Involved in implementation work and successfully implemented in stage and production
environments and supported.
* Working as L3 support also for any urgent critical issues in prod.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Responsible for driving the status calls and technical calls within team and other dependent
teams