Location
CzechiaRate
Years of experience
15+About
Experienced MSC ETL DWH BI Senior Consultant with over 15 years in the IT industry, specializing in ETL, BI, and data warehousing. Proficient in a range of BI solutions, having worked with prominent clients such as Gates Foundation, DFW Dallas Airport, and Lidl Europe. Holds extensive certifications in IBM DataStage and MicroStrategy, showcasing a deep technical expertise. Proven track record in leading complex data integration projects, with key skills in SSIS, Informatica, and DataStage for ETL development. Demonstrated proficiency in Oracle, SQL Server, Big Data technologies like Hadoop, and other database management systems including Teradata and DB2. Adept at managing ETL processes, from designing data extraction to optimizing data quality and performance. Industry experience spans retail, banking, finance, and logistics, among others. Known for excellent problem-solving skills, effective communication, and a strong collaborative approach. Fluent in English with limited working proficiency in German and French. Holds a Master’s degree in Computer Science from Politechnika Częstochowska, and an Engineer's degree in Information Technology from Techniczne Zakłady Naukowe Czestochowa. Enthusiastic about continuous learning and taking on new challenges.Tech Stack
ETL, Big Data, C#, Java, Oracle, SharePoint, SQL, SQL Server, Ssis, Teradata, XMLExperience
- Led complex data integration projects across multiple industries, including retail, banking, finance, and logistics.
- Developed and optimized ETL processes using tools such as SSIS, Informatica, and DataStage.
- Managed data warehousing solutions with proficiency in Oracle, SQL Server, Hadoop, Teradata, and DB2.
- Delivered BI solutions for high-profile clients, including Gates Foundation, DFW Dallas Airport, and Lidl Europe.
- Certified in IBM DataStage and MicroStrategy, showcasing expertise in ETL and BI tools.
- Analyzed and resolved data quality issues, ensuring high accuracy and reliability in data reporting.
- Collaborated with cross-functional teams to design and implement data extraction, transformation, and loading processes.
Employment history
• Analyzed PL/SQL code across source, staging, and presentation areas.
• Developed and maintained DataStage ETL jobs for complex customer data sources.
• Managed development in Test, Int, and PROD environments.
• Supervised ETL modules including Designer, Director, and Quality Stage.
• Imported and exported data to in-house reporting systems.
• Analyzed and optimized Oracle 11g/12c PL/SQL and DB2 databases.
• Documented ETL processes and provided training to junior developers.
• Developed SSIS/CDC ETL processes.
• Administered SQL Server 2014 databases.
• Integrated data into Teradata target databases.
• Analyzed and fixed ETL workflow bugs and optimized performance.
• Proposed and implemented Upsert strategies and Sort transformation optimizations.
• Managed DEV, UAT, and PROD SSIS environment migrations.
• Conducted performance tuning and optimization of SQL queries.
• Collaborated with cross-functional teams to ensure seamless data integration.
• Maintained and developed new mappings in Informatica 9.x.
• Optimized existing SQL Server scripts for performance.
• Addressed data quality issues for TV, VOD, HULU, and Foxnow data.
• Collaborated with cross-functional teams to ensure data integrity.
• Conducted code reviews and provided feedback to improve code quality.
• Created detailed documentation for ETL processes and data flows.
• Developed DataStage ETL jobs and workflows.
• Designed staging and target tables based on business requirements.
• Analyzed data warehouse models and provided detailed documentation.
• Implemented data extraction jobs and automated scheduling.
• Ensured data accuracy and consistency during ETL processes.
• Integrated multiple data sources into the MicroStrategy reporting system using SSIS ETL.
• Administered SQL Server 2012 databases.
• Analyzed and fixed ETL mapping, session, and workflow bugs.
• Proposed solutions for ETL workflow optimization and data quality issues.
• Developed and maintained SSIS packages for data migration.
• Created technical documentation and conducted user training sessions.
• Developed SSIS ETL processes and best practices.
• Administered SQL Server 2012 databases.
• Integrated data into MicroStrategy reporting systems.
• Analyzed and resolved data quality issues.
• Developed SSIS packages for data transformation and loading.
• Provided technical support and troubleshooting for ETL processes.
• Developed DataStage ETL jobs and workflows.
• Imported data to in-house reporting systems.
• Developed SQL Server 2012 and Oracle data warehouse models.
• Proposed and executed POC for building PDC algorithms within MicroStrategy.
• Ensured data integrity and consistency during ETL processes.
• Collaborated with stakeholders to gather requirements and provide solutions.
• Developed Informatica 9.0 ETL processes.
• Administered Oracle databases.
• Analyzed and fixed ETL mapping, session, and workflow bugs.
• Designed and ran SQL scripts for source, staging, and target tables.
• Conducted data quality checks and resolved data discrepancies.
• Provided documentation and training for ETL processes.
• Developed ETL processes using Pentaho.
• Created MicroStrategy schema and reports/dashboards.
• Conducted training sessions for senior BI staff.
• Loaded mockup data and developed cloud-based MicroStrategy platforms.
• Ensured data accuracy and consistency during ETL processes.
• Provided technical support and troubleshooting for ETL and BI tools.
• ETL development of fully automatic system to extract data from XLS files and
load to MySQL database
• Remote Access of Job execution configuration
• Complete documentation, FAQ and instructions for users creation
• Completed workshop for educational purposes
• Supported Oracle aviation DWH systems.
• Developed ETL logic and J2EE reporting applications.
• Analyzed changes in data warehouse models.
• Provided first-line technical support and created system schemas.
• Conducted performance tuning and optimization of ETL processes.
• Collaborated with stakeholders to gather requirements and provide solutions.
• J2EE application (report tool for users) development, troubleshooting
• Tested GSM/GPRS/EDGE platform bugs.
• Conducted regression and user acceptance tests.
• Developed documentation for Java/J2EE technologies.
• Assisted in the integration of software components.
• Ensured quality and compliance with industry standards.
• Collaborated with cross-functional teams to resolve technical issues.
Education history
“80+ clients have experienced exceptional results from our IT recruitment and software development services.”
Similar blind CVs/resumes
Czechia
Billing Specialist Resume Sample
Finance
Accounting
Linux administrator
Microsoft Excel
Salesforce Object Query Language
SQL
Poland
Swagger Developer Resume Sample
Swagger
Angular
Bash
Docker
Git
Hibernate
Java
JavaScript
Kafka
Kubernetes
Microservices
MySQL
Oracle
PL/SQL
Python
Spring Framework
Poland
Work From Home Resume Sample
.NET
Angular
ASP.NET
C#
Microservices
MS SQL
TypeScript
Poland
Sample COO Resume
ERP
CRM
Google Analytics
Jira
Marketing
MS SQL
Oracle
Power BI
Project Management
ServiceNow
Workday
Czechia
Senior IT Technical Project Manager - Resume Sample in PDF
PM
Email copied
And many other regional partners across Latin and North America, as well as Central and Eastern Europe. Let's talk.
Consulting and tech recruitment.
I agree and accept that DevsData LLC will improve the user experience by collecting, analyzing, and cataloging information about the internet addresses my devices have connected to, as well as details about my devices’ specifications and software versions, and by making automated decisions (not involving sensitive data). This agreement remains in effect for the legally binding period or until either party withdraws. Withdrawal will result in the removal of the user’s data. For further details, please see our privacy policy.
We use cookies to provide the best experience for you.
More about cookie policy
Book a call with our team
For software development projects, minimum engagement is $15,000.
Best back-end engineers I've ever worked with.
“I interviewed about a dozen different firms. DevsData LLC is truly exceptional – their backend developers are some of the best I’ve ever worked with. I’ve worked with a lot of very well-qualified developers, locally in San Francisco, and remotely, so that is not a compliment I offer lightly. I appreciate their depth of knowledge and their ability to get things done quickly.”
Nicholas Johnson
CEO of Orange Charger LLC,
Ex-Tesla Engineer,
Mentor at YCombinator
Tailored recruitment process, trusted market expertise.
“DevsData reached out to us, as we’ve been looking to grow our engineering team in Europe and Poland. Communicating efficiently and professionally, DevsData made a strong impression with their understanding of the recruitment challenges we were facing. They designed a tailored recruitment process for our needs. I was impressed with the technical depth of their approach.”
Karim Butt
Co-Founder & CTO at GlossGenius, Inc.
Outstanding vendor, 21 engineers hired.
“Out of all the vendors we work with, DevsData clearly stands out. The quality of developers they deliver is beyond what we've received from any other vendor, and they've been able to send profile recommendations very quickly. I'm happy to be their reference for other companies from Israel and talk about their recruitment abilities and what they delivered for us.”
Ran Eyal
Senior Manager at
ZIM Integrated
Shipping Services Ltd.
Proactive partner, exceptional results.
“DevsData demonstrated a strong degree of proactivity, taking time to thoroughly understand the problem and business perspective, and continuously suggesting performance and usability enhancements. Their app exceeded my expectations. I've worked with DevsData on numerous projects over the last 3 years and I'm very happy. Being both responsive and honest in communication.”
Jonas Lee
Partner & Executive VP of Verus,
Financial LLC, Investor,
& Serial Entrepreneur
Acknowledgments
