We provide IT Staff Augmentation Services!

Data Integration Lead/etl Lead/ Technical Manager Resume

SUMMARY

  • Over 11+ years of IT experience in technologies focused in data integration/ migration and BI solutions.
  • Worked on various roles: Integration Lead/ Integration Technical Manager/ Team lead/ Senior developer/ Developer
  • Experience in requirement specification, design, development, testing, analysis, documentation, enhancement, testing and production support.
  • Worked on API integration using ETL tools (Informatica/ SSIS)
  • Worked on Data warehousing/Batch and Data Integration analyst /Dimensional modelling/ ETL development/ Business intelligence (Tableau) /File transfer
  • Participate in release planning. (Enterprise wise release, monthly release)
  • Developed Informatica/SSIS mappings for data flows including SAP, Unix, API Integration, Informatica/SSIS, Netezza, Oracle, Salesforce
  • Worked on Oracle financial products - OFSAA (Oracle Financial Services Analytical Applications)
  • Good knowledge of SAP modules (Job variant, Idocs, orders, customers, claims, invoice, employee)
  • Participate in project kickoff meetings and interact with several business units, DBA, Data modelers on project requirement.
  • Reverse engineering (Java to ETL, JCAPS to ETL, Egate to ETL)
  • Experienced in Java/J2EE (Created advanced mapping in java, Http, web services)
  • Good understanding of Ralph Kimball Dimensional Modeling Star schema methodology and Bill Inman SnowFlake schema methodology.
  • Experience in complete life cycle (SDLC) of Design, Maintenance, Development, Implementation and Enterprise Data Warehouse (EDW).
  • Worked extensively with slowly changing dimensions Type1, Type2 and Type3
  • Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev. environment.
  • Knowledge on all the Power Center components as Power Center Designer, Power Center Repository Manager, Workflow Manager, Workflow Monitor and Informatica Data Quality.
  • Worked on Performance Tuning/ redesigning of existing mappings as well as new ones.
  • Worked on automating the Informatica/ SSIS jobs, Scheduler, Autosys, Tidal and UNIX scripts for automation.
  • Complex and efficient batch design using various technologies. Excellent knowledge on batch designing using various technologies and series of batch
  • Developed UNIX Shell Scripting for better handling of incoming source files and log files
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, BSA, business and developers across multiple disciplines.
  • Excellent communication skills, organization skills and team player. Played lead role at offshore and onshore.
  • Worked on AWS environment for file storage on S3 bucket.
  • Architect/ Manager/ Team lead experience. Provide regular update to higher management on progress and issues. Escalate issues to other teams/vendors and pull them for war room if issues need more attention.

TECHNICAL SKILLS

ETL/Data warehousing: Informatica Power Center 9.X (Design, development, Support), Data modelling, IDQ, SSIS

Databases: Oracle 11g/10g/9i, Teradata, Netezza, MS Access, SQL server

Languages/Interface: XML, SQL, PL/SQL, UNIX Shell Scripting, Java, SAP R/3, Salesforce

Scheduling Tools: Autosys, Cron jobs, Tidal

DB Tools: SQL*Plus, SQL Navigator, SQL query analyzer, Teradata SQL assistance SQL Developer, OFSAA, PCM

Microsoft Tools: MS Office, MS Outlook, MS Visio

Development: Object-Oriented Design, Technical Documentation, Agile Development, Quality Assurance, Solution Architecture, Project Management

BI Tools: Tableau reporting / Dashboard designing

PROFESSIONAL EXPERIENCE

Confidential

Data Integration Lead/ETL Lead/ Technical Manager

Responsibilities:

  • Responsible for project delivery from start to finish.
  • SME for integration / ETL issues.
  • Report to Director /Management for project updates/ hurdles.
  • Work with various business partners and teams within organization to accomplish end results.
  • Set up ETL standard and follow industry best practices.
  • Use ETL tool to extract data from various vendor’s websites using API calls.
  • Lead a team of developer/ BSA
  • Worked on AWS SFTP server / S3 storage to store data.
  • Develop workflow and mappings for Data inbound and outbound.
  • Work with external vendors to understand different systems requirements.
  • Worked with data modeler and DBA in efficient design on Database for ETL data processing.
  • Implement various data warehouse mythologies (Inman - Kimball concepts, star schema, snowflake schema, fact, dimension)
  • Create table, views, procedures, query optimization
  • Participate in requirement reviews
  • Prepare design /run book / support documentation in consultation with project leads
  • ETL development and unit testing, performance improvement
  • Work with release management during DEV, QA and production release.
  • Support UAT and resolve production go live bugs

Environment: and Tools: SSIS, API Integrations, Zappysys tasks, Informatica Power Center V 9.x,10.1, SQL server, AWS, PL/SQL, Flat files, Power Designer, VB scripting, scripting, MS Visio

Confidential

Senior ETL Informatica Power Center Developer/ Data Integration and analyst

Responsibilities:

  • Responsible for data analysis from source and target system.
  • Develop workflow and mappings using informatica power center (V 9.x, 10.x) and Informatica Data Quality.
  • Automate workflow/jobs using tidal scheduling jobs and Unix scripting.
  • Work with external vendors to understand different systems requirements.
  • Worked with data modeler and DBA in efficient design on Database for ETL data processing.
  • Implement various data warehouse mythologies (Inman - Kimball concepts, star schema, snowflake schema, fact, dimension)
  • Create table, views, procedures, query optimization
  • Participate in requirement reviews
  • Prepare design /runbook/ support documentation in consultation with project leads
  • Informatica ETL development and unit testing
  • Work with release management during DEV, QA and production release.
  • Support UAT and resolve production go live bugs
  • Developed UNIX Shell scripts for calling the Informatica mappings and running the tasks.

Environment: and Tools: Informatica Power Center V 9.x,10.1, OFSAA (Oracle), PCM (Oracle cloud), PL/SQL, Oracle, Netezza, Flat files, Power Designer, UNIX shell scripting, Tidal, MS Visio

Confidential

Senior ETL Informatica Power Center Developer/ Data Integration and analyst

Responsibilities:

  • Responsible for requirement gathering with business and system SME for reporting requirements.
  • Develop workflow and mappings using informatica power center V 9.x, 10.x.
  • Experience in RDBMS knowledge of Oracle, MS SQL Server, Data warehouse appliances (Netezza, Teradata), XML, Flat files.
  • Experience using informatica designer, performance tuning, error handling in informatica.
  • Working knowledge of understanding Logical and Physical data models.
  • Sound Data Warehouse knowledge (Inman - Kimball concepts, star schema, snowflake schema, fact, dimension)
  • Create table, views, procedures, query optimization
  • Participate in requirement reviews
  • Prepare design documentation in consultation with project leads
  • Informatica ETL development and unit testing
  • Work with release management during DEV, QA and production release.
  • Support UAT and resolve production go live bugs
  • Automate jobs using tidal job scheduler
  • Developed UNIX Shell scripts for calling the Informatica mappings and running the tasks.
  • Development/Testing of overall workflow cycle to front end (salesforce)

Environment: and tools: Informatica Power Center V 9.x,10.1 PL/SQL, Oracle, Netezza, Flat files, Power Designer, UNIX shell scripting, Tidal, MS Visio, Salesforce

Hire Now