Sign In
 [New User? Sign Up]
Mobile Version

Sr. Data Stage Developer

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

Job Details

Design & develop the Data Integration framework.Assimilate and understand the application architecture anddevelop ETL components that properly integrate with it Create documented designs and unit test plans.Develop code that promotes reusability, maintainabilityand good, scalable performance.Build and execute repeatable unit & regression testcases 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 ETL Architect and TPM(Tech. Program Managers) to ensure tasks are identified and appropriately estimatedWork closely with CAG ( Core Arch. Group) Data Architects, ETL Architects, 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 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 targetsExperience7-9 years of DataStage design and development experiencein a complex EDW environment.4+ Years of Quality Stage, Information Analyzer design and development experience4+ years working in a DataStage Sr. Developer capacity.4+ years working Datastage/QS in a Linux environmentDemonstrates an in deep understanding of advanced parallel job development (parallel architecture,configuration files, stages and connectors, environment variables, parameters& routines)Experience with Infosphere CDC, balanced optimization is aplus.Ability to write shell scripts and CMD statements for invoking and sequencing DS Jobs Knowledge 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
Degree: M.Com. (Commerce) | M.Pharm. (Pharmacy) | M.Sc. (Science) | MA (Arts) | MBA/ PGDM | MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 5-10


Application Programming | Database Administration (DBA) | Systems Programming
Applying for this job will take you to an external site


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