SUMMARY

• Overall 5+ Years of IT experience that involves Development in various Databases and Design.
• Extensive experience in design and development of Complex Mappings, Reusable Objects (Mappings, Lookups, Transformations, Tasks), transformations, extractions and loads.
• Expert level development skills with Informatica Client Tools.
• Experience in creating Tables, Stored Procedures, Views, Indexes, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules
• Proficient knowledge and hands - on experience in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes.
• Expert in MS SQL Server Development with various domains like MS SQL Server 2016-2012 and Microsoft BI suite of products like SSIS, SSRS, SSAS, and Power BI
• Good knowledge of Normalization and Relational Database Management Systems.
• Good understanding of database concepts (OLTP).
• Good knowledge of software development life cycle (SDLC) process along with good analytical, programming and problem-solving skills.
• Knowledge of full lifecycle development for building a Data Warehouse.
• Good Experience in writing PowerShell and Python scripts to parse documents run the Informatica workflows, and controlling the ETL flow.
• End to End Salesforce Data Integration using Informatica Intelligent Cloud Service.
• Experience in writing manual test scripts and logging defects using Quality Center and JIRA.
• Experience in scripting T-SQL queries, complex stored procedures, user defined functions (UDF)
• Good Experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
• Capable of forming and maintaining positive and productive work relationships Ftest in internal/external and team environments
• Excellent written and oral communications, analytical and problem-solving skills and good team player, ability to work independently and well-organized.
• Experience in using Informatica Power Center Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Worked with Informatica Cloud/Power Center to create Source /Target connections, monitor, and synchronize the data in SFDC.
• Experience in using Informatica PowerCenter for (ETL) extraction, transformation and loading data
• Excellent communication and interpersonal skills with user and client interaction experience

TECHNICAL SKILLS

Programming Languages: C#, SQL, T-SQL, Java

Web Technologies: HTML5, CSS, JavaScript.

Databases: MS SQL Server, MySQL, PostgreSQL

BI/ETL Tools: SSIS, SSRS, SSAS, Informatica PowerCenter/Cloud, Tableau

CRM: SALESFORCE

Operating Systems: Windows XP/7/8/10, UNIX, PowerShell

IDE: SSMS, BIDS, MS Visual Studio, MYSQL workbench, PG Admin 4.3

Bug Tracking: JIRA, TFS

PROFESSIONAL EXPERIENCE

Confidential, LA, CA

SQL/Informatica ETL Developer

Responsibilities:

• Provide recommendations and expertise of data integration and ETL methodologies.
• Responsible to analyze UltiPro Interfaces and Created design specification and technical specifications based on functional requirements/Analysis.
• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud
• Convert extraction logic from data base technologies like SQL server, MY SQL, PostgreSQL
• Data cleansing prior to loading it into the target system
• Convert specifications to programs and data mapping in an ETL Informatica Cloud environment
• Utilized SQL and T-SQL programming to develop relational databases.
• Writing complex queries and ensuring the integrity of data is maintained cross platforms like MYSQL, SQL Server, and Salesforce.
• Designed the ETL for consolidated reporting from Salesforce, legacy DB and other data sources.
• Documenting technical and functional specifics and working closely with the Development and cross-functional technology groups.
• Support, maintain and enhance existing ETL process built in Informatica Cloud and SSIS & SSRS.
• Developing, maintaining, and enhancing Informatica Cloud Mappings, Task Flows, and processes (Data Synchronization, Data replication).
• Developed PowerShell/Python scripts to run the Informatica tasks and controlling the ETL flow.
• Integrating multiple cloud applications Knowledge of RDBMS platforms SQL Server, MYSQL, PostgreSQL.
• Extract and mine raw datasets to understand, manipulate and analyze complex data, design databases, produce reports and perform analytics.
• Responsible for creating the multiple reports on Tableau.
• Minimized data refresh lags between systems and to report timely data.
• Develop reusable integration components, transformation, logging processes.
• Support system and user acceptance testing activities, including issue resolution.

Environment: Informatica cloud, SALESFORCE, MySQL, PostgreSQL, MS SQL Server 2008/R2/2012, SSRS, SSIS, Tableau, Data Quality Services, Excel, XML, Jira

Confidential, Rochester, NY

SQL/ETL Developer

Responsibilities:

• Coordinated with business users to understand the business needs and implemented functional solutions using ETL process to convert data from various sources and load into Data warehouse for analysis.
• Translated requirements and high-level design into detailed functional design specifications.
• Extracted data from various centers with the data in different systems including SQL Server, Flat files and loaded the data into Teradata staging using Informatica PowerCenter 9.5.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Verified the data quality or data validation through Informatica data validation option tool (DVO) and Data Quality (IDQ).
• Designed, Developed, Deployed and implemented ETL mappings using Informatica
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Used SCD (type1, type2 and type3) to Load present and Historical Data to ODS, EDW.

Environment: Windows XP/2010/Server2012, SQL, PL/SQL, and Microsoft: POWER BI, TABLEAU INFORMATICA PowerCenter.

Confidential, AUSTIN, TX

SQL Developer

Responsibilities:

• Involved in analyzing the requirements, and prepare designs and plans for meeting those requirements.
• Created and maintained stored procedures, Functions, Triggers, Cursors and SQL scripts Using SSMS.
• Developed and modified the T-SQL for the database application.
• Developed the application code in C# using visual studio 2010 to process the required details and provides information on Orders and POS
• Designed the Entity relationship diagram to create effective and efficient databases with required tables and columns by analyzing the business requirements. Developed the logical design of the database and the tables.
• Performed backups and restores of the application database in SQL server 2014
• Involved in migrating the databases from SQL server 2008 TO SQL server 2014.
• Maintained SQL scripts indexes and complex queries for analysis and extraction.
• Carried out quality testing and assurance for SQL servers.
• Created reports on SQL server reporting services.
• Develop SSIS Packages to Import files from different sources and execute an automated workflow using SQL Server

Environment: T-SQL, C#, Microsoft SQL Server 2008/R2/2014, SSMS, SSIS, TFS 2015, Visual Studio.

Confidential

Programmer Analyst

Responsibilities:

• Involved in analyzing the basic flow of requirements and developed based on BRD and User Stories.
• Worked on minor / major enhancements based on the requirement specification.
• Monitoring the daily / monthly scheduled job which pulls data from different applications.
• Analyzing & troubleshooting the scheduled jobs in case of any failure and manually re-triggering them
• Worked on analyzing & preparing detailed design documents for various database.
• Written and executed SQL queries and Joins, Group By clause, having clause etc. to validate the data.
• Validated reports by executing SQL queries and compared the data using File comparison tool
• Created and deployed customs SSRS reports.
• Design/Developed new SQL jobs based on database structures and business rules.
• Followed Agile/Scrum Methodologies for all of the project activities.

Environment: Manual Testing, Agile/Scrum, Java, HTML, SQL, XML, Web Services.