ETL Developer

2 days ago

Quezon City, Metro Manila, Philippines TechTiera Corporation Full-time
ETL Developer (SAP BODS)

Qualifications:
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.
• Familiarity with different database technologies (SQL Server)
• With experience focusing on Data warehousing, Data migration and ETL processes.
• Experienced in data mapping, SQL scripting, data analysis, data investigation, data fixes and testing.
• Proven experience in ETL development, data integration, and data migration projects.
• Proficient in SQL scripting, query optimization, and relational databases (Oracle, SQL Server, PostgreSQL, etc.).
• Experience in data warehousing concepts, dimensional modeling, and data reconciliation.
• Ability to analyze source-to-target mappings and develop ETL workflows and jobs.
• Skilled in troubleshooting ETL issues, data validation, and root cause analysis.
• Experience in unit testing, integration testing, and production deployment support.

Job Description
Document the Business Data needs. Work with Business stakeholders in identifying business requirements for analytics projects, products, and programs of work that maximize business impact / benefits within a realistic setting Creating detailed technical documentation for data integration (ETL) programs and other deliverables. ETL Development, Data Profiling and Data Analysis. Identify and map the data that are required from source to be loaded into target tables Define and document transformation requirements from Staging to the Final Reporting Table(s) Data warehousing, including data mapping and transformations, data dependencies, data source analysis and profiling. Write complex SQL queries to analyze data and provide results to business users or project team members. Visualize process changes in collaboration with business stakeholders and the IT user adoption team, to establish mutual understanding and accountability Understanding of the dependencies between components of data infrastructure Define standards and implement best practices for implementation of target data state