• Analyze the raw data coming from various source systems , identify the best contact points (emails or phone numbers) and send the extracts to the digital marketing team .
• Gather requirements from marketing team to source data , identify transformation rules and produce the reports
• Identify KPI and report them periodically.
• Maintain data mapping documents and data dictionaries.
• Do gap analysis between various source systems to identify best possible data artifacts for the digital marketing team
• Create rules to assign weightage to emails , consolidate & cleanse the customer , address and contact point data from source systems and across the product lines.
• Identify best possible contact channels which can be used for sending marketing Audits & surveys to customer
• Work in Scrum team to create backlog items for the development team
• Analyze data in excel

Responsibilities:

• Data analysis of Canada reporting systems, requirements gathering
• Analysis of data warehouse data model. Enhance and create new DB objects
• Shell scripting to process data files
• Create and enhance ETL Informatica components
• Create and enhance Tidal scheduling components
• Data comparison between source and integrated systems
• User acceptance testing

Responsibilities:

• Requirements gathering with data analysts to understand existing sql server logic
• Data Architecture, Source system data analysis, data lineage mapping, creating transformation logic mapping documents.
  • Data dictionary preparation, data lineage mapping, process flow
• Architecture of ETL process in oracle pl/sql
• Daily Stand up meetings and status review.
• Development of oracle components, packages, procedures and functions.
• Tuning of sql queries, deployment into various test environments and production.
• User support. Create complex queries based on user requirement
• Production environment tuning and support of newly developed application in production.

Responsibilities:

• • Requirements gathering
  • Data Architecture, Source system data analysis, creating transformation logic
  • Data dictionary preparation, data lineage mapping, process flow
  • ETL Tech lead. Architecture of ETL process
  • Daily Stand up meetings and status review.
  • Informatica, Mappings design and SQL server Stored Procs & Unix scriptindevelopment and deployments co-ordination
• • User support. Create complex queries based on user requirement
  • Process tuning

Responsibilities:

• ETL Tech lead , Requirements gathering
• Data Gap analysis and Master data management
• Logical and physical data modelling (Star Schema Dimensions/Facts)
• Data Architecture and gather and update the Meta data
• Informatica , Oracle Pl/SQL Stored Procs & Unix development and deployments
• ETL and DB Performance tuning. Developing adhoc queries on warehouse data
• User support