We provide IT Staff Augmentation Services!

Etl Tech Lead Resume

5.00/5 (Submit Your Rating)

CaliforniA

SUMMARY:

  • ETL Developer & Tech Lead with 12.8 years of experience Informatica PC/TDM/BDM, Business Objects, Unix Shell Scripting, PL/SQL, Cassandra Datastax.
  • Strong in Data warehousing concepts Fact table, dimension table, star and snowflake schema methodologies.
  • Experience in Health Care and Communications Domain.
  • Experience in Safe Agile for 6 years and meeting up with daily stand up call.
  • Continuing to learn and develop technical and functional advancements with Informatica
  • Ability to work with minimal supervision where self - reliance and lateral thinking are required
  • Ability to work independently or as a team member with an analytical bent to problem solving and delivering under high stress environment Info.
  • Experience in developing mappings using various transformation logic such as Normalizer, Joiners, SQL transformations, Routers, filters etc.
  • Experience in developing mappings for Slow Changing Dimension environment.
  • Effective communication skills for coordination between globally located teams.
  • Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences.
  • Experience with a variety of sources (Oracle, SQL Server, XML, flat file, Excel Spreadsheet etc.)
  • Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
  • Experience with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts.
  • Experience in Unit, Functional, Integrated System Testing.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
  • Experience in HP Quality Center/JIRA for Bug Tracking and Defect Reporting.
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Extensive experience in developing of dimensional modeling (Star and Snow flake) of data warehouse using Erwin.
  • Ability to lead end to end ETL project and team.
  • Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.

SOFTWARE SKILLS

RDBMS: Oracle 11g,MYSQL, SQL Server, Teradata

Operating System: Windows vista, Windows 9x, Windows NT/ 2000/XP, HP-UNIX

Languages: Unix Shell Scripting

Tools: Informatica PC/TDM 10.2.0,Business Objects, Cassandra Datastax, Informatica BDM, BO Objects

Version control tools: SVN

EXPERIENCE:

Confidential, California

ETL Tech Lead

Responsibilities:

  • Understand architecture roadmap of the Project in terms of Data flow between systems and their impact. responsible for effort estimation by working with project management teams.
  • Design the functionalities specific to each release and deliver high level design and application design documents.
  • To provide extensive details of the design by using the templates, standards framed to organize the deliverables in prism using IT unified process framework & agile methodologies.
  • Assists the team in getting low level design for the ongoing Project.
  • Participates in design review discussions Confidential offshore and onsite with the designers and Solution Architects.
  • Establishes and tracks the milestone associated with the different phase along with the metrics in Prism.
  • Utilizes TDP (Technology Development Platform) tool to estimate the development time for the modules in Informatica and Platinum tool to validate the standard of the Informatica code, Preparing the mapping documents and process flows.
  • Creating/Modifying the data model, Development/Review of the Informatica Components, tuning the SQL queries for performance, implement the best coding practice across the team so as to deliver the robust application and to minimize the bugs during the testing phase.
  • Perform root cause analysis and impact assessment for defects identified in testing and post-production phases and fixing the same.
  • Prepare the production readiness documents like deployment checklist and component list and also involves in Post production change requests

Environment: I am a ETL Informatica Technical Lead for a 5 Member team onsite team where I was involved in Analysis, Design and Development of the HCR Track using Informatica PC, Unix Shell Scripting, SQL Developer. I was also involved in recruiting resources for other tracks involved for solution consultant and development roles. I am also responsible for leading the TDM track for the HCR track.

Confidential, California

ETL Tech Lead

Responsibilities:

  • To evaluate the quality of data /and consistency from Source system to the target system, It Includes Identification of Pre-Production data issues, On-going audits for proactive identification of data integrity issues in production environment.
  • Create a dashboard which will enable the executive management to interact with appropriate functional/IT Systems areas and access the data quality KPIs and Metrics.
  • Create audits that’s are scheduled to run on a specified schedule and can be run on an as-needed basis as well.
  • To understand architecture roadmap of the Project in terms of Data flow between systems and their impact.
  • She is responsible for effort estimation by working with project management teams.
  • Design the functionalities specific to each release and deliver high level design and application design documents.
  • Participates in design review discussions Confidential offshore and onsite with the designers and Solution Architects.
  • Creating/Modifying the data model, Development/Review of the Informatica Components, tuning the SQL queries for performance, implement the best coding practice across the team so as to deliver the robust application and to minimize the bugs during the testing phase.

Environment: I was a ETL Tech Lead for a 10 Member team where I was involved in Analysis, Design and Development of the DLAQM using Informatica PC, Cassandra Data Stax, Unix Shell Scripting, SQL Developer.

Confidential, California

ETL Tech Lead

Responsibilities:

  • Create mapping the requirements to the technical architecture.
  • Creation of Detailed Design, Development of Informatica components.
  • Creation of Testing mythologies and its design, testing the Informatica components.
  • Creating the deployment groups to move the code to other testing environments namely Assembly testing, Integration testing and performance testing, doing root cause analysis and impact assessment for defects identified in testing and post-production and fixing the same.
  • Preparing the production readiness documents like deployment checklist and component list, involving in Postproduction change requests.
  • Provide the Channel Map information to customers over the web for UMA application
  • Provide the Package Details information over the web for a customer tied to a Yahoo member Id.
  • Provide the VoD data and metadata to the QPass downstream system for customer facing Catalog maintenance
  • Data auditing capabilities across systems to meet the needs of the sister application called VSDA
  • Serve the Customer Credit limit reset computation and data movement to IPTV
  • Maintain & Serve the Set Top box, DVR and Remote DVR, Video on Demand data to the Enterprise data warehouse.

Environment: I was a ETL Lead & Developer for a 20 Member team where I was involved in Analysis, Design and Development /testing of the uDAS using Informatica 9.6, Oracle 10g, Toad, Unix Shell Scripting, SQL Developer.

Confidential, Colorado

ETL Tech Lead & Production Support

Responsibilities:

  • Integration of the IDW from the high-level design phase of the project.
  • Assists the onsite team with the high-level design and is responsible for data model and detailed design phase of the project.
  • Responsible for the detailed design and development stored proc and Unix scripts of the various source system involved.
  • Preparing POCs (Proof of Concepts) to determine whether a particular requirement can be achieved through stored proc, scripts and sql loader to be built, arriving Confidential the design to be used for each Proc, preparing Visio diagrams and skeleton for each source, actual development of the code and performance tuning the queries, and scripts.
  • Successfully completed various POCs (Proof of Concept) in oracle and Teradata to use it in the current release of IDW. This POC greatly helps in efficient designing of code thereby improving the performance of the queries and in meeting the client's SLA for processing time.
  • Responsible for building crystal report application in 6.x version. Since Confidential migrated the server and decommissioned the current server, so planned to upgrade the 49 crystal reports to SAP XI version.
  • Worked on Migration of 49 crystal reports from 6 version to XI version and handled all conflicts.
  • Developed reports as part of business requirement. Enhanced the existing reports to be adaptable in XI version.
  • Worked extensively in creation of Dynamic LOVs to automate inputs to reports.
  • Responsible for designing and implementing process control and auditing mechanisms in the IDW release.
  • Includes providing technical assistance in Teradata to the offshore team and co-ordinates with onsite team in getting clarifications for any technical or business-related queries.
  • Responsible for assigning the daily tasks to the team members for Voice and circuit and sending the daily status to the onsite team.
  • Responsible for the code delivery from the offshore for Voice and circuit.
  • To ensures that the Confidential team adheres to both Confidential and Confidential ’s quality process

Environment: I was a ETL Lead & Prod Support for a 2 Member Onsite team where I was involved in Analysis & Design, Development using Informatica 9.6, Teradata, Oracle 10g, Toad, Unix Shell Scripting, SQL Developer.

Confidential

ETL Informatica Developer /Production Support

Responsibilities:

  • Involved in the Release R11 right from the data modeling and detailed design phase of the project.
  • Responsible for the detailed design and development of ETL code.
  • Responsible for the Application Development and Offshore Coordinator for Credit Limit Reset module in Release R11.
  • Research on the various concepts available in Informatica and efficiently implemented it.
  • Created the detailed design for Credit Limit Reset module explaining the functionality of each transformation, mapping, session and workflow that had to be created as part of the development.
  • Prepared the Visio diagrams and mapping matrix for the mappings, developed the actual ETL code and performance tuned them.
  • The design for Credit Limit Reset module and the choice of transformations that I had used for developing the mappings helped in achieving the optimum performance of the workflows without using much of the CPU resource. This greatly aligned with client’s SLA for processing time.
  • As an Offshore coordinator, the role included providing technical assistance in Informatica to the offshore team, submitting the technical questions or any clarifications required by the offshore team to the onsite and getting the necessary solution from them.
  • Acted as delivery lead for the Credit Limit Reset module for the offshore.
  • Responsible for reviewing and ensuring the quality of the code for which she used various Confidential ’s internal tool AQUA.
  • Ensured that the Confidential team adheres to both Confidential & Confidential and Confidential ’s quality process. She also prepared a best practices document for Informatica and Oracle and ensured that the developed Informatica ETL code and the Oracle database objects followed the same.
  • Acted as an active member in the development of the ETL code.
  • Development roles include POC (Proof of Concepts) to determine if a particular functionality can be achieved through Informatica code.
  • Involved in the coordination with the offshore/onsite team on daily basis and actively participated in getting clarifications and any technical or business-related queries and sending the daily status to team.
  • Was responsible for reviewing and ensuring the quality of the code with the help of a quality control tool called Aqua.
  • Was responsible for the deployment activities from offshore
  • Handled the Credit Limit Reset module explaining the functionality of each transformation, mapping, session and workflow that had to be created as part of the development.
  • Fully involved in the design and development of the VOD offers.
  • Active team member of the Evaluations between the IPTV and other systems.
  • Fully involved in the design of the Template execution.

Environment: I was in a 15 member where I was involved in Analysis, Design, Development and enhancement of the uDAS Production Support Application using Informatica 9.6, Oracle 10g, Toad, Unix Shell Scripting, SQL Developer

Confidential

ETL Developer

Responsibilities:

  • Involved in Requirement gathering and analyzing them.
  • Setting up the development environment for EDC and Setting up the database (MYSQL) for EDC.
  • Actively completed the Prototype of the application and Designing, Coding, Testing and Deployment of the application.
  • Sole person to develop an entire portal and create surveys and graphs using component

Environment: 3-member team was involved in Development & Testing and maintaining the Dev environment for EDW using VB6, Unix Shell scripting, SQL Developer, MS Access.

We'd love your feedback!