SUMMARY:

• 9+ years of professional experience in Information Technology.
• 8+ years of experience in ETL technologies including Informatica and Talend.
• 5+ years of experience in database design and support using SQL and PL/SQL for Oracle and MS - SQL .
• Microsoft Certified Professional (MCP) in SQL Server 2012 and Visual Basic.
• Experience with major clients in financials, healthcare and Telecom.
• Expertise in data modeling using Erwin Data Modeler.
• Knowledge of reporting tools SAP BO, IBM Cognos and Tableau.
• Experience in key PL/SQL concepts including Stored Procedures, Packages, Indexes and performance tuning.
• Experience with programming languages like C, C++, Visual Basic and Java.
• Experience in full System Development Life Cycle(SDLC) Using Water Fall Model, Agile, Iterative and Test Driven Development.
• Experience in directly interfacing with customer team to support critical customer issues.
• Quick learner and excellent team player with ability to meet tight schedules.

TECHNICAL SKILLS:

ETL Tools: Talend, Informatica, DataStage

Data Modeling: Erwin

Reporting Tools: Tableau, SAP Business Objects, IBM Cognos

RDBMS: MySQL, Oracle, DB2, SQL Server

Web Technologies: HTML, Java Script, XML

Languages: C, C++, Java, Visual Basic, PowerBuilder

Operating Systems: Windows XP/Vista/2000/NT/8, Unix

Scripting: Unix Shell Scripting

WORK EXPERIENCE:

ETL Developer, Richardson, TX

Confidential

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design discussions, development and unit testing
• Developed ETL processes using powerful data management tool Talend to convert and integrate data into dimension and fact tables used for Dashboard.
• Developed parsers for CISCO WLC/AP commands using Talend
• Developed ETL processes for T-Mobile smart certification to analyze network KPIs like call and data performance, video quality, radio quality, etc
• Developed mappings to process Nokia’s scanner device data to derive KPIs like RSRP, RSRQ, SINR, etc for LTE and WCDMA networks
• Extensively used Talend components like tprejob, tpostjob, tmap, tjoin, tmysqlinput, tymysqloutput, tForeachtFlowToIterate,tFileInputDelimited, tFileInputPositional, tAggregateRow,tAggregateSortedRow,tMemorizeRows, tBufferInput, tBufferOutput,tSetGlobalVar, tJavaRow etc
• Created metadata for DB Connections, File delimited and File positional
• Used contexts for passing parameters like start date, end date, timestamp, devices list and job identifiers between parent and child jobs
• Performed Unit Testing, User Acceptance testing to check whether the output data is accurate according to the user requirements.
• Developed new SQL stored procedures, functions and triggers to satisfy new customer requirements
• Optimized query performance by creating indices.
• Created fact and dimension tables with cluster and non-cluster indices on columns.
• Developed advanced SQL queries for data validation.
• Followed Agile Scrum methodology for product development; Used JIRA to capture, organize team's issues and to follow team activity during QA and Product Deployment.
• Used Unfuddle and BitBucket Source Code Management system for version controls
• Used Atlassian Confluence for documentation repositories, Jira for project management and defects management
• Collaborated with remote ETL teams located in India

Environment: Talend 6.2, MySQL 5.7, Eclipse, Java 8, Unfuddle, BitBucket, Confluence, Jira.

Data Engineer, Louisville, KY

Responsibilities:

• Responsible for extracting members’ information from heterogeneous sources including flat files, Excel and PDF, transforming and loading them into Oracle database
• Used Informatica PowerCenter 9.1 for ETL processes and PL/SQL for database interactions
• Actively verified if staged data complied with the rules in Business Requirements Documents
• Involved in loading the data from source files to database using Transformation and Cleansing Logic built with Informatica
• Used and often extended the SQL scripts to perform comprehensive validation of loaded data
• Actively supported routing and resolution of issues from clients
• Supported Business Analysts in meetings with clients while acquiring new requirements and changes to clients’ data formats
• Used Informatica 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Based on requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter,Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping
• Proficient in using advanced features in Informatica, including complex lookups, Slowly Changing Dimensions, update strategy, Push Down Optimization, reusable transformations and PMCMD commands.
• Interacted with Java Development team for resolving issues related to Javacode used in encrypting sensitive information
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Participated in Agile processes including daily Scrum meetings

Environment: Informatica 9.1, Oracle 10g, JIRA6, WinSCP, MS Office Excel/Word, Helpdesk

ETL Developer

Confidential, New York

Responsibilities:

• Involved in design, development and maintenance of ETL procedures.
• Designed ETL processes using Informatica to load data from PDF and flat files.
• Developed various mappings and transformations using Informatica Designer.
• Used Mapping designer and Mapplets to generate different mappings for different loads.
• Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy.
• Used Debugger in troubleshooting the existing mappings.
• Used Work Flow Manager and Monitor to schedule and monitor different sessions of loading.
• Used the PL/SQL procedures for data validation.
• Tuned performance of mappings and SQL queries in transformations.
• Performed unit testing, integration testing and system testing of the solution.
• Created reports in BO reporter using Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulae etc.

Environment: Informatica Power Center/Power Mart 5.x/6.x, Oracle 9i/8i, Business Objects 5.1

ETL Support Engineer

Confidential

Responsibilities:

• Extended ETL tools developed using Visual Basic to support new business requirements.
• Updated the database schema to store additional details for each financial company.
• Added new verification logic in the VB tool to flag errors in input data.
• Performed data integrity checks on the warehoused data using stored procedures.
• Generated reports using in-house Remote Remittance Parser tool.
• Identified the root cause and resolved problems in the ETL tool.
• Directly interfaced with the customers to acquire client’s data.
• Uploaded the reports to the FTP server of the clients.

Environment: MS SQL Server, VisualBasic 5.0, MS-EXCEL.

Database Developer

Confidential

Responsibilities:

• Created SQL and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created database triggers to maintain the database security.
• Optimized the SQL queries for improved performance.
• Created reports using Crystal reports.
• Documented the technical specification of the reports and tested the generated reports.
• Prepared test plans for various modules.
• Prepared user manual and technical support manuals.

Environment: Oracle 8, SQL, PL/SQL, Crystal Reports, Windows NT.