AECOM Data Integration Developer in Taguig City, Philippines
AECOM is seeking a Data Integration Developer to be based in Manila, Philippines
At AECOM, we’re delivering a better world.
We believe infrastructure creates opportunity for everyone. Whether it’s improving your commute, keeping the lights on, providing access to clean water or transforming skylines, our work helps people and communities thrive.
Our clients trust us to bring together the best people, ideas, technical expertise and digital solutions to our work in transportation, buildings, water, the environment and new energy. We’re one global team – 47,000 strong – driven by a common purpose to deliver a better world.
Builds, enhances and maintains an Enterprise Data Warehouse that serves the reporting and analytical needs for AECOM. Participates in Systems Delivery Life Cycle for Data Integration projects including preparing detailed technical design documents; designing and developing ETL/ELT code; participating in unit and system testing; engaging with supporting administration teams, Cognos Metadata Developers, and data analysts; and providing production and off-hours operations support.
Implements and maintains AECOM’s Enterprise Data Warehouse. Responsible for populating the data warehouse using extracts from platforms including but not limited to Oracle, Microsoft SQL Server, flat files, spread sheets and API data access.
Creates the end-to-end solutions for ETL/ELT transformational jobs that involve writing the Informatica workflows and mappings, Oracle PL/SQL procedures and functions, and Unix shell scripting to load AECOM data into Operational Staging and Warehouse from disparate source systems.
Monitors ETL jobs and ensures operations run efficiently and correctly. Tunes ETL code and addresses errors or data anomalies as required.
Supports Cognos Reporting Team, the user community, and data analyst groups.
Maps data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality and lineage.
Prototypes solutions, prepares test scripts, and conducts tests for data replication, extraction, loading, cleansing, and data modeling for data warehouse.
Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment.
Participates in special projects and performs other related duties as required.
Bachelor’s degree in Computer Science, Information Systems, or a related field required.
Minimum of three years of experience with a Bachelor’s degree or one year of experience with a Master’s degree in one of the above majors in Data Integration projects
Expert knowledge using Informatica 10.x, required.
Experience with performance tuning techniques on ETL code as well as underlying databases required.
Experience with database development for data warehouse projects including writing SQL queries, PL/SQL functions, procedures and packages on Oracle RDBMS 11.x or higher, required.
Experience in Unix/Linux shell scripting required.
Working knowledge of data modeling, and understating various aspects of logical, conceptual and physical modeling of data warehouse projects required.
Demonstrated ability to work independently, take initiative and contribute to new ideas required. Experience developing APIs using ORDS, is a plus.
Experience using Python scripting related to data cleansing and building data pipelines, is a plus.
Working knowledge of IBM Cognos Analytics and/or Oracle E-Business Suite, is a plus
What We Offer
We will give you the flexibility you need to do your best work with hybrid work options. Whether you’re working from an AECOM office, remote location or at a client site, you will be working in a dynamic environment where your integrity, entrepreneurial spirit and pioneering mindset are championed.
You will help us foster a culture of equity, diversity and inclusion – a safe and respectful workplace, where we invite everyone to bring their whole selves to work using their unique talents, backgrounds and expertise to create transformational outcomes for our clients.
We will encourage you to grow and develop your career with us through our technical and professional development programs and diverse career opportunities. We believe in leadership at all levels. No matter where you sit in the organization you can make a lasting impact on the projects you work on, the teams and committees you join and our business.
We offer competitive pay and benefits, well-being programs to support you and your family, and the development resources you need to advance your career.
When you join us, you will connect and collaborate with a global network of experts – planners, designers, engineers, scientists, consultants, program and construction managers – leading the change toward a more sustainable and equitable future. Join us and let’s get started.
As an Equal Opportunity Employer, we believe in each person’s potential, and we’ll help you reach yours.
Job Category Information Technology
Business Line Geography OH
Business Group Design and Consulting Services Group (DCS)
Position Status Full Time
Requisition/Vacancy No. 263914BR
Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.