Job Description :
Hai,
Role Name : ETL Datastage Sr Developer
Location : Clinton NJ
Job Description :
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 DataStage 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 Datamarts 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.