Job Description :
ETL Data stage Sr Developer support role
visa status except opt’s
Relevant Experience 7 yrs.
Technical/Functional Skills ETL Technical lead/Technical Analyst/Production support
Education Bachelor’s Degree
Duration 6 months
Work Location Clinton NJ
Oracle11g, SQL, PL/SQL 11g
Windows, UNIX
Informatica 8.x/9.x with Cloud Platform,
Salesforce CRM Object Model
Data stage 9.x/11.x
Agile Project development
Jira/Rally QC Defect Tracking Application
IBM ESP Scheduler
Roles & Responsibilities
Analyses Business requirements and prepares Technical Specification for various project processes and creates High-level and Low-level ETL Flow Diagram in Visio.
Should be aware and worked on Agile development process and ability to understand Business requirement and develop code on the fly when needed.
Has very excellent knowledge using Data Stage ETL tool (DATASTAGE (v9.x or 11.x) and Hands on developing the ETL coding for extracting data from various source systems and loading the same into DataMart’s and Data Warehouse layers.
Hands on ETL Development for Control Architecture, Common Modules, Sequence Controls and major critical interfaces and performance tuning.
Knowledgeable on the CRM Salesforce (with respect to Life Insurance, any other are accepted) object model /data structure.
Familiarity of extracting data from Oracle and loading into Salesforce using Informatica Cloud platform processes.
Hands on Oracle database, SQL, PL/SQL, SQL performance tuning knowledge.
Worked on Salesforce frontend for data validating and issues resolutions once the data is loaded into UAT environment
Developing the deployment plan and facilitating UAT and production code movement.
Involved in Unit Testing, Integration, Regression TESTING.
Provides timely solutions for tickets raised through Jira/Rally QC Defect Tracking and deploying the custom scripts.
Identifying the production bugs and helping other team members to resolve the issues within the agreed SLA.
Resolve any unplanned\planned production downtimes on critical priority and notify Business Users regarding the status of the application availability.
Suggesting solution to bug-fixes, design, test case & post-implementation review.
Co-coordinating activities with the functional and technical teams, liasoning with the client counterpart and directing the activities at the offshore center.
Maintaining user groups and securities like creating new users and giving appropriate privileges as specified in the
Performance tuning of DB objects & Reports.
Prepared technical documentation and mapping documents (Excel/Word) for project processes.
Generic Managerial Skills • A good team player with strong ability to learn and adapt new skills and makes efforts to do the work at hand and manage time effectively
Able to handle multiple tasks and projects simultaneously.
Ability to lead and guide when required to junior staff