06/14/2023 updated
AS
100 % available
Data Engineering Specialist, Senior Software Engineer, Associate Software Engineer
Batangas, Philippines
Worldwide
BS in Electronic and Communication EngineeringAcceptance TestingAgile MethodologyUnit TestingUnixCOBOL (Programming Language)CronData ValidationInformation EngineeringExtract Transform Load (ETL)Data QualityRelational DatabasesDesktop SupportJob SchedulingUnix ShellMicrosoft SQL Servers
- 11 years of strong experience in System Development Life Cycle for ETL development and system support
- Experienced environment set-up and configuration like production, uat and dev including Informatica repository configuration and relational database connection, unix server connection details, parameters and sql fies.
- Hands on experience on deployment and migration of Informatica objects, UNIX file and oracle objects
- Developed shell script that will trigger workflow from crontab job scheduler
- Created unix shell script that would archive processed file and error notification via mail that will save client instead of buying Informatica license for it.
- 9 years ETL design and development experience using Informatica Power Center
- 9 years ETL design and development experience using Oracle Database
- 11 years ETL design and development experience using UNIX operating system
- 2 years ETL design and development experience using Informatica Data Quality
- 2 years ETL design and development experience using Microsoft SQL Server
- Expertise in unit testing, regression testing and data quality validation during development stage and system support
- Strong experience in constructing SQL queries for data quality and data validation testing
- Expertise in understanding EDI form of files and cobol file structure.
- Expertise in business requirement analyzation and design based on business standard and client requirements.
- Have both experienced in waterfall and agile SDLC
- Expertise in object-oriented analysis and design
- Analytical thinker that consistently resolves ongoing issues or defects based on problem statement.
- I’m a fast learner that can adapt to new technology and design
- 11 years of strong experience in System Development Life Cycle for ETL development and system support
- Experienced environment set-up and configuration like production, uat and dev including Informatica repository configuration and relational database connection, unix server connection details, parameters and sql fies.
- Hands on experience on deployment and migration of Informatica objects, UNIX file and oracle objects
- Developed shell script that will trigger workflow from crontab job scheduler
- Created unix shell script that would archive processed file and error notification via mail that will save client instead of buying Informatica license for it.
- 9 years ETL design and development experience using Informatica Power Center
- 9 years ETL design and development experience using Oracle Database
- 11 years ETL design and development experience using UNIX operating system
- 2 years ETL design and development experience using Informatica Data Quality
- 2 years ETL design and development experience using Microsoft SQL Server
- Expertise in unit testing, regression testing and data quality validation during development stage and system support
- Strong experience in constructing SQL queries for data quality and data validation testing
- Expertise in understanding EDI form of files and cobol file structure.
- Expertise in business requirement analyzation and design based on business standard and client requirements.
- Have both experienced in waterfall and agile SDLC
- Expertise in object-oriented analysis and design
- Analytical thinker that consistently resolves ongoing issues or defects based on problem statement.
- I’m a fast learner that can adapt to new technology and design
Experience
Professional experience10+ years
Freelancer since2023
Languages
EnglishFluent
Project history
Duties and Responsibilities: Insurance Domain
* Uses Informatica 10.1 to develop ETL design and perform map development for Insurance Company
client to implement IFRS 4 standard
* Develop ETL mapping base on business requirements and standards given by the client
* Design ETL mapping with file input and relational database output requirement
* Design ETL mapping that has relational databases input and output requirement
* Develop SQL queries override based on the business requirement from the client
* Perform unit testing and data validation
* Analyzes and recommend enhancement to current business requirements and standard
* Constantly adapt to agile SDLC by delivering constantly changing requirements
* Review the ETL mapping develop by juniors based on business requirements and standards
* Propose ETL design enhancement and system optimization
* Design error handling and pre validation processes
* Develop UDF function in Informatica ETL that will be reusable across different mappings
* Perform resource capacity planning, efforts estimation and impact analysis
* Resolving different kind of production issues, defects and design gaps
* Innovating continuous improvement on the existing processes, system design and automation
* After Copernic IFRS4 go live, currently leading the production support team.
* As production support lead, I'm responsible with team schedule, ticket assignment, technical code
review, estimations and SLA reporting.
* Aside from administrative task I also do technical task like the other developer doing; complex
code fix, code enhancement, investigation of missing records, investigation of rejected records
and workflow failure investigation.
* Uses Informatica 10.1 to develop ETL design and perform map development for Insurance Company
client to implement IFRS 4 standard
* Develop ETL mapping base on business requirements and standards given by the client
* Design ETL mapping with file input and relational database output requirement
* Design ETL mapping that has relational databases input and output requirement
* Develop SQL queries override based on the business requirement from the client
* Perform unit testing and data validation
* Analyzes and recommend enhancement to current business requirements and standard
* Constantly adapt to agile SDLC by delivering constantly changing requirements
* Review the ETL mapping develop by juniors based on business requirements and standards
* Propose ETL design enhancement and system optimization
* Design error handling and pre validation processes
* Develop UDF function in Informatica ETL that will be reusable across different mappings
* Perform resource capacity planning, efforts estimation and impact analysis
* Resolving different kind of production issues, defects and design gaps
* Innovating continuous improvement on the existing processes, system design and automation
* After Copernic IFRS4 go live, currently leading the production support team.
* As production support lead, I'm responsible with team schedule, ticket assignment, technical code
review, estimations and SLA reporting.
* Aside from administrative task I also do technical task like the other developer doing; complex
code fix, code enhancement, investigation of missing records, investigation of rejected records
and workflow failure investigation.
Duties and Responsibilities: Utilities Domain
* Uses Informatica 9.5.1 to develop ETL conversion mapping then currently using Informatica
10.2
* Create ETL conversion mapping based on mapping document approved by the client utility company,
coding standard and standard naming convention agreed by onshore and offshore developers.
* Updating ETL design due to agile development environment with frequently changing requirements.
* Perform unit testing by creating Oracle SQL queries that would check all record counts were
successfully and correctly converted based on approved mapping document.
* Perform performance tuning on ETL mapping to shorten the time of data processing in preparation
for the go live.
* Perform code review of ETL design made by the junior developer based from coding standard,
mapping document and standard naming convention.
* Perform admin task like capacity planning and team members chargeability.
* Maintain team access log sheet to monitor the public database credentials used by the team.
* Handling complex ETL conversion mapping and analyzing complicated ETL defects.
* Analyzes and propose solution to mapping document and ETL coding defects
* Perform data analysis on rejected records and duplicates then proposing solutions and seeking
advice to business people on how to address the issues
* Perform a total investigation and analysis for defect cause by errors, duplicates, ETL rejection
and Cobol files rejection
* Tracking defects using ALM and perform ETL code changes for the defects detected by testing team.
* There are also times that we need to use target load plan or Update Strategy transformation in
updating target DB.
* After we finished the mapping development we generate the workflows. We run and do data
validation every column and component over all testing.
* Uses Informatica 9.5.1 to develop ETL conversion mapping then currently using Informatica
10.2
* Create ETL conversion mapping based on mapping document approved by the client utility company,
coding standard and standard naming convention agreed by onshore and offshore developers.
* Updating ETL design due to agile development environment with frequently changing requirements.
* Perform unit testing by creating Oracle SQL queries that would check all record counts were
successfully and correctly converted based on approved mapping document.
* Perform performance tuning on ETL mapping to shorten the time of data processing in preparation
for the go live.
* Perform code review of ETL design made by the junior developer based from coding standard,
mapping document and standard naming convention.
* Perform admin task like capacity planning and team members chargeability.
* Maintain team access log sheet to monitor the public database credentials used by the team.
* Handling complex ETL conversion mapping and analyzing complicated ETL defects.
* Analyzes and propose solution to mapping document and ETL coding defects
* Perform data analysis on rejected records and duplicates then proposing solutions and seeking
advice to business people on how to address the issues
* Perform a total investigation and analysis for defect cause by errors, duplicates, ETL rejection
and Cobol files rejection
* Tracking defects using ALM and perform ETL code changes for the defects detected by testing team.
* There are also times that we need to use target load plan or Update Strategy transformation in
updating target DB.
* After we finished the mapping development we generate the workflows. We run and do data
validation every column and component over all testing.
Duties and Responsibilities: Health Care Domain
* We develop ETL mapping and conduct unit testing
* Uses Informatica 9.0 and Informatica add-ons tools (B2B Data Transformation) to develop ETL
mapping then later on upgraded to Informatica 9.1
* Create mapping of EDI healthcare transactions based on 5010 healthcare standard that convert x12
input files to xml output files, xml input files to x12 output files and xml files input files to
xml output files.
* Prepare mapping documents based on 5010 healthcare standard and client state requirements
* Works in the agile development environment with frequently changing requirements and features
* Perform unit testing by preparing input file then checking the output file if they meet the 5010
healthcare standards and client requirements based on mapping documents approved by the clients.
* Performs database testing using SQL queries in Oracle database to ensure that important fields
are being populated to correct tables.
* Proactively uses innovative methods to improve system quality, data quality, efficiency and by
performing unit testing after code development and regression testing after a mapping update
* Coordinates with other teams/team members for the timely resolution of issues encountered
* Creates bug tickets for the defects found and tracks defects using JIRA ticketing tools
* Proactively monitors files processing within the Legacy Informatica System to ensure files were
processed within SLA
* In case of batch file failures, provides accurate investigation report to the appropriate FA team
within the timeframe set by the team
* Handles and resolves UAT and PROD requests such as file research, file repost/reprocess and
inquiry
* We develop ETL mapping and conduct unit testing
* Uses Informatica 9.0 and Informatica add-ons tools (B2B Data Transformation) to develop ETL
mapping then later on upgraded to Informatica 9.1
* Create mapping of EDI healthcare transactions based on 5010 healthcare standard that convert x12
input files to xml output files, xml input files to x12 output files and xml files input files to
xml output files.
* Prepare mapping documents based on 5010 healthcare standard and client state requirements
* Works in the agile development environment with frequently changing requirements and features
* Perform unit testing by preparing input file then checking the output file if they meet the 5010
healthcare standards and client requirements based on mapping documents approved by the clients.
* Performs database testing using SQL queries in Oracle database to ensure that important fields
are being populated to correct tables.
* Proactively uses innovative methods to improve system quality, data quality, efficiency and by
performing unit testing after code development and regression testing after a mapping update
* Coordinates with other teams/team members for the timely resolution of issues encountered
* Creates bug tickets for the defects found and tracks defects using JIRA ticketing tools
* Proactively monitors files processing within the Legacy Informatica System to ensure files were
processed within SLA
* In case of batch file failures, provides accurate investigation report to the appropriate FA team
within the timeframe set by the team
* Handles and resolves UAT and PROD requests such as file research, file repost/reprocess and
inquiry