Senior ETL Developer | Team Lead

• Handling and managing Data warehousing system with emphasis on Business Requirements Analysis, Application Design, Development, coding, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems
• Developed complex Teradata SQL code in BTEQ script using OLAP and aggregate functions, analitical functions and recursive CTEs
• Extensive knowledge with Teradata SQL Assistant and Teradata Viewpoint
• Building recursive and iterative algorithms using teradata store procedures and python
• Unix for file handling on server side
• Host on Demand for scheduling and run processes
• Datastage - used as wrapper for scripts triggering
• ALM QC
• SVN and GIT

Basic skills also on cloud computing:

• ADF (Azure Data Factory)
• ADLS
• Python
• Databricks (SparkSQL and PySpark)
• Azure Synapse Analitycs

• Works closely with the business and IT application owners to understand, document and design ETL processes and needs
• Participates in the defining, development and implementation of data warehouse and data mart databases and their content
• Develops and maintains mapping logic to move data content from varied sources systems to the data warehouse / data marts
• ETL and data conversion design / implementation for other data integration scenarios
• Design, Develop, Test, Optimize and Deploy ODI packages and Oracle stored procedures / packages to perform all ETL related functions
• Plan and coordinate ETL and database roll-outs with project team members, development and database engineers
• Provide support, maintenance and issue investigation and resolution for ETL processes
• Design and implement BI technical and operational architecture / frameworks
• End-user report development, from requirement gathering to design, build, test, deploy

• Performance Tuning of sources, Targets, mappings and SQL queries in transformations
• Created BTEQ scripts to extract data from warehouse for downstream applications
• Develop ETL programs with an enterprise-grade tool (Datastage)
• Contributes substantially to the DataWarehouse ETL development lifecycle, including developing and testing ETL programs
• Hands-on database development with SQL and stored procedures, such as Teradata procedures or similar ones
• Developing data transformations involving SQL, data-type conversions, joins, filters, translations, aggregation, de-/normalization and custom database stored procedures
• Working with Teradata Services, Teradata SQL Developer, Teradata Viewpoint
• Involvement in database optimization
• Implemented AGILE methodology for deliveries
• Generated Ad-Hoc reports for the users

• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document
• Extensively used SQL/PL SQL queries for data validation and backend testing
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Develop test plans and scripts, prepare test data, reconcile data sources and execute functional tests
• Supporting multiple code branches, building and delivering releases
• Acting as lead of testing activities
• Managing time and tasks to provide visibility
• Experience working with IBM Cognos (Reporting)
• Experience working with ETL systems (Oracle Warehouse Builder, Oracle Workflow)
• Experience working with Databases (Oracle Database)
• Experience working with BugTracking systems(QualityCenter & Application Lifecycle Management)
• Multiple tasks test database administration
• SQL tuning(working with hints)
• RDBMS Concepts
• ETL Concepts
• Working with database objects: Packages, Functions, Procedures, Anonymous Blocks, etc
• Interviewing potential candidates in terms of technical database knowledge
• Making planning and estimating various projects
• Knowledge transfer to juniors
• Perform ETL and data manipulation techniques
• Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document
• Support provided in running processes on closing banking day on test environments

• Develop, improve and extend automated test frameworks and test scripts(creation numerous tasks of scripting / programming (SQL/PL SQL) via QTP Automation)
• Maintaining and managing testing environments
• Tracking and managing database sessions
• Checks regarding the successful deployment of patches / releases
• Start/Stop the SQL environments engines
• Maintaining automatic jobs (dbms_jobs.submit)
• Maintaining automatic execution processes(Operational Core Banking) on test environments
• Analysis on tables, schemas and indexes
• Develop scripts for bringing data from production to test environment(database links)
• Populating database with test data or real data after environment rewriting

Created a C# application to support the following requirements:

• Oracle Data Transfer - Wizcount
• Export revenue data to Oracle and handle calculation errors
• Import customer contracts and related rates from Oracle into the accounting and management program, including error correction
• Transfer promissory notes and checks into the Oracle application
• Analyze and correct duplicate payments, penalties, contract increases or cancellations
• Support applications using bank remittance statements from Banc Post, RBS Bank, Credit Europe Bank, and Transilvania Bank
• Generate reports (Report Viewer) such as revenue for a period and cash collections for major clients in Oracle
• Analyze uncollected amounts after book closing and apply invoice discounts
• Contributed to website redesign (CSS, XML, HTML)