We provide IT Staff Augmentation Services!

Tech Lead / Etl Specialist / Sr. Etl Developer Resume

NyC

SUMMARY:

  • Dynamic IT professional with around 10 years of extensive working experience in Analysis, Design, Development, Production Support, Enhancement and Implementation of Data Warehouse projects using Informatica PC, Talend DI & BD, Oracle, SQL Server, Netezza, MySQL, DB2 and UNIX.
  • Experience in roles as - ETL Architect / Technical Lead / ETL Specialist / ETL Lead / Sr. Informatica Developer .
  • Strong working experience in Investment, Media, Insurance/Annuity domain.
  • Participated in all phases of SDLC throughout all architectural tiers of the system, experience in adhering software methodologies like Agile, Waterfall .
  • Very strong experience in Informatica PowerCenter suite which includes Mapping Developer, Workflow Manager, Workflow Monitor, Admin Console and Repository Manager.
  • Good experience with Big Data and Hadoop ecosystem, Hadoop Distributed File System (HDFS), supported databases like Hive and Pig, installation of Hortonworks.
  • Strong experience in Talend DI and BD installations and its components like tMap, TJavaRow, tAggregateRow, tFilterRow, tFilterColumns, tJoin, tHDFSGet, tHDFSPut etc.
  • Certified in Informatica ILM / TDM. Strong experience in Informatica ILM / TDM tool for Data Masking, Data Discovery (sensitive data).
  • Strong experience in Informatica Metadata Manager, Data Analyst and Informatica Power Exchange.
  • Expert in design and development of Data Warehouse, Marts and ODS.
  • Experience in designing the ETL architecture, Load Strategy and Data Flow.
  • Strong understanding of Data Modeling (Star Schemas and Snow Flake Schemas), Conceptual / Logical / Physical models, DWH concepts, ER diagrams, Data Flow Diagrams / Process Diagrams.
  • Strong experience in databases like Oracl e, DB2, SQL Server and Netezza and database tools like TOAD, AQT, Win-SQL, SQL Developer and Aqua Data Studio.
  • Extensive experience in Performance Tuning, optimizing ETL process and coming up with the best design to obtain superior performance. Have also worked on creating UNIX shell scripts to automate the ETL process.
  • Good understanding of PL/SQL Packages, Procedures, Functions, Triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.
  • Experienced in using transformations like Expression, Filter, Router, Rank, Lookup along with complex transformations like Normalizer, Aggregator, HTTP, Dynamic Lookup, Unconnected lookup, Persistent Cache, SQL etc.
  • Experience with different types of Sources & Targets - Flat files, Relational tables, VSAM files, XML files etc.
  • Experience in communication with Informatica Support regarding issues/bugs related to various Informatica tools like PowerCenter, TDM etc.
  • Good Experience in creation of quality related documents (Function specification, ETL architecture design, High Level and Low-Level design, and Unit Test Case documents).
  • Excellent analytical skills in understanding client’s organizational structure.
  • Poses good problem solving and analytical skills. A highly motivated professional, team player and have the ability to effectively work, communicate and mentor people. Have handled team size as big as 10-12 members.
  • Fast Learner, excellent communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.

TECHNICAL SKILLS:

BI & ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, Talend for Big Data, Informatica ILM / TDM 9x, Informatica Metadata Manager 10.1.0, Informatica Data Analyst, Informatica Power Exchange

Databases: Oracle 11g/10g/9i/8i, IBM DB2, SQL Server, Netezza, MySQL, Big Data - Hive, Pig

Operating System: Windows 7/XP/NT/2000/98/95, Unix

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

Job Scheduler: iXp AutoSys, Tivoli Maestro, GECS

Others: Win SQL, TOAD, SQL DBX, AQT, Ipswich, WinSCP, HP Quality Center, MS Office, MS Visio, edit plus, Text pad, Oxygen XML Editor, BMC Remedy Management tool and version controlling tools like Smart SVN, VSS and Calligo.

Domains: Investment, Media, Annuity & Life Insurance

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Installed Talend including Talend Administration Center and Talend Integration Cloud Remote Engine.
  • Created projects and users on Talend Administration Center.
  • Analyzed the existing DWH processes based on their complexity design and built similar process into Talend ETL platform.
  • Created mapping documents based on the business requirements to be used by developers and QA team.
  • Conducted code reviews with the team and suggested code enhancements for better performance.
  • Worked with testing team to finalize the test schedule and test cases.
  • Interacted with Hortonworks to resolve Hive and Pig connectivity issues.
  • Co-ordination with BSA, Business users, On-shore ETL Developers, Offshore ETL Developers, Testing Team, Informatica Admin Team, DBAs etc.
  • Involvement in Unit Testing of the mappings including integration testing. Using the best document format and best practice processes for its successful execution.
  • Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
  • Created Function specification, High-level design document (ETL design architecture) and Low-level design document and Unit Test Case, deployment and operational document.

Environment:: Talend for Big Data 6x, Hortonworks 1.3, Oracle 11g, Hive, Pig

Confidential, NYC

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Understand the data flow of the current scripts.
  • Development of Informatica mappings, workflows and database objects wherever needed.
  • Co-ordination with BSA, Business users, On-shore ETL Developers, Offshore ETL Developers, Testing Team, Informatica Admin Team, DBAs etc.
  • Involvement in Unit Testing of the mappings including integration testing. Using the best document format and best practice processes for its successful execution.
  • Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
  • Scheduling of ETL workflows through GECS job scheduler.
  • Created Function specification, High-level design document (ETL design architecture) and Low-level design document and Unit Test Case, deployment and operational document.

Environment:: Informatica PowerCenter (v9.6/9.7), Oracle 11g, SQL

Confidential

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Creation of difference resources in Informatica Metadata Manager for Oracle, SQL Server, Netezza, PowerCenter, Business Objects metadata.
  • Linking of various resources and running end-to-end lineage views for different attributes.
  • Interaction with Informatica support regarding the issues with the metadata Manager.
  • Co-ordination with Business users, Informatica Admin Team, DBA.
  • Created various design documents and understanding documents for business partners.

Environment:: Informatica Metadata Manager 10.1, Informatica data Analyst, Informatica PowerCenter (v9.6/9.7), Oracle 11g, SQL Server, Netezza.

Confidential, NYC

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Profiling sensitive information in the database by continuous interaction with the business and system users.
  • Understand the requirement of the users to Mask the data and identify the pattern of the data to apply the masking logic
  • Parameterizing all the values used within TDM to increase the scalability of the code across various non-prod environments.
  • Documenting each Rule and Plan used by every column of a Table for the entire database.
  • Customization of Mappings .xml file for the features that are yet to be released in the future version of TDM. For ex: Parameterize connections, parameterize seed value etc.
  • Co-ordination with BSA’s, Business users, On-shore ETL Developers, Offshore ETL Developers, Testing Team, Informatica Admin Team, DBAs and Informatica support team.
  • Involvement in Unit Testing of the mappings plus integration testing. Using the best document format and best practice processes for its successful execution.
  • Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
  • Created Function specification, High-level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.

Environment:: Informatica PowerCenter (v9.6/9/7), Informatica ILM/TDM (v9.6/9/7), Oracle 11g, SQL Server, Netezza, SQL

Confidential, NYC

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performed role of Tech Lead / Sr. ETL Developer, that includes requirement analysis, design, development, testing, and documentation and production deployment.
  • Responsible for participating and providing analytical solutions for the strategic vision of the MSA and CR in the Architecture Meetings.
  • Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.
  • Proof of Concept (POC) for any new applications.
  • Architect, design and execute strategic projects for IDW and its Marts.
  • Involved working on Oracle 11g database, designing and creating tables, relations, constraints, indexes.
  • Development of Informatica mapping using complex transformation including Lookup, Normalizer, Aggregator, Router, Rank, Web Services, HTTP etc.
  • Experience with different types of sources and targets - Flat files, Relational Tables, VSAM Files, XML files etc.
  • Fine tune SQL queries and database performance for all applications within the development environment.
  • Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.
  • Responsible for resolving critical issues and permanent fix to Production issues.
  • Responsible for providing timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations
  • Frequent communication with the client, business, and QA team on technical and functional queries related to critical production issues.

Environment:: Informatica PowerCenter (v9.1), Oracle 11g, SQL Server, SQL, UNIX, AutoSys scheduling, Windows 7

Confidential, NYC

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performed role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.
  • Responsible for participating and providing analytical solutions for the strategic vision of the MSA and CR in the Architecture Meetings.
  • Provide Analytical Solutions to Production Support problems with my technical and analytical knowledge base.
  • Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.
  • Proof of Concept (POC) for any new applications.
  • Architect, design and execute strategic projects for IDW and its Marts.
  • Involved working on Oracle 11g database, designing and creating tables, relations, constraints, indexes.
  • Fine tune SQL queries and database performance for all applications within the development environment.
  • Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.
  • Responsible for resolving critical issues and permanent fix to Production issues.
  • Responsible for providing timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations
  • Frequent communication with the client, business, and QA team on technical and functional queries related to critical production issues.

Environment:: Informatica PowerCenter (v9.1), Oracle 11g, SQL Server, SQL, UNIX, AutoSys scheduling, Windows 7

Confidential, NJ

Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performed role of Informatica Specialist, which includes requirement analysis, design, development, testing, documentation, production deployment and Administrator tasks.
  • Designed ETL Architecture using Informatica for implementing various phases of EDW build.
  • Worked on Informatica PowerCenter to develop mappings, sessions and workflows.
  • Used Informatica Power Exchange tool to read source data and generate feeds to external systems.
  • Integrated 34 admin systems into IBDW, built stage and stage history layer with error checking strategies.
  • Built new ETL process and enhancing some of current processes.
  • Worked on ACORD data model, which is global standard for Insurance domain, built Marts to enable data exchange with external systems.
  • Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.
  • Also developed UNIX Shell Scripts to automate the ETL processes.
  • Used XML sources to load data into relational tables.
  • Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
  • Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
  • Created Function specification, High-level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
  • Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment:: Informatica PowerCenter (v8.6 / v9.1), Power Exchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP

Confidential, NJ

ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performing role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.
  • Responsible for participating and providing analytical solutions for the strategic vision of the IDW in the Architecture Meetings.
  • Responsible for creating SQL Utility tool which removes DBA intervention in the execution of SQLs in production environment in case of abends/new releases and allows production management team to do so through Maestro job by simply uploading SQL in a file on production server.
  • Provide Analytical Solutions to Production Support problems with my technical and analytical knowledge base.
  • Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.
  • Proof of Concept (POC) for any new application.
  • Architect, design and execute strategic projects for IDW and its Marts.
  • Work with Relational Modelling (Logical and Physical) IDW and Dimensional Modelling for all the Marts.
  • Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.
  • Fine tune SQL queries and database performance for all applications within the development environment.
  • Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.
  • Responsible for planning the Disaster Recovery Scenarios.
  • Responsible for resolving critical issues and suggesting the fix/permanent fix to Production Management team (L1/L2).
  • Responsible for provide timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations
  • Frequent communication with the client, business, and QA team on technical and functional queries related to critical production issues.

Environment:: Informatica PowerCenter (v8.6), IBM-DB2, Oracle 10g, SQL, UNIX, Maestro scheduling, Windows XP

Confidential, NJ

ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performing role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.
  • Working on Informatica PowerCenter to develop mappings, sessions and workflows.
  • Responsible for the planning and management of all technical and operational activities.
  • Requirement analysis, Logical and Physical database design. Architect, design and execute strategic projects for IDW and its Marts.
  • As a designer, he was responsible for designing and coding of various key modules, which includes creation of Analysis document, Function Specification, Mapping document, HLDs, LLDs and UTCs, KT document for QA Team and for production rollout.
  • Responsible for updating the latest versions of the entire project related documents in Calligo.
  • Worked on PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Developed mappings for extracting data from various sources involving flat files.
  • Mapping business requirements to technical specifications and design logic for implementing the same. Developed data mappings using various transformations between source systems and warehouse using Informatica Designer.
  • Created sessions using Informatica PowerCenter workflow Manager.
  • Involved testing and UAT support activities.
  • Responsible for planning the disaster recovery scenarios.
  • Running integration test cycles and integration testing.
  • Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.
  • Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
  • Frequent communication with the client, business, QA team on technical and functional queries.
  • Generic Error Strategy implementation.
  • Automated the process through UNIX Shell scripting.

Environment:: Informatica PowerCenter (v8.6), IBM-DB2, Oracle 10g, SQL, UNIX, Maestro scheduling, Windows XP

Confidential, NJ

ETL Specialist / Sr. ETL Developer

Responsibilities:

  • Performing role of a Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.
  • As a designer, he was responsible for designing and coding of various key modules, which includes creation of Analysis document, Function Specification, Mapping document, HLDs, LLDs and UTCs, KT document for QA Team and for production rollout.
  • Responsible for updating the latest versions of the entire project related documents in Calligo.
  • Developed mappings for extracting data from various sources involving flat files.
  • Mapping business requirements to technical specifications and design logic for implementing the same.
  • Developed data mappings using various transformations between source systems and warehouse using Informatica Designer.
  • Developed different ETL strategies like Set Processing, Error Strategy, Polling and Reconciliation, Error Processing and Re-processing.
  • Created sessions using Informatica PowerCenter workflow Manager.
  • Building Generic code for quick implementation.
  • Performance Tuning of Sessions and Mappings to meet the SLA of almost 25 systems required for this critical project.

Environment:: Informatica PowerCenter (v8.6), Power Exchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP

Confidential, NJ

ETL Specialist / ETL Developer

Responsibilities:

  • Monitoring and reporting through Maestro.
  • Worked on troubleshooting the mappings to improving Performance by identifying bottlenecks.
  • Have a constant follow-up whether the ABEND or SLA for each task is been logged on to the defect tracking system.
  • Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.

Environment:: Informatica PowerCenter (v8.6), Power Exchange, IBM-DB2, Oracle 9i, SQL, UNIX, Maestro scheduling, and Windows XP

Confidential

ETL Developer

Responsibilities:

  • Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created Mappings using Mapping Designer to load the data from various sources into multiple targets, using different transformations like Aggregator, Expression, Filter, Lookup, Sequence Generator, Router and Update Strategy.
  • Update all the project related documents in VSS, the project-tracking tool.
  • Testing & debugging

Environment:: Informatica PowerCenter (v7.1), Oracle 10g, SQL, UNIX, Windows XP

Hire Now