SUMMARY

• Over 9 years of IT Experience in Software Analysis, Design, Development and Production Support using ETL Technologies and Data warehousing applications.
• Experience as ETL Architectural Designer and Lead Developer in multiple Ab Initio and Talend projects.
• Excellent design, development and production support skills in Ab Initio, Talend, SSIS, Oracle, SQL Server and Unix applications.
• Experienced in ETL/ELT framework for processing complex warehouses and large datasets of different forms including structured, semi - structured and unstructured data.
• Strong Data analysis, transformation and business reporting skills and experience with performance tuning and troubleshooting.
• Experience as Lead Developer in design and implement complex Talend jobs and use of extensive Talend data integration components.
• Experience in Data Integration projects using ETL Ab Initio and Salesforce CRM Solution.
• Experience in various migration projects using ETL Ab Initio, DataStage and Talend Data Integration tools.
• Worked as ETL Administration for Ab Initio and DataStage tools.
• Experience in developing data integration and workflow applications using SSIS tool.
• Have extensive knowledge and experience in Oracle and MS SQL - Data Modelling, Designing, Database maintenance and Entity Relationship model.
• Extensive knowledge in Unix Shell scripting.
• Knowledge on Azure of cloud concepts, Azure services, Azure workloads, security and privacy in Azure, as well as Azure pricing and support.
• Knowledge on how to migrate on-premise data to Azure using virtual networks, VPN and Express Route. Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud using Azure Data Platform services such as Azure Data Lake, Data Factory, SQL Data Warehouse.
• Worked as a Technical lead with onshore, offshore and nearshore model of work.
• Extensive knowledge and Experience in ITSM Best practices and solutions.
• Have strong interpersonal and communication skills with the ability to collaborate and work as a team. Self-motivated, quick learner and adaptable to new technologies.
• Have excellent time management and organizational skills with the ability to work on multiple projects and to meet business needs & timelines.

TECHNICAL SKILLS

ETL Technologies: Ab Initio, Talend Data Integration, SQL Server Integration Services, IBM Infosphere DataStage, Informatica Power Center

Cloud Platform: Microsoft Azure, Salesforce.com

Reporting Tools: Tableau, Business Objects

Databases: Oracle, SQL Server Database, Teradata

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows, UNIX AIX, Linux

IT Service Tools: JIRA, IT Service Management Tools, BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential

LEAD DEVELOPER / ARCHITECT

Responsibilities:

• Primary responsible as a role of Technical lead and SME for solution and setup new Talend Data Integration platform for migration from Ab Initio.
• Develop and implement technical solution to migrate sensitive data from Ab Initio platform to Talend platform.
• Design and develop the framework for Talend project in coordination with customer and business.
• Evaluate existing Ab Initio subject areas and determines ETL strategy, data management systems and integration techniques to meet business needs.
• Coordinate with management for project cost and time estimate and resource acquisition.
• Set up Talend projects, File system, Data storage in coordination with Talend Admin team.
• Set up infrastructure and network path for Integration of Talend Tool with Salesforce cloud environment.
• Develop many complex Talend jobs and use of extensive data integration components for data transformations and data exchange between database servers and various other systems including Salesforce cloud and Flat file structures.
• Coordinate coding, testing, implementation, integration and documentation of solution.
• Design and Develop of extensive Talend jobs using Talend Data integration tool.
• Set up new databases for data replication and parallel testing of existing Ab Initio with Talend infrastructure.
• Optimize the Talend codes for better performance and ensure that errors are detected to avoid production outages and meet business defined SLA timelines.
• Plan and perform production deployment and cutover by coordinating with customer and stakeholders without impacting business SLA.

SENIOR ETL DEVELOPER

Confidential

Responsibilities:

• Create detailed technical design to communicate solution by understanding and analyzing the business requirements.
• Solution includes ETL technologies - Ab Initio and SSIS, Microsoft SQL Server, SQL Databases and Unix.
• Use of complex SQL with multiple joins to extract differential data from operational database tables.
• Perform SQL extract and update operation without impacting the performance of real-time replicated database.
• Design, build and implement Ab Initio transformation for processing of unstructured data into meaning business reports.
• Create SSIS package to maintain large volume of data in SQL server database tables.
• Design solution to support upstream and third-party downstream vendor as per their requirement and provide proactive support.

AB INITIO DEVELOPER

Confidential

Responsibilities:

• Analyze source data and design solution in multiple steps to achieve meaningful data as required by business.
• Solution includes Ab Initio, Oracle database design and Unix Shell scripting.
• Develop Unix shell script to extract log data from multiple application servers and instances.
• Develop Ab Initio solution to break huge volume of log data to specific timeframe using multilevel loops and parameters.
• Use multiple vector transformations in Ab Initio to break and divide huge raw data into smaller logical groups of data.
• Develop Ab Initio plans, subplans, graphs to transform data and load into multiple tables in sequential and logical manner supporting the database design.
• Designing Oracle database tables using entity - relationship model to support the loading and extraction of application data.
• Use of oracle database table partition and rotation concept to maintain right volume of data as per business need.