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