10/16/2024 updated


100 % available
Experienced ETL Developer / SQL Developer with Data Warehousing Expertise
Letterkenny, Ireland
Ireland
Bachelor of EngineeringAmazon Web ServicesData AnalysisAutomationBig DataBusiness Process ImprovementBusiness RequirementsCloud ComputingComputer ProgrammingDatabasesExtract Transform Load (ETL)Data ManagementData ModelingData WarehousingDatabase DevelopmentProgramming Tools
Data Warehousing
Extensive experience in data warehousing analysis, design, and development using Informatica Power Center and Teradata.
Database Development
Proficient in developing database objects like Tables, Views, and Stored Procedures, with a focus on business requirements analysis.
SQL and Data Analysis
Strong skills in SQL query writing and data analysis, particularly using tools like Snowflake and Netezza.
ETL Development
Expertise in ETL processes using Informatica PowerCenter, including complex mappings and performance tuning.
Big Data Technologies
Familiarity with big data technologies and AWS cloud services, holding an AWS Certified Cloud Practitioner certification.
Programming and Scripting
Knowledge of various programming tools including Python, PL/SQL, and automation scripting for process optimization.
Data Modeling
Experience in data modeling, requirements analysis, and creation of database objects for efficient data management.
Extensive experience in data warehousing analysis, design, and development using Informatica Power Center and Teradata.
Database Development
Proficient in developing database objects like Tables, Views, and Stored Procedures, with a focus on business requirements analysis.
SQL and Data Analysis
Strong skills in SQL query writing and data analysis, particularly using tools like Snowflake and Netezza.
ETL Development
Expertise in ETL processes using Informatica PowerCenter, including complex mappings and performance tuning.
Big Data Technologies
Familiarity with big data technologies and AWS cloud services, holding an AWS Certified Cloud Practitioner certification.
Programming and Scripting
Knowledge of various programming tools including Python, PL/SQL, and automation scripting for process optimization.
Data Modeling
Experience in data modeling, requirements analysis, and creation of database objects for efficient data management.
Experience
Professional experience10+ years
Freelancer since2024
Languages
EnglishFluent
Project history
Test Data Management and Sanitization (ETL developer)
TDMS is about data masking which involves identifying the customer's PII information and the
data is encrypted and loaded into the Teradata warehouse using Informatica mappings and
workflows.
● Extensively worked on developing ETL for supporting Data Extraction, transformation
and loading using Informatica Powercenter and unit testing.
● Developed complex mappings using RANK,FILTER,SORTER,EXPRESSION,LOOKUP &
AGGREGATOR transformations.
● Performance tuning of SQL and Informatica mappings.
● Created automated scripts for repeated processes which reduced 30% of manual work.
Client Reference Data (SQL developer/Module Lead)
Client Reference Data (CRD) databases hold information of various accounts, account holders,
parties, party roles and all other necessary information to easily identify a user within an
organization. Interacted with business users and clients to understand the business
requirements.
● Worked on data modeling requirement analysis and creation of database objects like
tables, views, stored procedures.
● Handled production turnover activities like creating run book for release teams,
providing On call support and solutions for production issues.
● knowledge transition between different teams, maintaining the knowledge documents
and mentoring the junior associates.
● Handled the BAU module within the team, assigning work to team members and status
reporting using Agile methods.
Operations Dashboard (SQL Developer/Lead)
Airport Operations database is developed to calculate the RAG status of various activities
occurring in the airport to enable the airport managers to track and take key decisions in airport
operations.
● Worked on converting the Hadoop Analytical queries to Oracle compliant queries.
● Involved in the development, unit testing and review of Oracle PL/SQL Stored
Procedures.
● Ability to manage project management activities along with the assigned technical
work.
● Worked on very critical deadlines in the project and managed the team and work to
achieve deliverables on time.
Global Financial Transaction System (ETL developer)
This data integration program collects data from Credit Card Customers and stores them into a data
warehouse. Unix data files are processed using Teradata BTEQ queries and Datastage jobs.
● Analyzing the Business requirements from the BRD and interacting with Business
Analyst to understand the requirements.
● Development and maintenance of database objects, Teradata queries as per the
requirement.
● Performing Unit test, creation of Unit test documents and supporting the testing team
in their queries related to requirements.
● Mentoring and training junior associates.
● Maintaining Knowledge documents and imparting knowledge sessions at account level.
TFS data Analytics and Reporting (SQL Developer / Data Analyst )
TFS D&A project is a data integration program which collects data about its customer loan
details. It holds details about the retails and lease accounts of its customer and other sensitive
information.Files from external sources are put into Unix Server and it is loaded into Snowflake
cloud warehouse using Informatica.
● Development of ETL change requests, sql queries and in generating reports for the
business user.
● Analyzing the root cause for data issues reported by the users, by debugging the
Informatica mappings and workflows.
● Proactively identifying the issue causing datasets
TDMS is about data masking which involves identifying the customer's PII information and the
data is encrypted and loaded into the Teradata warehouse using Informatica mappings and
workflows.
● Extensively worked on developing ETL for supporting Data Extraction, transformation
and loading using Informatica Powercenter and unit testing.
● Developed complex mappings using RANK,FILTER,SORTER,EXPRESSION,LOOKUP &
AGGREGATOR transformations.
● Performance tuning of SQL and Informatica mappings.
● Created automated scripts for repeated processes which reduced 30% of manual work.
Client Reference Data (SQL developer/Module Lead)
Client Reference Data (CRD) databases hold information of various accounts, account holders,
parties, party roles and all other necessary information to easily identify a user within an
organization. Interacted with business users and clients to understand the business
requirements.
● Worked on data modeling requirement analysis and creation of database objects like
tables, views, stored procedures.
● Handled production turnover activities like creating run book for release teams,
providing On call support and solutions for production issues.
● knowledge transition between different teams, maintaining the knowledge documents
and mentoring the junior associates.
● Handled the BAU module within the team, assigning work to team members and status
reporting using Agile methods.
Operations Dashboard (SQL Developer/Lead)
Airport Operations database is developed to calculate the RAG status of various activities
occurring in the airport to enable the airport managers to track and take key decisions in airport
operations.
● Worked on converting the Hadoop Analytical queries to Oracle compliant queries.
● Involved in the development, unit testing and review of Oracle PL/SQL Stored
Procedures.
● Ability to manage project management activities along with the assigned technical
work.
● Worked on very critical deadlines in the project and managed the team and work to
achieve deliverables on time.
Global Financial Transaction System (ETL developer)
This data integration program collects data from Credit Card Customers and stores them into a data
warehouse. Unix data files are processed using Teradata BTEQ queries and Datastage jobs.
● Analyzing the Business requirements from the BRD and interacting with Business
Analyst to understand the requirements.
● Development and maintenance of database objects, Teradata queries as per the
requirement.
● Performing Unit test, creation of Unit test documents and supporting the testing team
in their queries related to requirements.
● Mentoring and training junior associates.
● Maintaining Knowledge documents and imparting knowledge sessions at account level.
TFS data Analytics and Reporting (SQL Developer / Data Analyst )
TFS D&A project is a data integration program which collects data about its customer loan
details. It holds details about the retails and lease accounts of its customer and other sensitive
information.Files from external sources are put into Unix Server and it is loaded into Snowflake
cloud warehouse using Informatica.
● Development of ETL change requests, sql queries and in generating reports for the
business user.
● Analyzing the root cause for data issues reported by the users, by debugging the
Informatica mappings and workflows.
● Proactively identifying the issue causing datasets