We provide IT Staff Augmentation Services!

Etl Developer (ssis,red,informatica) Resume

0/5 (Submit Your Rating)

Miami, FL

SUMMARY

  • High proficiency with 8 years of experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2000/2005/2008 , Teradata.
  • Extensive knowledge of Relational Database Management Systems like SQL Server, Oracle,Teradata.
  • Expertise in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2000/2005/2008 to facilitate efficient data manipulation and data consistency.
  • Actively participated in sprint planning to follow Agile Methodology.
  • Migrated Data from MS Access, MS Excel, flatfiles to Teradata by using Wherescape RED and Informatica .
  • Participated in SCRUM standup meetings to review changes and updates.
  • Created User stories to break the tasks following the rules of Agile.
  • Experienced in defining Data Sources and Targets in Teradata creating data source views.
  • Used Informatica to move data across multiple environments into Teradata warehouse.
  • Worked with TARA to do a backup and restore of Teradata objects.
  • Used Teradata OLELOAD,MLOAD,FASTLOAD,BTEQ scripts to move data from flatfiles to Teradata RLZ
  • Experienced in defining Data Sources for creating data source views.
  • Expertise in working with and designing SQL Server 2005, SQL Server 2005, Oracle 9i, MS Access and Teradata databases.
  • Migrated Data from MS Access,SQL Server, flatfiles to Teradata by using Wherescape RED and Informatica .
  • Extensive working knowledge of Oracle databases with forms and reports and MS SQL Server 2008.
  • Worked with SSIS file encryption and scheduled to uploaded the file to FTP.
  • Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and DataVaulting .
  • Strong experience in T - SQL development with MS- SQL Server 2000/2005/2008 .
  • Experience in upgrading of SQL Server from version and .
  • Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
  • Experience in authoring reports using SSRS.
  • Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
  • Experience in Database Backup, Recovery and Partitions,Indexes.
  • Proficient in performing DBA tasks like installing and configuring SQL servers, creating maintenance plans, checking job failures and troubleshooting issues.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Experience in Microsoft SQL Server Clustering, Log Shipping and Replication solutions.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS.
  • Extensively involved in tuning stored procedures and T-SQL queries.
  • Knowledge of Informatica installation and creating workflows mappings and sessions.
  • Migrated Data from MS Access, MS Excel, DB2 to SQL Server 2005/2008 by using SQL Server Integration Services (SSIS).
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
  • Experience in SQL Enterprises Manager and SSMS - creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, restoring database.
  • Hands on experience on SQL Server, Reporting Services and Integration Services to manage data ware house environment.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, Export & Import, DTS, Replication, BIMS.

Data warehouse Tools: SSIS, SSRS, Informatica 9.0, Wherescape RED

Database: MS SQL Server 2008,2005, 2000, 7.0, MS-Access 97/2000/2003/2007 , Teradata 13.10

Operating System: Windows 95/98/NT/2000, Unix, DOS, Windows Server 2003

IDE Tools: Microsoft Visual Studio 2003/2005, Visual Basic 6.0

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Web Servers: IIS

PROFESSIONAL EXPERIENCE

Confidential, MIAMI, FL

ETL Developer (SSIS,RED,INFORMATICA)

Responsibilities:

  • Created workflows in Informatica to extract the data from the tables into RLZ in Teradata
  • Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the data from sources into staging area.
  • Developed Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication.
  • Monitoring the identified ETL processes, restarting the ETL processes that aborted.
  • Created Sources and Targets in Teradata and loaded the data from the sources.
  • Created 200 mapping for moving the data from different sources into Teradata database as per the requirements of the DataVault methodilogy RLZ,DV,DM
  • Created worklets in Informatica to load data into the targets depending on their functionality.
  • Worked on process to extract the files from the FTP every Thursday .
  • Created the RLZ to load files into the landing zone and move them to permanent load tables.
  • Created Views in Teradata to source data from delta files feeding the DataVault objects.
  • Created the DataVault objects and DataMart objects in Terdata and used RED, Informatica to move data across .
  • Scheduled the RED jobs to run daily and setup email alerts
  • Used WhereScape RED to extract the files from the shared location to Teradata RLZ
  • Created the RLZ to load files into the landing zone and move them to permanent load tables.
  • Worked on a process for data cleansing for missing values and incorrect formats.
  • Created Views in Teradata to source data from delta files feeding the DataVault objects.
  • Created the DataVault objects and DataMart objects in Terdata and used RED, Informatica to move data across .
  • Scheduled the RED jobs to run daily and setup email alerts .
  • Used the previously build Pamlico framework to extract the files from FTP
  • Created the RLZ(Relational Landing Zone) in Teradata to load the files into delta tables
  • Created permanent load tables in Teradata using RED
  • Created data source views on the delta load files and in Teradata
  • Followed the DataVault methodology created Hub’s,Satellite’s,Slnk’s,SlnkSAT’s
  • Created the DataMart objects sourcing from the DataVault
  • Scheduled the process using the RED scheduler .
  • Supported the Microstrategy reporting team.
  • Worked on a SSIS package to extract the store and ownership details from SQL Server into a flatfile.
  • Encrypted the file with a password and placed the file on a FTP site
  • Scheduled the package to place the file with current date with name on the FTP
  • Worked on SSIS package to exact the files and load them into the loadtables.
  • Created lookup tables to translate the values to current system
  • Worked on SSIS packages to load the Dimension and then updated the Fact tables
  • Created SSIS package to extract the data from the Environment and load it into the stg area
  • Decrypted and encrypted the pins using IPC approved tool and loaded the data into targets
  • Scheduled the package to run daily incremental loads
  • Coordinated with the reporting teams to generate reports

Confidential, MIAMI, FL

ETL Developer (SSIS,SSRS)

Responsibilities:

  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Worked with the teams in organization on SSIS development, data warehouse development, and ETL development best practices.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
  • Implemented ETL process using SSIS
  • Created system for capturing, reporting, and correcting error data.
  • Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Provide on-call support to production system to resolve any issues.
  • Gather requirements and design of data warehouse and data mart entities.

Environment: MS SQL Server 2005/2008 R2, SSIS, SSRS, Windows XP, Management Studio, BIDSBIXpress, TFS.

Confidential, JAX, FL

SQL Server Developer/DBA

Responsibilities:

  • Participated in gathering the business requirements and specifications.
  • Interacted directly with various business users as a part of team involved in requirements collection and analysis.
  • Create a new lookup or translation table to map products from Genelco and Bensel.
  • Created complex stored procedures to have a drill down Audit, with coverage level product level, date level.
  • Mapped different naming conventions in Genelco to Bensel.
  • Extracted data from different sources like Flat files implemented business logic and loaded into the target Genelco Enrollments table.
  • Extracted data according to specification and created a new table to house Bensel Enrollments.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support Audit.
  • Developed several 2005 SQL Reporting Services, with Visual Studio and supporting Stored Procedures.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Defined report layouts including report parameters.
  • Created parameterized, drill down in MS SQL environment using SSRS 2005/2008.
  • Participated in gathering the business requirements and specifications.
  • Interacted directly with various business users as a part of team involved in requirements collection and analysis.
  • Create a new lookup or translation table to map products from Life70 and Bensel.
  • Extracted data according to specification and created a new table to house Bensel Enrollments.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support Audit.
  • Developed several 2005 SQL Reporting Services, with Visual Studio and supporting Stored Procedures.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Defined report layouts including report parameters.
  • Created parameterized, drill down, conditional and aggregation reports in MS SQL environment using SSRS 2005.
  • Interacted directly with various clients as a part of team involved in requirements collection and analysis.
  • Extracted data from different sources like SQL Server and Flat files implemented business logic and loaded into the target Warehouse
  • Participated in gathering the business requirements and specifications.
  • Interacted directly with various teams involved in requirements collection and analysis
  • Created a table to hold all the distinct transactions that have been processed
  • Created complex T-SQL Queries, Stored Procedures and Functions to support Audit
  • Defined report layouts including report parameters.
  • Created parameterized, drill down, drill through sub reports, conditional and aggregation reports in MS SQL environment using SSRS 2005/2008.
  • Worked on change controls to move the project through various environments.
  • Worked with the Business Analyst to gathering specifications.
  • Created complex T-SQL Queries, Stored Procedures to support the report.
  • Defined report layouts including report parameter

Environment: MS SQL Server 2005, SSIS, SSRS, Windows XP, Management Studio, BIDS.

Confidential, Jersey City, NJ

SQL Server Developer

Responsibilities:

  • Implemented a well-planned backup and restore strategy that protects databases against data loss.
  • Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
  • Created several databases in various Development and Test server by using SQL Server 2005.
  • Created several tables, views using SQL Server 2005 Management Studio. These tables, views are created based upon the functional specifications.
  • Wrote DTSX packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Involved in understanding and analysis of state report requirements in Trizetto FACETS
  • Have developed subscription based reports and created subscriptions and schedules using the Report Manager.
  • Developed reports using Crystal reports.
  • Responsible for installation, configuration, security, maintenance, restoration of SSRS on Windows Server 2003.
  • Created designed and deployed drill down, drill through, parameterized and sub reports in financial domain of MetLife bank using MS SQL Server Reporting services.
  • Development of Business rules implemented as Constraints, Triggers and Stored Procedures.
  • Replicated the billing data and adjudicated the claims in Facets.
  • Working knowledge in general healthcare section with exposure to Trizetto FACETS 4.31 Membership,Provider,Claims,Workflow,CSR of the product
  • Created, Tested and has implemented SSRS packages for Reporting Services (SSRS 2005).
  • Experience with SQL Server Reporting Services to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Generated ad hoc reports using MS Reporting services and Crystal reports.
  • Strong experience in MS SQL Server 2005 with Business Intelligence in SQL Server Reporting Services.
  • Worked with FACETS in generating dataset for the reports in Billing and CSR section.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Working very closely with other developers for their SQL requirements, worked with Business Analyst and end users to understand the report requirements.
  • Developed and implemented strategies for improving and further leveraging these reports in order to transfer / convert existing reports to SQL Server Reporting Service.
  • Created and executed several SSIS packages to perform operations like extraction of the data from source server to destinations server and OLTP to OLAP.
  • Created several stored procedures, triggers, and views and wrote complex T-SQL queries for database development and Report generation.

Environment: MS SQL Server 2005 Enterprise Edition, T-SQL, ODBC, Excel, SSAS, SSIS Packages, SSRS, SQL Profiler, Windows 2003 Server, MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS.

Confidential, Rockville, MD

MS SQL Server Developer

Responsibilities:

  • Requirement analysis and Capacity Planning for database.
  • Designing, maintenance, updating of application schema structure / data models.
  • Creation and Execution of TSQL Scripts (Stored Procedures, Triggers and complex queries) in SQL Server 2005 database.
  • Development of SSIS packages such as extraction of data to different servers.
  • Performance tuning of SQL Server database procedures and networks.
  • Handling Installation and creation of new Instances of SQL server databases.
  • Backup, Restoration and Recovery in different scenario.
  • Managing User Creations, assigning Roles to SQL Databases.
  • Extensively involved in maintaining & updating the database documentation.

Environment: SQL Server 2005, SQL Server Management Studio, Query Analyzer, SQL Profiler.

Confidential

SQL Server Database Administrator/ Developer

Responsibilities:

  • Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
  • Managing of database objects like Tables, views, indexes etc.
  • Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
  • Managing Backup and restore, export and import.
  • Developed DTS Packages to transfer the data between SQL Server and other database and files.
  • Well experienced with tools like Query Analyzer, SQL utility.
  • Creation and management of Database maintenance plan for various database consistency checks.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Automation and execution of data transformation scripts.
  • Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2000, Windows 2000, MS Access, T-SQL, DTS, VB 6.0.

We'd love your feedback!