Location
PolandRate
$18
/ per hour
Years of experience
4+About
As a Senior ETL Developer at BEC Financial Technologies, I have extensive experience in the Business Intelligence field. My daily tasks include designing Data Vault models, creating mappings in Informatica, and loading data into Netezza and SQL Server. I have developed strong skills in reporting with Qlikview, Power BI, and SharePoint, making me proficient in data representation. My background in planning and monitoring high-budget projects, along with my ability to elicit project requirements and transform business needs into IT solutions, has been enhanced through my experience working with diverse teams. This exposure has given me the opportunity to connect with people of different mentalities and working styles, further enriching my problem-solving abilities in the IT field. In my previous roles, I have worked as an Oracle/ETL Developer at Credit Suisse, where I designed mappings in Informatica, automated tasks using Unix scripts, and designed Power BI dashboards while monitoring EC2 instances on AWS. At Roche, I focused on creating and modifying ETL processes in Informatica and designing DDLs in Teradata. My experience at Volvo Group involved performing ETL processes using SSIS Packages, writing queries in MS SQL and Netezza, and modifying reports using Power BI, Qlikview, and SharePoint. My educational background includes a Master of Computer Applications from Wroclaw University of Science and Technology, a Master's degree in Information Technology from Halmstad University, and a Bachelor of Engineering in Electrical, Electronics, and Communications Engineering from GTU.Tech Stack
ETL, Aginity, Informatica, SAP, SQL ServerExperience
- Designing and creating ETL processes using tools such as Informatica and SSIS, including creating mappings, hubs, links, and satellites to load data into Netezza and SQL Server.
- Designing Data Vault models to structure and organize large datasets for efficient data processing and reporting.
- Automating tasks using Unix scripts and tools like UFT to streamline processes and improve efficiency.
- Developing and modifying reports and dashboards using Power BI, Qlikview, Qliksense, and SharePoint to provide clear and actionable business insights.
- Writing and optimizing queries in MS SQL, Netezza, and Teradata to manage and manipulate data effectively for various business needs.
- Performing manual and automated testing of ETL processes and data marts, writing test plans, and documenting results using tools like HP Quality Center.
- Planning and monitoring high-budget projects, eliciting project requirements, and working closely with diverse teams to transform business needs into IT solutions and ensure successful project delivery.
Employment history
Senior ETL Developer, BEC Financial Technologies
September 2021 - Present
- Designing the Data vault model.
- Creating the mappings in Informatica in the form of Hubs, links and satellites.
- Loading the data into Netezza and SQL server.
Oracle/ETL Developer, Credit Suisse
January 2020 - August 2021
- Designing mappings in Informatica.
- Automating the tasks with the help of Unix scripts.
- Designing the Power BI dashboards.
- \Monitoring the EC2 instances on AWS.
ETL Developer, Roche
August 2019 - October 2019
- Designing the Data Vault model.
- Creating and modifying the ETL process in Informatica.
- Automating the ETL process.
- Designing the DDLs in Teradata.
MSBI Developer, Volvo Group
November 2017 - July 2019
- Performing the ETL process by Creating SSIS Packages in Visual Studio and mappings in Informatica.
- Writing queries in MS SQL management studio and Netezza to view the data or modifying the existing one.
- Creating and Modifying the reports using Power BI,Qlikview and Qliksense.
- Modifying the SharePoint reports (Front end and Back end).
Business Intelligence Tester, Volvo Group
October 2017 - July 2019
- Performing manual testing by writing own SQL queries or based on pre-existing test specifications, in Netezza. This involves testing and re-testing of the data, as new features are added.
- Testing of the Data Mart after understanding the BUSINESS LOGIC.
- Inbound and Outbound testing.
- Documenting the results in the form of test records using HPQC.
- Using UFT tool to automate the process .
- Creating incident reports and communicate about the progress.
- Writing new test plans and modifying existing test plans for both new data and changes to existing data.
Junior ETL Developer, Volvo Group
July 2017 - September 2017
- Performing the ETL process by Creating mappings in Informatica.
- Writing queries in Netezza to view the data or modifying the existing one.
- Modifying the reports using SAP BO
Education history
Wroclaw University of Science and Technology
2015 - 2017
Master of Computer Applications (M.C.A.), Computer Science
Halmstad University
2014 - 2015
Master's degree, Information Technology
GTU
Bachelor of Engineering - BE, Electrical, Electronics and CommunicationsEngineering
We've delighted 83 clients with our IT recruitment and software development services.
Read about a few of them below...