We provide IT Staff Augmentation Services!

Etl-developer Resume

Charlotte, NC

SUMMARY:

  • A detail oriented and result focused ETL/Informatica with over 8+ years of experience in Data Warehouse, Business Intelligence applications and involved all phases of Software Development Life Cycle (SDLC) that includes Analyzing, Designing, Developing, and Testing of data whilst creating useful and efficient visualizations and reports using Tableau.
  • Experience in working at various levels of software development cycle such as Analysis, Designing, Developing, and Testing & Implementation of business applications in Client Server / Relational Database Management environment.
  • Demonstrated expertise utilizing ETL tools, including Informatica and SQL Server Integration Services.
  • Extensively used ETL methodology for supporting Data Extraction, Transformations and Loading process, in a corporate - wide-ETL Solution using Informatica (Power Center 10.1/9.5/9.1/8.6 - Repository Manager, Designer, and Workflow Manager).
  • Well versed in working with the Business and vendor teams to integrate various data sources and provide data solutions for reporting and archival.
  • Worked in coordination with java messaging systems ( JMS ) and XML messages for real-time data management in RDBMS .
  • Worked on various ETL tuning techniques like pushdown optimization and partitioning of transformations/Sources/Targets.
  • Involved in LOB testing and business communication for various Trading platforms and Market data management services.
  • An empathetic listener and persuasive speaker with excellent written and verbal skills.
  • Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL and scripting languages.
  • Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Designer.
  • Widespread knowledge in using report building tools like Tableau and PowerBI.
  • Demonstrated skills in developing efficient reports using Tableau.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter 10.x/9.5.x/9.1/8.6.x, SSIS.

Data Modeling: Star Schema, Snowflake Schema, Erwin 4.0, Dimension Data Modeling.

Databases: Oracle11g/10g/9i, SQL Server2008/2005, IBM DB2, MS Access

Scheduling Tools: Autosys, Informatica Scheduler

Operating Systems: Windows 7/XP/NT/95/98/2000, MAC OS, UNIX and LINUX

Reporting/Visualization: Tableau 8, 9, 10.5, PowerBI

Other Tools: T - SQL, Teradata SQL Assist, Toad, Putty, WINSCP, MS-Office, SQL Developer, JIRA, HP ALM, Versionone.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL-Developer

Responsibilities:

  • Worked with source application owners, Business Analysts, Users and Surround developers in gathering the requirements.
  • Analyzed the requirements and created technical documentation, coding methodologies and strategies to be implemented for development.
  • Provided testing, integration and maintenance solutions as per existing standards of trading Platform.
  • Estimated the complexity of the development and utilized suitable frameworks to minimize the dependencies and create loosely coupled systems.
  • Developed a new real-time data flow system as opposed to the legacy over nightly batch by using Informatica ETL and Java messaging service (JMS).
  • Tuned Informatica ETL with high precision using pushdown optimization and ETL partitioning techniques to handle high production volumes of over 50 million Tax lots in JMS messages daily.
  • Developed a Heartbeat mechanism using Informatica and DB2 to communicate the health of the DataMart to various Source and Surround applications.
  • Created and Analyzed Data stories in Version one for ETL scheduling using Autosys which can be further used by offshore teams for Autosys script development and deployment.
  • Developed test cases and performed unit testing in ETL (informatica 10.1) and database level (DB2).
  • Created Archive structures for files and tables and implemented a purge strategy to keep the database in good health without out overloading the DB2 and UNIX servers.
  • Tuned SQL statements (e.g.: - Using Indexes) and PL/ SQL Procedures.
  • Used Tableau10.1 to create reports for surround applications to depict market value for various securities in Confidential .
  • Designed PL/SQL procedures to check for source data discrepancies and fast analysis of data in SIT/UAT phases to compare ETL outputs.
  • Created Functional Specification documents for the developed application for future by business/Development teams.
  • Developed Ad-Hoc reports in Tableau for the use of Management to estimate the data volumes and forecast in lower environments and thus design Indexing strategies and Archival policies.

Environment: IBM DB2 11.1, Oracle PL/SQL, Informatica 10.1, Tableau 10.5, Autosys, JMS, HP ALM, Version one, JIRA,MS SharePoint.

­­­­­­­­­­­­­­­­­­­

­­­­­­

Confidential, Chicago, IL

ETL BI Developer

Responsibilities:

  • Worked with business Analysts and Architects to get the functional specs and design documents in order to get a better understanding of the user requirement.
  • Developed new and customized existing mappings and bought in data into data warehouse.
  • Created mapping document with all the necessary fields which helps to develop or customize the mappings more efficiently.
  • Extensively used all the transformations like Source Qualifier, Expression, Sorter, Aggregator, Router, Union, Joiner, Lookup, Update Strategy etc.,
  • Created and used mapplets and shortcut objects in the Informatica repository.
  • Performed Unit Testing and resolved the bugs identified during the QA and UAT testing.
  • Created and modified UNIX scripts to process the Informatica jobs, file handling, executing SQL scripts.
  • Documented the support process, prepared release notes for code migrations.
  • Developed complex dashboards using Tableau table calculations, quick filters, context filters, hierarchies, parameters, and action filters.
  • Worked extensively with advanced analysis Actions, Table calculations, Parameters, Maps, Trend Lines, Background images, Groups, Hierarchies & Sets to create detail level summary reports and Dashboards.
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets. Designed and published customized interactive dashboards.

Environment: Tableau 9.0, 10, Tableau Server, SQL Server 2014, Informatica Power Center 9.6.1, Oracle, Autosys

Confidential, Dublin, CA

Data warehouse/ETL Developer

Responsibilities:

  • Worked with the Source systems to get the new data elements into Warehouse and making the changes in database and mappings for the new data elements
  • Extensively used ETL to load data from source systems like Flat Files into staging tables and load the data into the target database Oracle.
  • Extensively used all the transformations like Source Qualifier, Expression, Sorter, Aggregator, Router, Union, Joiner, Lookup, Update Strategy etc.,
  • Created sessions and workflows to run various mappings for loading the data using Workflow manager in Informatica.
  • Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards. Created extract files for improving the performance.
  • Worked on creating mappings for Facts and SCD Type 1 and SCD Type 2 slowly changing dimensions
  • Created various types of charts to provide better visualization and created Interactive reporting dashboards by combining multiple views.
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Worked with Unit testing, Regression Testing, User acceptability testing.
  • Captured, Tracked and reported defects using HP Quality Centre.
  • Involved in On-Call Production support and worked on resolving the job failures and production tickets.

Environment: Tableau 8.1.10-8.1.22 , Tableau server 8, Informatica Power Center 9., Oracle 11g, Solaris, Erwin, Business Objects XIR3/4, Flat files, HP Quality Centre.

Confidential

Database/ ETL Developer

Responsibilities:

  • Worked closely with ETL Onsite Lead in converting Business Requirements into Technical Specifications.
  • Created Mappings to load data to Data Marts, like Incremental loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
  • Used transformations like Expression, Lookup, Filter, Router, SQL, Union, Normalizer, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
  • Modified existing Informatica Code, PL/SQL procedures and packages for the new CO’s and SR’s.
  • Worked on different tasks in Workflow Manager like Sessions, Decision, E-mail, Command, Worklets, Timer and Scheduling of the workflow.
  • Created sessions, batches for incremental load into staging tables and scheduled them to run daily using Autosys.
  • Modified existing mappings for enhancements of new business requirements.
  • Supported the application during UAT and Production.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Generated periodic reports based on the statistical analysis of the data from various time frame using Tableau.
  • Performed Database backups (operating system, flat file backups & export/import).
  • Developed standards and guidelines to maintain and develop and administer the SQL Server database.
  • Handled corrupt databases diagnosed and repaired them.

Environment: SQL Server 11.0/2012, T- SQL, Query Analyzer, Tableau 8.1.,Informatica Power Center 8.6.1/9.1,Flat files, UNIX, SQL, PL/SQL, Shell Scripts, CTRL-M

Hire Now