Data Engineer and Developer in Sydney, New South Wales, Australia

The project aimed to integrate financial data from newly acquired data into the existing data warehouse. It was a data integration project with multiple sources.

I was responsible for implementing the enterprise BI architecture and providing technical guidance to design the solution roadmap. This included migrating data to the workday system using Informatica and exploring, understanding, and evaluating project requirements to build enterprise data warehouse systems following Agile and Scrum methodologies.

I also designed and built the data warehouse solution to handle large data volume and address complex business data requirements using Informatica and Teradata and many complex services and documented them.

I analyzed the source data and gathered requirements from the business users. I then prepared the technical specifications to develop source system mappings to load data into various tables adhering to the business rules and extensively used XML, web services, and message queues. Next, I designed and created Informatica solutions and Informatica advanced tools. I also implemented the visualizations in Looker.

In this project I:
• Created a data warehouse in Microsoft SQL Server.
• Built end-to-end data pipelines using the Informatica ETL tool.
• Implemented snowflake schema and data marts to create tableau -reports.
• Provided the data reporting functions to the business and technical community using SQL to enable the team to gain insights into various parts of the company.
• Worked extensively on KYC data remediation, was involved in data modeling activities, and suggested design changes.
• Cooperated with the solution architect and senior testers, exploring, understanding, and evaluating project requirements to build enterprise data warehouse systems following Agile and Scrum methodologies.
• Provided design and expertise in developing the company's visualization methodology and the enterprise BI architecture.
• Participated in complex business data requirements using Informatica and MSSQL. Analyzed the source data and gathered requirements from the business users.
• Prepared technical specifications to develop source system mappings to load data into various tables adhering to the business rules.
• Collaborated in preparing the plan and effort estimations required to execute the project.

The project aimed to integrate the Salesforce CRM data into the existing data warehouse built on Teradata with end reports generated in Qlik Sense for each sales representatives' KPIs.

By understanding the existing source system built on Salesforce, I created facts, dimensions, and a star schema representation for the data mart. I worked extensively in the mainframe developing code, analyzed source data (VEEVA), gathered business users' requirements, and prepared technical specifications to build source system mappings to load data into various tables adhering to the business rules.

I was involved in all phases of the SDLC, from the requirement definition, system design, development, testing, and training, to the rollout and warranty support for the production environment.

I also collaborated in preparing the plan and effort estimations required to execute the project and played a key role in helping manage the team and work allocations.

Finally, I was in charge of designing and building Informatica solutions and PDO where required, tuning the performance of the data warehouse operations using Teradata, and developing mappings and reusable transformations in Informatica to facilitate the timely loading of a star schema data.