Sign In
 [New User? Sign Up]
Mobile Version

Sr. Datastage Architect/admin

Bengaluru, KA
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Design and develop Datastage, Quality Stage, Information Analyzer v 11.x client and server componentsDevelop and configure DS environments on a multi-tier infrastructure and plan for scalability and growthDesign & develop the Data Integration framework.Assimilate and understand the application architecture and develop ETL components that properly integrate with it Create documented designs and unit test plans.Develop code that promotes reusability, maintainability and good, scalable performance.Build and execute repeatable unit & regression test cases Conduct code reviews and mentor junior resources.Perform exploratory source data analysis, including ad-hocSQL queries, to proactively find and expose data quality problems or data thatviolate assumptions and business rules, and may cause unexpected output in thedeveloped solution. Effectively leverage automated data profiling tools when required.Support application development through system testing anduser acceptance testing, bridging the gap between business rules and technicalimplementation when necessaryCreate production support manuals and Support production deployment.Work closely with the TPM(Tech. Program Managers) to ensure tasks are identified and appropriately estimatedWork closely with CAG ( Core Arch. Group) Data Architects, Sr. ETL Developers, Subject Matter Experts to ensure ETL jobs are designed appropriately to meet the requirements Enhances ETL Framework and ensures that the framework is implemented in all jobsEstablishes and enforces standards for code reviews and unit test cases Creates and develops ETL jobs as well as data quality and cleansing routinesProvides the Quality Assurance team with all documentation necessary for testing Owns the ETL deployment process from environment to environmentAssist with data modeling and data architecture tasks when required May assist in one or more components of the overall architecture of the data warehouse systemConduct performance analysis and optimization of Data Services jobs Prepare, perform and document unit test and integration testsSupport ETL Team during QA, UAT and performance testing Assist the infrastructure team in coordinating and developing process automation/job scheduling and maintain a master schedule of all ETL jobs including dependencies, sources and targetsExperience10+ years of DataStage design and development experiencein a complex EDW environment.4+ Years of Quality Stage, Information Analyzer design and development experience5+ years working in a DataStage Architect capacity.5+ years working Datastage/QS in a Linux environmentExperience in two or more of the Infosphere Suitecomponents and architects solutions that leverage the entire suite capabilities(metadata, data quality & profiling). Demonstrates an in deep understanding of advanced parallel job development (parallel architecture,configuration files, stages and connectors, environment variables, parameters& routines)Ability to architect and design strong audit, balance andcontrol architectures with exception handling, data flow monitoring andreporting constructs.Experienced in architecting data acquisition, staging anddelivery strategies.Experience with Infosphere CDC, balanced optimization is aplus.Ability to write shell scripts and CMD statements for invoking and sequencing DS JobsKnowledge and/or experience with real-time development isa plusExperience using advanced performance monitoring/debuggingtechniques using data set management tools, environmental variables and jobmonitoring is required.Experience with metadata concepts and metadata interfacesis requiredExperience in source code control integration withexternal tools and code deployment is required.Experience or knowledge with Grid technology is a plus.Expert in performance & tuning of data integrationprocess. UNIX shell scripting experience is required.Strong RDBM skills (Oracle, SQL Server 2008, 2012). MPPexperience a plus.Strong English written and verbal communication skills.Strong understanding of BI Data Modeling (Star Schema) andhow it is designed
Additional Degree: BE/ B.Tech (Engineering) | B.Sc. (Science)

Experience: 10-14


Business/Systems Analysis | Database Administration (DBA) | Quality Assurance/Testing
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News